Memory capacity on Win2k and Windows 2003

Question

Post reply

Memory capacity on Win2k and Windows 2003

tyang

SSCrazy

Points: 2231
More actions
December 13, 2005 at 8:16 am

#152661

I have a SQL ENT running on Windows 2003 ENT server with 8 processors and 8GB memory, the server is 32 bit. I enabled AWE, did not have PAE switch. When I check the memory usage from sysperfinfo, the Target Server Memory and Total Server Memory are same and using 8GB of memory. But in Task Manager, sqlservr.exe only uses 93MB of memory. What could be the problem?
Does anyone know if there is updated information on memory and processors capacity for SQL 2k ENT and SQL 2005 running on Windows 200 and Windows 2003 (32 bit and 64 bit)?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 1

Dont know if it will fully answer your question but here's a link i came across the other day

http://msdn2.microsoft.com/en-us/library/ms178067.aspx

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 2

Looks like 8GB for SS2K (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp)

2005 is limited by Windows (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx) and W2K Ent is 8GB, W2K3 Ent is 1TB on 64-bit (http://www.microsoft.com/windowsserver2003/64bit/x64/enterprise.mspx)

tyang SSCrazy Points: 2231 More actions · Answer 3

If SS2k ENT support 8GB of memory on Window 2003, does AWE or PAE still need to be enabled?

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 4

Important .. task manager does not report actual memory usage when awe is enabled. The values in sysperinfo table are correct, I use this as a question for DBA's in interviews < grin >

W2003ent will support 32gb ram with sql2k ent .. I'm running such a server. Make sure you set the memory upper and lower to be the same, somewhere around 7Gb or less , your choice. If you're using awe you must not use dynamic memory allocation

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/