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, December 11, 2014 6:47 AM
Points: 49, Visits: 437
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: Wednesday, December 17, 2014 8:47 AM
Points: 839, Visits: 1,198
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