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
GO
Exec XP_Fixeddrives
GO 

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

0 comments:

Post a Comment