var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Calculation of % of Disk Space
I need to calculate percentage of free disk space available of the drive where SQL server is installed.
I know the following command EXEC master..xp_fixeddrives gives free MB for different drives but i can't calculate the percentage and even i don't know in which drive SQL server is installed.
I can't ask my customer to enable XP_CMDSHELL due to security reasons
Please suggest me some solution.
Last edited by kirandarisi; 05-19-09 at 15:18.
open windows explorer. click on the drive and hit properties?
or did you mean programatically?
did you want set up an alert?
Thanks for ur reply.
I need to do it with SQL server no alert is needed
Since the total diskspace is not likely to change over time, you can create a table somewhere, and insert the drives and sizes once. Use that to compare to the variable output of xp_fixeddrives.