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

Content with tags Indexing, Performance Monitoring Rss

   Items 1 to 2 of 2   

Retaining historical index usage statistics for SQL Server - Part 3

In this, the third of the four part series on persisting the rowset results from the indexing Dynamic Management Views cached in temporary internal SQL Server structures we will explore what is required to store the missing index-related metadata.  Read more...
By Additional Articles 2009/07/20 | Source: MSSQLTips.com | Category: indexing
Rating:  Rate this |   Briefcase | 2,025 reads

Finding Execution Time of a SQL Statement

Capturing the execution time for rebuilding an index for set of tables.  Read more...
By Prashanth Jayaram 2008/12/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,601 reads
   Items 1 to 2 of 2