SQL Server performance queries

If a popular query does not have an associated index it will have a large impact on performance. This script identifies the queries without an index.

Here are some links with scripts that can help.

1. Find queries with missing indexes

2. Find Most Commonly Used Indexes

3. Find Long Running Queries

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.