• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

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?
0
pma111
Asked:
pma111
  • 2
1 Solution
 
Lee SavidgeCommented:
EXEC MASTER..xp_fixeddrives
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now