This article has been archived. It is offered "as is" and will no longer be updated.
In Microsoft SQL Server 2005 or in SQL Server 2005 Service Pack 1 (SP1), you create a maintenance plan that contains an Update Statistics task. After you install SQL Server 2005 Service Pack 2 (SP2), the maintenance plan runs slowly.
This problem occurs because SQL Server 2005 SP2 applies the Full scan option on all the tables and on all the views in the Update Statistics task.
To work around this problem, specify a small sample size instead of using the Full scan option. For example, you can specify a sample size of 50 percent for the tables and for the views.
To specify a small sample size, follow these steps:
In SQL Server Management Studio, open the maintenance plan.
In the maintenance plan, double-click the Update Statistics task.
In the Update Statistics Task dialog box, click Sample by.
In the Sample by box, enter a small value, click Percent in the list next to the Sample by box, and then click OK.
Note The smallest sample size is 1 percent. When you specify a sample size of 100 percent, the effect is the same as when you use the Full scan option.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
SQL Server 2005 SP2 adds a feature for the Update Statistics task in a maintenance plan. By using this feature, you can use the Full scan option, or you can specify a sample size for the Update Statistics task. By default, SQL Server 2005 SP2 applies the Full scan option on all the tables and on all the views in the existing Update Statistics tasks.
For more information about the new features in SQL Server 2005 SP2, visit the following Microsoft Web site: