online poker

Plan Caching in SQL Server 2008

Posted by: Delamater  :  Category: SQL Server Performance Tuning, White Papers

I had the pleasure of meeting Greg Low recently, a Microsoft Certified Master. Greg is an amazingly intelligent individual, with all kinds of SQL Server experience. Greg has updated the Plan Caching paper originally written for SQL 2005, and made it relevant for SQL 2008. You can find that paper located here. I encourage you to read it, it is amazingly important for anyone doing performance tuning.

Share/Save/Bookmark

SQL Server Wait Types

Posted by: Delamater  :  Category: SQL Server Performance Tuning

Been meaning to blog more, but yowsas, time flies by. Anyhoo, this link is great for determining the exact nature of a wait type, and what it means. Read more…

Share/Save/Bookmark