Sep 12, 2016
SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects
SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects
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 “OLE automation and WMI Query” approach to capture disk space and the use of sqlcmd with looping construct, data storage for querying and reporting…
View On WordPress