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

Maintenance Plans - Behind the Scenes Expand / Collapse
Author
Message
Posted Wednesday, May 22, 2002 12:00 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 11:48 AM
Points: 6,783, Visits: 1,879
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/maintenanceplansbehindthescenes.asp>http://www.sqlservercentral.com/columnists/awarren/maintenanceplansbehindthescenes.asp

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #4389
Posted Sunday, August 20, 2006 12:37 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, February 1, 2012 9:00 AM
Points: 65, Visits: 4

Good insight behind the scenes, Andy.

One of our customers has reported performance problems in the app. A trace revealed these "statman" selects were taking 20 seconds or more to complete. I suspected they were inpreparation for statistics being created or updated.

A good maintenance plan might proactively solve this customer's problem.

 

 

 

Post #302799
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse