March 17, 2023 By Beekeeper Studio Staff

Monitoring free disk space on SQL Server servers becomes crucial if your database growth is relatively fast. If you don’t have direct access to your server’s hard disks, xp_fixeddrives provides an easy way to monitor free disk space remotely.

Beekeeper Studio Is A Free & Open Source SQL Server GUI

I’ve upgraded from SQL Server and it was a smooth change — Beekeeper Studio enhanced my own workstream, offering a cleaner experience and better performance, as well as flexibility. - Aman Bhattarai

Beekeeper Studio is a fast, intuitive and easy to use SQL Server client. It supports loads of other databases too, and works great on Windows, Mac and Linux.

Beekeeper's Linux version is 100% full-featured, no cut corners, no feature compromises.

The xp_fixeddrives system stored procedure returns a list of physical hard drives and the amount of free space on each one.

Syntax

EXEC master.dbo.xp_fixeddrives

xp_fixeddrives is an undocumented system stored procedure. Microsoft may not include it in future releases of SQL Server 2000 or MSDE.

More SQL Server Articles