开发者

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).

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜