Aaron is a senior consultant for
SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a
Microsoft MVP since 1997; tweets as
@AaronBertrand; and speaks frequently at user group meetings and
SQL Saturday events.
Last week, Ola published a very useful update to his Backup, Integrity Check and Index Optimization scripts: the solution now supports updating statistics. There are several options, such as only updating when the data has been modified and using the RESAMPLE and NORECOMPUTE options. An example call:
EXEC dbo.IndexOptimize
@Databases = 'USER_DATABASES',
@FragmentationHigh_LOB = 'INDEX_REBUILD_OFFLINE',
@FragmentationHigh_NonLOB = 'INDEX_REBUILD_ONLINE',
@FragmentationMedium_LOB = 'INDEX_REORGANIZE_STATISTICS_UPDATE',
@FragmentationMedium_NonLOB = 'INDEX_REORGANIZE_STATISTICS_UPDATE',
@FragmentationLow_LOB = 'STATISTICS_UPDATE',
@FragmentationLow_NonLOB = 'STATISTICS_UPDATE',
@UpdateColumnStatistics = 'Y',
@OnlyModifiedStatistics = 'Y';
|
If you haven't already tried Ola's maintenance solution, I highly suggest you check it out.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About AaronBertrand
...about me...