Browse by Tags

• Memory Management

• Q and A: Ratio between AWE Allocated and VM Committed/Reserved in DBCC MEMORYSTATUS output

  Q: What kind of ratio should you expect to see between AWE Allocated and VM Committed/Reserved? We are running 8GB with a cap of 7GB in the max server memory and yet the VM Committed is around 100MB. I was first shocked to see that the sqlservice in task Read More... Posted Tuesday, January 02, 2007 8:02 PM by slavao | 1 Comments Filed under: SQL Server Memory Management, Memory Management, Q&A

• Q & A: Does SQL Server always respond to memory pressure?

  Q: I thought I've seen reference recently to problems with SQL2005 not releasing memory when under pressure, and this was possibly due to the Lock Pages In Memory option. We have a server where this seems to be happening, i.e. SQL2005 uses all available Read More... Posted Monday, November 13, 2006 3:39 PM by slavao | 8 Comments Filed under: SQL Server Memory Management, Q&A