Who's Active, What Are They Doing, and Who is Blocked?

OS Wait Tasks

Various scripts to display the Operating System resources that tasks are currently waiting on ... Source : Slava Osk - Blog Post

Retrieve Index Usage Statistics

The sys.dm_db_index_usage_stats view allows you to determine which indexes are used only lightly (sum of user columns) and to determine which indexes are incurring maintenance overhead (user_updates column). You may want to consider dropping indexes that incur maintenance overhead, but are used infrequently for queries ... Source : Microsoft.com - Technet Article

Reorganising and Rebuilding Indexes

This BOL article shows how the sys.dm_db_index_physical_stats function can be used to measure fragmentation and discusses the various rebuild options based on the level of fragmentation ... Microsoft.com - MSDN Article

Find table and index name for fragmented indexes

A simple but effective script from Tibor that uses a function and DMV's to return the table and index names of all indexes exceeding a certain fragmentation level ... Tibor Karaszi - SQLblog.com - Blog Post

Statements with the highest average CPU time

Lists the top 50 statements by average CPU time ... Source : Microsoft.com - Technet Article

Determine the space used by objects in TempDB

Script from Aaron Bertrand to display the breakdown of object usage within TempDB ... Source : Kevin Kline - SQLBlog.com - Blog Post

Compare Single-Use and Re-Used Plans

Displays the number of single use plans compared to multiple use plans. The number of single use plans should be a low percentage of the total. This script also displays the cache size of single use plans ... Source : Microsoft.com - Technet Article

Compare Signal Waits and Resource Waits

Sample script that compares signal waits and resource waits. Signal waits are the time spent in the runnable queue waiting for the CPU, while resource waits are the time spent waiting for the resource ... Source : Microsoft.com - Technet Article

Find rows where any column is Null or Zero

SQLIOSim

SQLIOSim is a correctness and stress tool (not a performance measurement tool).  Use this to verify your IO subsystem is functioning correctly under heavy loads. In this SQL Server Storage Engine Blog post, links are provided for download, and the usage of the tool is discussed ... Source : Microsoft.com - MSDN Article

SQLIO Disk Subsystem Benchmark Tool

SQLIO is a tool provided by Microsoft which can be used to determine the I/O capacity of a given configuration ... Source : Microsoft.com - Download

A SQL Server 2005 Dynamic Management View Performance Data Warehouse

Microsoft SQL Server 2005 provides Dynamic Management Views (DMVs) to expose valuable information that you can use for performance analysis. DMVstats 1.0 is an application that can collect, analyze and report on SQL Server 2005 DMV performance data. ... Source : Codeplex.com

SQL Server query performance testing tool

A great (free) tool from Adam Machanic that allows you to perform simple load testing of a stored procedure or T-SQL command. It allows randomization of parameters and includes basic reporting of resource use. This is a great tool for testing contention issues and validating performance increases/decreases from code changes ... Source : DataManipulation.net

Netmon3

Many times, the key to solving "general network errors" errors is a network packet trace.  The problem is that these errors are often thrown intermittently.  This can obviously make it problematic to capture a network trace. Network Monitor 3 (AKA Netmon3) solves this problem quite nicely ... Source : Evan Basalik - Microsoft SQL Server Support Blog - Blog Post

Database Publishing Wizard

The Database Publishing Wizard enables the deployment of SQL Server 2005 databases (both schema and data) into a shared hosting environment on either a SQL Server 2000 or 2005 server ... Source : Codeplex.com

SQL Server 2005 Best Practices Analyzer

Use this tool to scan your SQL Server systems and verify that common best practices have been implemented ... Source : Microsoft.com - Download

SQL Server 2005 Performance Dashboard Reports

The Microsoft SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later ... Source : Microsoft.com - Download

SQL Server Health and History Tool (SQLH2)

The Microsoft SQL Server Health and History Tool (SQLH2) allows you to collect information from instances of SQL Server, store this information, and run reports against the data in order to determine how SQL Server is being used ... Source : Microsoft.com - Download

SQL Server 2005 System Views Map

Download the Microsoft SQL Server 2005 System Views Map which show the key system views and their relationships in SQL Server 2005 ... Source : Microsoft.com - Download

SQL Server Integration Services Log provider reports using SQL Server Reporting Services

This report pack is a collection of SQL Server 2005 Reporting Services reports. The reports are designed to filter, analyze, and organize Log and Error row data generated by SQL Server 2005 Integration Services (SSIS). ... Source : Microsoft.com - Download

Microsoft SQL Web Data Administrator

The SQL Server Web Data Administrator enables you to easily manage your SQL Server data, wherever you are ... Source : Microsoft.com - Download