Using my central MDW database I am trying to make a query that will be able to calculate the number of days until all my databases free space will be full. Currently the query I have is overly complicated and takes long to run.
I am wondering if there is a simple solution using the following columns to calculate this. Columns I have are:
- row_number
- snapshot_time
- instance_name
- database_name
- dbsize
- current_usage
All tables are found in the MDW database. Any suggestions are greatly appreciated!