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
Sign in to ask a question


  • indexstats
    3 Posts | Last post January 29, 2013
    • As per script table = indexstats is missing.
      need script to creat this table = indexstats
    • 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 :))
    • 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