• Hey David., I know this is an old thread but I really liked your approach and have developed on top of yours. I had a question about drive spae and low drive space and how you would handle my issues.

    We have a SQL cluster with 12 instances of SQL. Each assigned their own Logical drive and one mount point. So for instance sql1 it would be assigned drive H and the mount point would be H:\LOGS. Instance SQL2 would have drive J: and Mount point J:\LOGS

    Your drive space scripts, has every drive on the cluster node under each instance server name. So for instnce...if there are 5 sql instances on each node, each instance would have 5 drives under each one. None of the mount points are listed.

    Are there any views or tables that shows what drive letters each SQL instance can see or uses? Is there any new methods that replaces the (sp_OAMethod @fso,'GetDrive', @odrive OUT) si that we can get drive space from mount points?

    Hope your stilll around and monitor this.. Thanks