Automatic Statistics Update Slows Down SQL Server 2005

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Posted on SQL Server Central See other posts from SQL Server Central
Published on Fri, 25 Feb 2011 07:00:00 UT Indexed on 2011/02/25 23:30 UTC
Read the original article Hit count: 215

Filed under:
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.
SQL Backup 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.

© SQL Server Central or respective owner

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Categories cloud

.NET ASP.NET iphone linux python Windows mysql android sql windows-7 html c ruby-on-rails css objective-c ubuntu networking sql-server wpf asp.net-mvc ruby database Xml apache AJAX osx security regex django Performance 12.04 windows-xp mac web-development iphone-sdk vb.net Silverlight apache2 flash server perl best-practices email installation eclipse visual-studio algorithm windows-server-2008 winforms wcf firefox bash dns /Oracle