Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
webkyaw
Starting Member
1 Post |
 Posted - 2004-09-24 : 15:30:06
|
| Okay based on what i have read SQL server on Win2k server can only utilize 2GB of RAM. I understand that on Win2k server enterprise and datacenter editions you can do the /3GB switch in boot.ini but what about regular win2k server? Is there anyway to get SQL server to utilize more than 2GB of physical memory? Thanks for any info. |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-25 : 05:55:43
|
| Enterprise can do 64GB of memory - should be enuf I expect (if not then use Oracle - lol!) (8GB on Windows 2000 Advanced Server, for more than that you need Windows 2000 Data Center).However, if you ahve got an application taht needs more then 2GB of memory for SQL I reckon your budget should be able to afford a whole raft of plush hardware, and the license cost of Enterprise Edition should be a drop in the ocean.More specifically, what is your concern if you were to be constrained to 2GB of RAM?Kristen |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-25 : 20:14:34
|
| Which ironically you are, if you only have Window2 2000 Standard Server and SQL Server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-26 : 02:48:40
|
| You guys over the pond are begining to get the hang of Irony, aren't you?<bg>Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-26 : 12:17:59
|
| I don't know what you're talking about.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-26 : 13:33:36
|
| Q.E.D. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-26 : 14:31:08
|
| 32bit editions can access a max of 3GB using the /3Gb switch. you can access more memory if you use the enterprise editon or datacenter edition of win2k, but then you need to use the AWE extensions which completely suck.If you need to address more memory than 2 or 3GB for SQL Server, think about implementing the 64bit edition instead. you may want to wait until the release of SQL 2005 for this, as it will run 64bit on the AMD opteron and Intel 64bit xeon systems.Right now 64bit is relegated to the Itanium 2 platform, which is a little more expensive than opteron or xeon systems.-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-27 : 02:21:46
|
| I would like to know why webkyaw thinks s/he needs more than 2GB, and if there is a genuine need why the budget won't stretch to Enterprise (or even 64bit for that matter)Kristen |
|
|
|
|
|
|
|
|
make SQL server on Win2k server use over 2GB?