New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available

Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.

Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2011 and 2010 SQL Server Magazine Awards. I love this tool to perform index maintenance on instances with VLDBs - and the best it's free!

The new version supports:

  • lock timeout settings in DatabaseIntegrityCheck and IndexOptimize
  • support for indexes and statistics on objects that are created by internal SQL Server components
  • ... and so on :-)

It can be uses like this:

EXECUTE dbo.IndexOptimize @Databases = 'AdventureWorks', @LockTimeout = 600

The new version has some performance optimizations and minor bug fixes

Download: http://ola.hallengren.com/scripts/MaintenanceSolution.sql

Please feel free to contact him if you have any questions. And I tell you, Ola will consider it!!!

I wish you a nice  day,
tosc