Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Missing Statistics Expand / Collapse
Author
Message
Posted Thursday, May 16, 2013 5:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 2:45 AM
Points: 47, Visits: 381
Good Day.
We are running SQL Server 2008R2 ENT and kept auto update stats and auto create stats enabled. We identified a performance issue and added the required index(es) in full . However performance did not improve. I then ran the query through the Database Engine Tuner which identified some statistics were missing . What I don't understand is that the indexes were created , but the required statistics were not .
Post #1453451
Posted Thursday, May 16, 2013 6:11 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:16 AM
Points: 811, Visits: 1,161
I would suggest you to read through this.

https://www.simple-talk.com/sql/performance/sql-server-statistics-questions-we-were-too-shy-to-ask/
Post #1453466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse