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 ««12

Database Engine Tuning Wizard recommendation for creating stats Expand / Collapse
Author
Message
Posted Thursday, January 28, 2010 11:10 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:20 AM
Points: 21,092, Visits: 14,769
I would suggest getting to know how to read execution plans. Knowing how to read your execution plan can help you to understand index usage and indexes that may or may not be needed to improve your costly queries.

There are also scripts in the ssc scripts section for rating your indexes. You might want to look some of those up and test-drive a few of them.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #855508
Posted Saturday, June 29, 2013 12:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:52 AM
Points: 287, Visits: 289
Are these statblobs created with CREATE STATISTICS recommendations from the DTA auto updated like index statistics?
Post #1468774
Posted Saturday, June 29, 2013 7:03 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:06 PM
Points: 42,332, Visits: 35,383
Yes


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1468793
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse