March 2005 - Posts

• 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 | 6 Comments Filed under: SQL Server Memory Management, Coding & Debugging tips, Be Aware

• SQLOS Caching

  Yukon caching vs SQL2000 What makes Yukon memory management different from SQL2000 is elaborative caching framework. In SQL2000 there are two major caches: data page cache, called Buffer Pool and procedure cache, cache of query plans. Buffer Pool and Read More... Posted Friday, March 18, 2005 12:19 PM by slavao | 5 Comments Filed under: SQL Server Memory Management, SQLOS