Monday, May 3, 2010

Monitor SQL Server Disk Space Usage

Here is the script for finding available free space in the server through Transact-SQL without entering into the Server.

USE Master
Exec XP_Fixeddrives

The Output would be like below screenshot:

 Using xp_fixeddrives to Monitor Free Space, Looking for the inverse of xp_fixeddrives, Monitor SQL Server Disk Space Usage, xp_fixeddrives and impersonation, Disk size and free space monitoring on remote servers, xp_fixeddrives code, xp_fixeddrives msdn, xp_fixeddrives permissions, xp_fixeddrives sql server 2008, xp_fixeddrives sql server, xp_fixeddrives parameters, xp_fixeddrives alternative, xp_fixeddrives total space


Post a Comment