SQL Server Engine Tips

Guidelines, Best Practices, TSQL and SQL Programming Tips & Tricks.

This Blog

About
Email

Syndication

Search

News

These postings are provided
"AS IS" with no warranties,
and confers no rights.
Use of included script samples
are subject to the terms
specified at http://www.microsoft.com/ info/cpyright.htm.

SQL Server 2005

SQL Server Document Links

Browse by Tags

All Tags » Performance - Tools (RSS)

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 Read More...

Posted Tuesday, February 14, 2006 6:58 PM by SQL Server Engine Team | 3 Comments

Filed under: Performance - Tools

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 Read More...

Posted Tuesday, February 14, 2006 3:46 PM by SQL Server Engine Team | 1 Comments

Filed under: Performance Troubleshooting, Performance - Tools