SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Missing indexes in current requests

By HÃ¥kan Winther,

This script will get any current requests with missing indexes.

Execute the script to list the requests with missing indexes. If the script returns any records, investigate the cost of the query by looking at reads, logical reads, writes, row count, cpu time and total elapsed time to see if the query affects the performance. Look at the query plan to see the details of the index.

Before you implement any index, make sure there are no index you can improve to cover this missing index suggestion and test in your test environment

Total article views: 2708 | Views in the last 30 days: 2
 
Related Articles
FORUM

script included index

index include script

BLOG

INDEX DEFRAGMENTATION SCRIPT for SQL server 2000

  INDEX DEFRAGMENTATION SCRIPT SQL 2000 Index Defragmentation is one of the most important DBA tas...

SCRIPT

Script all Indexes

Generate scripts for all indexes in a database

FORUM

INDEX NAME, TAble Name, Index Script required.

INDEX NAME, TAble Name, Index Script.

FORUM

SSMS Index Scripting

Include caluses are not included when scripting indexes

Tags
 
Contribute