Database Reference
In-Depth Information
Auto Update Statistics
This feature should usually be left on, allowing SQL Server to decide on the appropriate execution plan as the
data distribution changes over time. Usually the performance benefit provided by this feature outweighs the cost
overhead. You will seldom need to interfere with the automatic maintenance of statistics, and such requirements
are usually identified while troubleshooting or analyzing performance. To ensure that you aren't facing surprises
from the automatic statistics features, it's important to analyze the effectiveness of statistics while diagnosing SQL
Server issues.
Unfortunately, if you come across an issue with the auto update statistics feature and have to turn it off, make
sure to create a SQL Server job to update the statistics and schedule it to run at regular intervals. For performance
reasons, where possible, ensure that the SQL job is scheduled to run during off-peak hours.
You can create a SQL Server job to update the statistics from SQL Server Management Studio by following these
simple steps:
1.
Select ServerName SQL Server Agent Jobs, right-click, and select New Job.
2.
On the General page of the New Job dialog box, enter the job name and other details, as
shown in Figure 12-39 .
Figure 12-39. Entering new job information
 
Search WWH ::




Custom Search