olahallengren / sql-server-maintenance-solution

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

IndexReorganisationWaitForSpaceInLogfile #496

Open JensChrJuulJensen opened 3 years ago

JensChrJuulJensen commented 3 years ago

It would avoid unnecessary monitoring, if a parameter WaitForSpaceInLogfile could be specified, that makes the next reorganisation command wait until the logfile has sufficient space to handle the reorganisation without expanding (or completely filling) the logfile.

Especially setup that include transactional replication is only releasing logfile space after some time, and thus is sensitive to rebuilds that writes huge amounts of data to the logile