Running Index Tuning Wizard (ITW) or Database Engine Tuning Advisor (DTA) on production machines…

Index Tuning Wizard (ITW in SQL Server 2000) or Database Engine Tuning Advisor (DTA in SQL Server 2005) allow you to analyze a workload and make recommendations for the database based on the workload. The recommendations are schema changes, partitioning or indexed view creation for example. During the recommendation process, ITW or DTA can create…

3

New trace flag for deadlock output and profiler deadlock event enhancement

Did you know that SQL Server 2005 adds a new trace flag (-T1222) for deadlock trace output? This deadlock output has numerous improvements over older versions of SQL Server. For example, some of the enhancements of the new grace flag are:   1. XML like output for the deadlock 2. Execution stack at the time of…

1