SQL Server Disk Space Analysis

Jana Sattainathan has a solution using Powershell, Power BI, and T-SQL to track disk usage across a series of SQL Server instances:

This is just great on its own as I get information shown below. It is basically data like this at the Database/FileGroup/File levels

• Database/Filegroup/File name

• Size

• Free size

• Max size

• Free of Max size

• Size as a percent at the instance level

• Free size as a percent at the instance level

• Max size as a percent at the instance level

• Free of Max size as a percent at the instance level

Read on to see how Jana makes use of this data, as well as where you can get the code.