Browse by Tags

• Coding & Debugging tips
• Memory Management
• SQL Server Memory Management
• SQL Server Scheduling
• SQLOS

• 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: To Hyper or not to Hyper

  Our customers observed very interesting behavior on high end Hyperthreading (HT) enabled hardware. They noticed that in some cases when high load is applied SQL Server CPU usage increases significantly but SQL Server performance degrades. Occasionally Read More... Posted Saturday, November 12, 2005 12:48 PM by slavao | 35 Comments Filed under: Coding & Debugging tips, SQL Server Scheduling, 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 | 9 Comments Filed under: SQL Server Memory Management, Memory Management, Be Aware

• Be Aware: IA64 Stack Size

  Stack subject in Windows OS is fascinating. There are so many interesting technical problems surrounding it. The moment you think you fully understand everything about stack you suddenly discover yet another mystery. And so it goes. In the last couple Read More... Posted Saturday, March 19, 2005 1:35 PM by slavao | 11 Comments Filed under: SQL Server Memory Management, Coding & Debugging tips, Be Aware

• Be aware: FLS-Fiber Local Storage

  Problem: In the last several months there were several publications describing usage of fibers. When covering SQLOS's scheduling I will go into more details about them. Today I would like to touch on the subject on how to make your dlls/libraries more Read More... Posted Monday, February 28, 2005 11:23 AM by slavao | 2 Comments Filed under: SQL Server Scheduling, SQLOS, Be Aware

• Be aware: a new section in my blog

  Periodically, I bump into unusual behavior, features, of compiler, operating system, strange design and coding decisions made by someone else that makes me wonder. After giving it some thought, I often come to the conclusion that behavior or observed Read More... Posted Tuesday, February 22, 2005 1:12 AM by slavao | 2 Comments Filed under: Coding & Debugging tips, Be Aware