Checking for Available Free space on SQL Server via SQL

There is an extended stored procedure available within SQL Server which allows you to get visibility of the windows drives from T-SQL called xp_fixeddrives . Calling xp_fixeddrives on it's own will list each drive letter for the windows host followed by it's available disk space in MB.

Here is an example of how you can check for free space on any drive with a simple piece of SQL, compared to a threshold. Note the "where clause" on the select statement which returns just those drives containing less than 100MB of free space.

create table #dbtuna_drive_check( drive varchar(100), mb_free int );

insert into #dbtuna_drive_check EXEC master.dbo.xp_fixeddrives;

select * from #dbtuna_drive_check where mb_free < 100;

drop table #dbtuna_drive_check;

Next Step - Improve Your Database Performance now with DBTuna:

REQUEST A DEMO

START A FREE TRIAL