SQL server performance diagnostics tool

PSSDIAG data collection utility


PSSDIAG is a general purpose diagnostic collection utility that Microsoft Product Support Services uses to collect various logs and data files. PSSDIAG can natively collect Performance Monitor logs, SQL Profiler traces, SQL Server blocking script output, Windows Event Logs, and SQLDIAG output.


http://support.microsoft.com/kb/830232





RML Utilities for SQL Server (x86)

Tools to help database administrators manage the performance of Microsoft SQL Server.

http://www.microsoft.com/downloads/details.aspx?FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en

SQL Nexus Tool


Tool that helps you identify the root cause of SQL Server performance issues


http://www.codeplex.com/sqlnexus










DbDiff - DbScripting (without dmo,smo)


Compare MSSql database structures. (Sql 7,Sql 2000,Sql 2005)


http://www.codeplex.com/DbDiff