| Author |
Topic |
|
ashwinreddy.c
Starting Member
13 Posts |
 Posted - 2006-05-12 : 06:09:33
|
| Hi AllOne server has 1GB of memory; the other has 2GB's. I thought it would be good to get them both to at least 4GB. Besides having more memory available, what requirements/benefits are there to having 4GB's instead of what's currently installed? Are there any features we can't evaluate?Are there reasons we would want to go beyond 4GB's?RegardsAshwin ReddySQLServer DBA |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-12 : 07:22:44
|
| What edition of SQL Server are you using, Standard Ed. 2000 will only use 2GB. (Though there would be free memory for other apps in that case.)-------Moo. :) |
 |
|
|
ashwinreddy.c
Starting Member
13 Posts |
Posted - 2006-05-12 : 09:52:21
|
| Iam sorry i forgot to mention the SQL Server version. well iam planning to for SQL Server 2005RegardsAshwin ReddySQLServer DBA |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-12 : 12:26:44
|
| "Iam sorry i forgot to mention the SQL Server version"The clue was in your subject!Kristen |
|
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2006-05-12 : 15:37:17
|
| SQL 2000 Standard can use 3gig if one uses the /3GB switch in the boot.ini. The extra 1 gig will be used by SQL for data cache. Therefore, SQL could use 3gig and leave 1gig for the OS...DeWayne |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-12 : 15:40:45
|
| Since this is SQL Server 2005, it is important to find out if you will be using 64-bit architecture. There is an excellent article about it in SQL Server Magazine's May 2006 issue.Tara Kizeraka tduggan |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-12 : 15:53:47
|
quote:
Originally posted by DMcCallie
SQL 2000 Standard can use 3gig if one uses the /3GB switch in the boot.ini. The extra 1 gig will be used by SQL for data cache. Therefore, SQL could use 3gig and leave 1gig for the OS...DeWayne
SQL Server 2000 Standard Edition is limited to 2 GB, with or without the /3GB switch.CODO ERGO SUM |
|
|
|
ashwinreddy.c
Starting Member
13 Posts |
Posted - 2006-05-13 : 08:43:38
|
| Hi allThanks for your replies.Well Iam looking at the features which can't be evaluated if there wouldn't be 4GB of memory for SQL Server 2005 Enterprise edition or standard edition.RegardsAshwin ReddySQLServer DBA |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-05-14 : 14:32:31
|
| The features that can't be evaluated? You can evaluate any features with less than 4GB of RAM. Many of them might not work very well, but you can still evaluate them. Massive queries, large data and plan caching (and the performance gains from it), and anything involving analysis services would be key areas that will suffer with less RAM.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-15 : 04:31:53
|
quote:
Originally posted by Kristen
"Iam sorry i forgot to mention the SQL Server version"The clue was in your subject!
Bah, details.  -------Moo. :) |
|
|
|
|
SQL Server 2005 + 4GB of Ram