search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.87k stars 735 forks source link

Possible use of database extended properties to select DB's to Integrety check #65

Closed RichardTLines closed 6 years ago

RichardTLines commented 6 years ago

We currently use your scripts for integrity checks to split VLDB and smaller DB’s into their own jobs. We are now getting issues with timings and would like to split the non VLDB into two jobs. I was wondering if it is possible to use extended properties to decide which DB’s to select rather than excluding and including, as the extended properties can be created when a new DB is created and we would not have to change the jobs

RichardTLines commented 6 years ago

Hi Ola Thanks you for your new version which now allows the integrity checks to run in parallel. I have tested it and it works well, saving quite a lot of time, allowing time for other checks to be made. With a 24/7 system, keeping non customer facing work down to a minimum is a big bonus. Regards Richard