September 16, 2004 at 5:12 am
I'm looking to prepare an analysis based on disk growth to indicate when i would be running out of physical disk space on each of my sql server instances. I have not discovered a way yet to obtain the size of the physical disks.
I can obtain how much disk space is free on each drive by xp_fixeddrives but not yet the max space of the drive.
Has anyone been able to find a way to get this info thru sql?
September 16, 2004 at 12:30 pm
Have you tried running sp_diskspace?
-Chris
September 17, 2004 at 2:20 am
exec master..xp_fixeddrives
-- Alex
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy