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.
Join SQL Backup’s 35,000+ customers to compress
and strengthen your backups
"SQL Backup will be a REAL boost to any DBA lucky enough
to use it." Jonathan Allen.
Download a free trial now.