search

olahallengren / sql-server-maintenance-solution

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

DatabaseObjectOrder to specify the order in which database objects are checked #160

Open suggy1982 opened 5 years ago

suggy1982 commented 5 years ago

Similar to the DatabaseOrder parameter would it be possible to have a parameter that specifies the order in which database objects are checked?

For example if you only have a 5 hour maintenance window each night and a VLDB you could run CHECKTABLE in batches starting with the oldest check date first and using the TimeLimit parameter.

This would allow us to configure the integrity checks similar to Paul Randal's suggestion here

olahallengren commented 5 years ago

Couldn't you use the @DatabaseOrder parameter? https://ola.hallengren.com/sql-server-integrity-check.html#DatabaseOrder

olahallengren commented 5 years ago

Similar to the DatabaseOrder parameter would it be possible to have a parameter that specifies the order in which database objects are checked?

For example if you only have a 5 hour maintenance window each night and a VLDB you could run CHECKTABLE in batches starting with the oldest check date first and using the TimeLimit parameter.

This would allow us to configure the integrity checks similar to Paul Randal's suggestion here

I was looking at this again. It is a good idea. Thank you for the suggestion.