Browse by Tags

• Be Aware
• Coding & Debugging tips
• Q&A
• 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

• Be Aware: 4GB of VAS under WOW, does it really worth it?

  By now you have heard a lot about the fact that under WOW a 32 bit process can get 4GB of VAS. I agree this is great, but I would like you to be aware of something that might hit you really hard. As it turns out enabling 4GB VAS can be problematic due Read More... Posted Sunday, March 12, 2006 8:12 PM by slavao | 7 Comments Filed under: SQL Server Memory Management, Memory Management, Be Aware

• Be Aware: VirtualAlloc with MEM_RESERVE can fail even if you have plenty of VAS inside of the process

  Many developers assume that if you have plenty of free VAS in your process VirtualAlloc ( http://msdn.microsoft.com/library/default.asp?url=/library/en-us/memory/base/virtualalloc.asp ) and VirtualAllocEx ( http://msdn.microsoft.com/library/default.asp?url=/library/en-us/memory/base/virtualallocex.asp Read More... Posted Friday, June 03, 2005 1:04 PM by slavao | 0 Comments Filed under: Coding & Debugging tips, Memory Management, Be Aware

• Be Aware: Using AWE, locked pages in memory, on 64 bit

  We have already talked about Windows AWE mechanism on 32 bit and how SQL Server utilizes it. Today I would like to go over AWE & related mechanism on 64 bit platforms. To some people it comes as a surprise that AWE mechanism is still present and actually Read More... Posted Friday, April 29, 2005 9:23 AM by slavao | 4 Comments Filed under: SQL Server Memory Management, Memory Management, Be Aware

• Look at Memory Leaks - Classify and Identify

  In my previous post I talked about type of Memory Pressures. Today I would like to talk about related subject – Memory Leaks. Before you continue reading please make sure that you are familiar with how memory is managed on Windows. Memory leaks are bugs Read More... Posted Friday, February 04, 2005 12:16 PM by slavao | 0 Comments Filed under: Coding & Debugging tips, Memory Management

• Memory Pressure - Classified

  So far I touched on subjects that have been widely discussed in the industry. Today I would like to talk about a subject that you would hardly find information about: memory pressure.. On a surface the subject appears simple but in reality this is not Read More... Posted Tuesday, February 01, 2005 9:11 AM by slavao | 10 Comments Filed under: SQL Server Memory Management, Memory Management

• A look at Windows Virtual Memory mechanisms (continuation of "A look at Virtual Address Space - VAS")

  As I promised last time here comes next post on memory J . Remember, my eventual goal is to reveal how memory management works in SQL Server but for you to really appreciate it, I think, you do need to get good feeling on how Windows manages memory. Understanding Read More... Posted Saturday, January 29, 2005 5:00 PM by slavao | 11 Comments Filed under: SQL Server Memory Management, Memory Management

• A look at Virtual Address Space - VAS

  Memory is a set of common resources shared by applications, their components and operating system. One needs to be very specific when referring to a given memory resource. Mistakenly, in many cases, developers, users, DBAs refer to different memory resources Read More... Posted Thursday, January 27, 2005 11:43 AM by slavao | 7 Comments Filed under: SQL Server Memory Management, Memory Management