David Bird (7/31/2009)
Your question got my mind of thinking. I have tested the script on a Lab server to verify it would not blow up. Currently, we do not have any multiple instance servers.So you are running 12 instances on one Windows Cluster. Is the problem the same drive is being reported twelve times?
Or you want to see only drives listed with its assigned instance?
It will take me some time to think about it. I do not know of any other scripts to collect space on drives. What release of SQL are you using? Maybe 2008 has a DMV.
Yes but we run as a active active cluster so 6 instance are each node. As the Diskspace script runs, it runs against each instance so all the drives on the node get listed 6 times. So SQLInstance1 list drives d-i and sqlinstance2 d-i and so on.... It would be "nice" if they were listed only once. But it would be better if SQLInstance1 reported on the drives it was assigned, such a D and SQLInstance2 reported drive E and so on.
The other issue was the mount points, which are like drives but are mounted in the folder of a drive instead of haveing a drive letter assigned its a folder. like E:\LOGS. Those do not get reported at all.
We are still using 2005. We have a coulple of 2000 servers but they are about gone.
Hope we can come up with something..
Thanks