开发者

SQL Server isn't allocating memory

开发者 https://www.devze.com 2023-03-16 14:11 出处:网络
I\'ve got a Windows Server 2003 Enterpise SP2 server with SQL Server 2005 SP2 Enterprise installed.The server has 6gb of ram installed.The SQL Server is set with a minimum memory seting of 2048mb and

I've got a Windows Server 2003 Enterpise SP2 server with SQL Server 2005 SP2 Enterprise installed. The server has 6gb of ram installed. The SQL Server is set with a minimum memory seting of 2048mb and a max of 4096mb. However, currently the entire server is using 2.8gb of memory and sql server has 1.7gb.

From my understanding SQL Server should, at the very least, grow to the开发者_C百科 minimum memory level and then stay between the min and max, but it's not. It's staying at about 1.7gb. Could something be forcing sql server to not allocate more memory?


Minimum memory only defines a level that SQL Server will not drop below again, it won't fill this up preemptively. Also note that the min/max memory levels only affect the buffer pool - memory is used for many other things in SQL Server, though the buffer pool is by far the largest consumer.

Once your SQL Server consumes 2GB+, it won't let the buffer pool drop below that 2GB minimum.

0

精彩评论

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