Monthly Archives: September 2016

SQL Server: Monitoring Disk Space with FSUTIL command line utility

Posted on September 27, 2016 by Prashanth Jayaram

Table of Contents Introduction Pre-requisites Data flow Enable xp_cmdshell Download SQL Code Output Conclusion References See Also Introduction This article talks about one of SQL method to fetch the disk usage details and use of T-SQL in conjunction with invoking … Continue reading →

Posted in SQL, SQLCMD, Uncategorized | Tagged FSUTIL Examples, FSUTIL FSINFO, xp_cmdshell examples | Leave a comment

SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects

Posted on September 12, 2016 by Prashanth Jayaram

Abstract This article talks about various SQL methods to fetch the disk usage details and use of T-SQL in conjunction with invoking OLE automation procedures and WMI class libraries using SQL Windows Shell interface. The step by step details about … Continue reading →