Sign in
 
HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog

Analyze Index Statistics

Sample stored procedure that analyzes index statistics, including accesses, overhead, locks, blocks, and waits. The order of execution is as follows: 1) Truncate indexstats with t

 
 
 
 
 
3 Star
(1)
Add to favorites
Databases
8/10/2009
E-mail Twitter del.icio.us Digg Facebook
  • Hide
    indexstats
    3 Posts | Last post January 29, 2013
    • Written June 02, 2010 
      As per script table = indexstats is missing.
need script to creat this table = indexstats
    • Written January 16, 2011 
      Who tested this script and how? It fails to create dependencies on SQL 2005 on Win2003 R2 x64. If you ignore that error and try to execute the sp, then you realize - as the previous poster had pointed out - the script is trying to access a table called indexstats, and that table does not exist. Way to go team sql scriptors :))
    • Written January 29, 2013 
      Hey guys,

I might be too late to answer your question but still I thought it might be useful.
The reason why the scripts is lacking the indexstats is because this table is created in a related script.
I give you the two scripts and their utility:
 - http://gallery.technet.microsoft.com/scriptcenter/2e6a15f5-ae04-4f76-ab15-b6141d7b1811. this one is the create/truncate indexstats which is referred as step 1
 - http://gallery.technet.microsoft.com/scriptcenter/448a25dd-ee80-4345-90f1-28d479bbfa5f. This one is the retrieve index statistics which is referred as step 2 and 4.

Hope it will help someone

Cheers

Fred