Win 2008 Server R2 with SQL Server 2000 memory not fully used
We have a Windows 2008 Server R2 Enterprise x64 with 32gb. We are also still using SQL Server 2000 Enterprise. 开发者_JAVA技巧
I have been monitoring the memory usage and it is only using 17.3GB total. I have set SQL server to use AWE with a max memory usage of 29gb.
Any ideas how to allow/get SQL server to use the extra ram?
Thanks
The reason it is not using all memory is because it doesn't need it.
SQL Server is very good at managing it's own memory. The sizes of the databases you gave, fit into 11GB of RAM, that leaves 6.3 GB for internal structures such as buffers, plan cache etc. (more than enough).
精彩评论