June 2005 - Posts

• 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

• Q and A: Controlling size of a single cache in SQL 2005

  Q: I have teaching a class on Yukon for the Ascend program, and the class had a question I wanted to double check before answering. On an Itanium with 1 TB of RAM, the class’ curiosity asked, “If plan cache is very large “Then how does Plan Cache lookups Read More... Posted Friday, June 03, 2005 11:08 AM by slavao | 2 Comments Filed under: SQL Server Memory Management, Q&A

• Q and A: Max memory with sql server 2000 / win2003 x64

  Today, I received following question Q: Slava, I have a question for you. Sql 2000 is documented to support a maximum of 64GB when used with 2000 datacenter edition. I assume this is the limit of 2000 Datacenter, but is it also a limit defined in sql Read More... Posted Friday, June 03, 2005 10:06 AM by slavao | 3 Comments Filed under: Q&A