Browse by Tags

• Memory Management
• SQL Server Memory Management
• SQL Server Scheduling

• 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: 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: 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