Get the 14 most used Key Performance Indicators  Read more...

This will show you the issue with current Merge join algorithm and a workaround for this and thus improving the performance of Merge joins  Read more...

Use your own optimizer to tune queries  Read more...

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...

This script can be used to view current SQL statements being executed for all or any one SPID.  Read more...

A conceptual proof for a google like search procedure  Read more...

This script will email info about the longest running SPID in an HTML formatted table  Read more...

A simple PBM policy which uses WMI to find out if the CPUs in the target are running at their maximum clock speed.  Read more...

This view reports almost everything you want to know about your indexes  Read more...

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...

Useful if you think a SQL statement, Function, or SPROC is taking too long to compile.  Read more...

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...

This procedure drops all manually added statistics (field user_created=1)  Read more...

Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!  Read more...

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...

A complete blocking report which gives the complete information about what queries are runninng and it will be worth capturing the details before we decide to kill the processes.  Read more...

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.  Read more...

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...

Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.  Read more...