THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Aaron Bertrand

Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features, and also blogs at blogs.sentryone.com and SQLPerformance.com; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

Ola Hallengren adds STATISTICS support to his solution

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.

 

Published Monday, December 13, 2010 3:56 PM by AaronBertrand

Comments

No Comments
New Comments to this post are disabled

About AaronBertrand

...about me...

This Blog

Syndication

Archives

Privacy Statement