Browse by Tags

• SQL Server 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: I am running on 64 bit and all of my tasks are waiting on SOS_RESERVEDMEMBLOCKLIST, What is going on?

  This wait type represents waiting on multi page allocations inside of SQLOS's memory manager. As you remember from my description of memory manager's working internals, it has two major allocators single page allocator, SPA and multi page allocator, MPA. Read More... Posted Tuesday, November 14, 2006 1:29 PM by slavao | 3 Comments Filed under: Memory Management, Q&A