Tom Collins doesn’t need drive letters:
I have some SQL Servers and the file system is organised with mount points. SQL Server is configured to distribute the system files , data , transaction log and tempdb files on those mountpints. As these are Production systems – the DBA does not have permanent access to the Disak Manager without a request for elevated privileges. But they do have privileges to execute administration type of queries.
Do you have a query that allows the DBA to excute a query to determine the Total Size , Available Size and Space Free on the mountpoints
Read on for the answer, as well as a link to an older article from Tom on the topic.