Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snomad
Starting Member
22 Posts |
 Posted - 2009-09-16 : 09:53:22
|
Hello,I'm trying to write a proc that alerts me when disk space falls below x % across all the servers. For reasons beyond my control, xp_cmdshell is disabled and must remain so. I can obtain disk space free from xp_fixeddrives. How can I obtain total disk size (in order to determine percentage)?Thank you!! Thank you!! |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-16 : 10:05:18
|
| What version of SQL Server are you using?SQL Server 2008 has Performance Management Data Collector. Or you could use a PowerShell script. |
 |
|
|
snomad
Starting Member
22 Posts |
Posted - 2009-09-16 : 10:25:44
|
| Hey there. I'm on 2005. I can't install powershell on the the servers either. Can only access via SSMS / osql from central server. Maybe, given the contraints (which are very annoying) it's not possible?! Or I'll have to pop back to the stone age and hard code the orig disk sizes? Thank you!! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-16 : 10:50:03
|
| Can you use the sp_OA procedures (sp_OACreate, etc.)? If so you can modify this script to do it:http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct04/hey1013.mspx |
|
|
|
snomad
Starting Member
22 Posts |
Posted - 2009-09-16 : 11:41:09
|
| Mmm, not sure, let me read up about them and have a go. Thanks.Thank you!! |
|
|
|
|
|
|
obtain disk size info from within sql