Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Maintenance, statistics Rss

   Items 1 to 2 of 2   
 

Automatic Statistics Update Slows Down SQL Server 2005

I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.  Read more...
By Additional Articles 2011/02/25 | Source: MSSQLTips.com | Category: maintenance
Rating: (not yet rated)  Rate this |   Briefcase | 4,664 reads

Drop user statistics

This procedure drops all manually added statistics (field user_created=1)  Read more...
By Wilfred van Dijk 2009/06/11 | Source: SQLServerCentral.com | Category: maintenance
Rating: (not yet rated) |  Discuss |   Briefcase | 568 reads
   Items 1 to 2 of 2   
 
Tags
performance tuning (1)