Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
muratos
Starting Member
22 Posts |
 Posted - 2011-08-01 : 07:44:03
|
| Hi, I have a server which was set 17000MB as "Maximum Server Memory" and Total physical memory is 20GB. I had restarted the service two weeks ago and it finally reached the limit. I suspect that I am allocating too much memory for SQL Server and want to transfer 4GB to another server which is under memory pressure. (Sysadmin said that there is VMWare program for virtual allocation which I don't know the details and it is possible). How can I know if there is too much unused space in Sql Server memory and I can decrease the max memory setting? I run the DBCC MemoryStatus and the output for Buffer Pool is the following:I know they are in 8K pages. So, Database value would be 10341 MB.Committed 2121920Target 2176000Database 1323704Dirty 53665In IO 0Latched 0Free 334629Stolen 463587Reserved 0Visible 2176000Stolen Potential 1603613Limiting Factor 17Last OOM Factor 0Page Life Expectancy 711954 |
|
|
|
|
|
DBCC MemoryStatus Buffer Pool Values