2

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) ?

1
  • 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, 2012 at 11:41

2 Answers 2

4

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.

0
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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