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

Stats Updates Expand / Collapse
Author
Message
Posted Friday, May 2, 2008 6:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, September 12, 2009 9:12 PM
Points: 65, Visits: 224
Hi,

We need to create a maintenance paln to make sure that all tables/indexes/views are calculated with new statistics updates

Is there any other method to do the same



Regards,
Smm
Post #494159
Posted Friday, May 2, 2008 7:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 29, 2015 8:28 AM
Points: 2,658, Visits: 6,051
Just out of curiosity, do you have auto-stats turned on? Is it not doing a good enough job for you?

You can see the following from BOL to get more information on updating statistics.
http://msdn.microsoft.com/en-us/library/ms187348.aspx

You could use the example to update all the stats for a particular table and wrap that inside of the undocumented sp_MSforeachTable stored procedure to recompute stats for all of your tables...

-Luke.


To help us help you read this

For better help with performance problems please read this
Post #494209
Posted Tuesday, July 14, 2015 7:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 14, 2015 7:07 AM
Points: 1, Visits: 0
Luke L (5/2/2008)
Just out of curiosity, do you have auto-stats turned on? Is it not doing a good enough job for you?

You can see the following from BOL to get more information on updating statistics.
http://msdn.microsoft.com/en-us/library/ms187348.aspx

You could use the example to update all the stats for a particular table and wrap that inside of the undocumented sp_MSforeachTable stored procedure to recompute stats for all of your tables...

-Luke.


Hi Luke,

Can you please let me know how to check the details of update statistics which ran on database after a particular date.

Ex: How to find on which tables update stats ran after jun27th on a particular database ?
Post #1702643
Posted Tuesday, July 14, 2015 7:13 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 @ 7:52 AM
Points: 42,495, Visits: 39,299
Please post new questions in a new thread. Thank you.


Gail Shaw
Microsoft Certified Master: SQL Server, 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 #1702645
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse