SQLUndercover / UndercoverToolbox

A collection of cool and useful tools, procedures and scripts for the discerning DBA
https://sqlundercover.com
MIT License
84 stars 40 forks source link

Inspector - Enable DriveSpace module to run more frequently than once a day #272

Closed Adedba closed 3 years ago

Adedba commented 3 years ago

Starting with the drive space module I will be removing the once a day collection restriction so that the drive space can be monitored at a chosen intervals rather than being forced to once a day.

Adedba commented 3 years ago

As we will be potentially increasing the volume of data in the DriveSpace table will need to optimise the code to accommodate large data so will be swapping the CTEs for temp tables and comparing the results after bloating out the DriveSpace table locally.