Grant Fritchey Controlling Execution Plans with Hints The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best... 12 November 2009 38 min read
Laerte Junior Reducing I/O with the ‘Missing Indexes’ DMVs Laerte recently experienced an I/O nightmare, which, as a happy accident, gave him an opportunity to test out the 'Missing... 09 October 2009 14 min read
Brad McGehee Mastering SQL Server Profiler – eBook Download Download Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool.… 07 October 2009 2 min read
Grant Fritchey SQL Server Execution Plans – eBook Download Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have... 07 October 2009 1 min read
Gail Shaw SQL Server Performance Investigation Part 2: Execution Plan Analysis, Index Design, and Post-Implementation Measurement Part 2 of a SQL Server performance investigation: examining the execution plans of the worst-offending procedures identified in Part 1,... 03 April 2009 28 min read
Gail Shaw SQL Server Performance Investigation Part 1: Server-Side Trace, Aggregated Execution Statistics, and Identifying Worst-Offender Procedures Part 1 of a SQL Server performance investigation walkthrough - setting up a server-side trace, filtering it to capture the... 09 March 2009 13 min read
Grant Fritchey Understanding More Complex Query Plans In order to be able to tackle performance issues in SQL Server , and write effective SQL, it is essential... 26 February 2009 30 min read
Brad McGehee How to Identify Slow Running Queries with SQL Profiler With SQL Server Profiler, it is easy to discover all those queries that are running slowly. Once poorly performing queries... 03 February 2009 40 min read
Grant Fritchey Graphical Execution Plans for Simple SQL Queries Learning how to read and analyze execution plans takes time and effort. But once you gain some experience, you will... 16 December 2008 41 min read
Mario Broodbakker Investigating SQL Server 2008 Wait Events with XEVENTS Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy... 24 July 2008 9 min read
Grant Fritchey Execution Plan Basics Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up... 11 May 2008 44 min read
Grant Fritchey SQL Server Performance Crib Sheet Grant Fritchey provides an eagle-eye view of effective tools, strategies and techniques for SQL Server performance measurement, tuning and testing.… 31 May 2007 33 min read
Mario Broodbakker Taking the Guesswork out of SQL Server Performance Profiling Part 2 SQL 2005 wait event statistics are a good step forward, but are only useful for isolated testing, and to get... 18 May 2007 21 min read
Mario Broodbakker SQL Server Wait Events and CPU Time: The YAPP Method for Performance Profiling Applying the YAPP (Yet Another Performance Profiling) method to SQL Server performance diagnosis - combining wait event data with CPU... 22 March 2007 16 min read
Grant Fritchey SQL Server Performance Testing When faced with two viable solutions to a badly compromised database design, one using clustered indexes and the other compound... 15 May 2006 2 min read
Andy Warren Performance tuning tips for database developers Performance tuning is not easy and there aren't any silver bullets, but you can go a surprisingly long way with... 17 May 2005 4 min read
