HI,
Can any one provide me query to find the Disk space using MSSQL Instances.
I tried to get it by uing the below sp.
xp_fixeddrives.
Which is Displaying OUT PUT only "Free Space"
MY nedd is To Dispaly
a). Total size of disk
b).Free Space of disk
c)% of free space.
So that i can verfy the threshold easly.....
Please give me an idea or provide me the script for the above requirement.
THanks alot...