Backup, Integrity Check and Index Optimization - CTP
Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization (Best Free Tool - Gold)
scripts, a solution based on stored procedures, functions, sqlcmd and SQL Server Agent jobs.
He makes some interessting Updates for us - in his new CTP version of IndexOptimize!
- UPDATE 05 Dec 2010 - New CTP version of IndexOptimize with the following changes.
Support for updating of statistics with the option RESAMPLE. Set @StatisticsResample = 'Y' to use this option. - Thanks Ola :-))
Update statistics using NORECOMPUTE on statistics that has auto update statistics disabled.
Only query sys.dm_db_index_physical_stats to check the fragmantation if it's needed to decide what action that should be performed.
Support for only updating statistics when the data has been modified. Set @OnlyModifiedStatistics = 'Y' to use this option.
- UPDATE 01 Dec 2010 - The most requested feature in IndexOptimize for a long time has been support for updating of column statistics. I now have a CTP version with this feature. Here's an example of how you can rebuild or reorganize indexes with fragmentation and at the same time update the statistics. As you can see the new parameter is @UpdateColumnStatistics.
@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'
Please feel free to contact him if you have any questions.
I wish you a nice day,
|Print article||This entry was posted by tosc on 2010-12-06 at 10:41:00 . Follow any responses to this post through RSS 2.0.|
backup «best practices» books bug ctp «cumulative update» datetime dmv ebook humor index indexoptimize integrity kbfix links loginproperty maintenance «ms sql server 2008» performance php profiler «reporting services» reviews rtm serverproperty «service pack» «service packs» sharepoint sp_msforeachdb «sql 2012» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server builds» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack «stacia misner» t-sql technet «technical note» tempdb tools troubleshooting version whitepapers