question

grazer avatar image
grazer asked

Memory usage - SQL Server 2005 Standard

Hello, We are running SQL Server 2005 standard on a Windows Server 2003 R2 Standard box with 4GB RAM. Am I correct in thinking that increasing our memory will give no performance improvements at all? Regards, Graham
sql-server-2005sqlmemory
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
No, you can enable the server to use more than 4 GB of ram. I have several Windows 2003 box with 16 GB of ram and SQL performs much better when it has the right amount of memory. Once you add more memory, enabled AWE on your SQL Server, the the max memory to the right size (leave enough for the OS), and enable the 3GB and PAE in your boot.ini file.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
"It depends". Principally on your OS - are you running on 64-bit, or 32-bit? See for the memory limits. SQL Server itself is limited to the memory that the OS can support - no shock there. If you do boost the memory, it may be worth investigating the "Lock pages in memory" permission for the SQL server service - see for more details. But, if you do do this, remember to set a maximum memory size of, say, 3GB less than the system total (more if you are running other apps on the server), to give the OS room to manouevre.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.