Pau Lo
asked on
SQL Servers knowledge of local storage
Does SQL Server have any knowledge of the drive capacity / free space of the drives your SQL databases reside on? I.e. would it be possible to write a query for all SQL databases housed on drives with xyz free space, or xyz GB of free space? if for example you wanted to query all your SQL servers for those with DB on drives with less than 5% capacity free remaining space or 2 Gb free space?
EXEC MASTER..xp_fixeddrives
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.