Article ID: 953117 - View products that this article applies to.
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:
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:
Contact us for more help
Connect with Answer Desk for expert help.