Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is it possible to see the RAID group name that my database (and log) files are sitting on, in one of the DMVs (or some other system table) ?

share|improve this question
1  
You can see the drive letter, as I am sure you know, but there is no way from within SQL to see the underlying RAID group information. You would have to go look at the tools on your OS/storage solution to see that level of information. –  Mike Walsh Nov 27 '12 at 11:41
add comment

2 Answers

up vote 4 down vote accepted

SQL Server doesn't have any access to anything that low level. Typically Windows can't even see the RAID group information given that each hardware vendor stores that differently and typically exposing that information to the OS doesn't have any benefit. You'll need to work with your hardware team to make the drive labels match, but even then that isn't exposed within SQL Server. You would need to use PowerShell or WMI to pull that information from the OS.

share|improve this answer
    
Thanks Denny, I had a feeling that might be the case.. –  Nick Haslam Dec 4 '12 at 14:06
add comment

One way to work around the visibility issue is to mount RAID volumes under a folder, with each mounted foler having a name that matches the RAID volume name. You (or your ops team) will have to assure these mappings are correct, but once you've established this practice any time you see the name in the path to a file in SQL Server or the OS, you're going to see the name of the RAID volume right in the path.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.