Menu & Search
Get Disk Space in SQL Server

Get Disk Space in SQL Server


You can quickly check disk space info on a SQL Server host by running the query below. I sometimes find this the quickest way to check available space rather than using PowerShell or the Windows GUI. This SQL Script only work on SQL Server 2008 R2 and above.

Results should return within a blink and looks something like this.

The PowerShell cmdlet shown below will also get you the information you need. Run Enter-PSSession first to run on a target server (requires Local Admin permissions).