We are doing some SAN performance testing on the latest EMC VMAX array. As part of this, we are testing different storage configurations and policies and doing some baselining. I recently requested a set on LUNs for a new SQL install from my storage admin–I didn’t think about it, but I asked for disks that were the same exact size (200 GB) for both my data files and transaction logs. These disks were under different policies–so I had to identify them, which would prove difficult.
Windows storage manager shows me this picture of the disks assigned (note this pic is post fact–the disks have been configured):
EMC PowerPath shows us the following view:
As you can see we have two sets of disk numbers, and the numbers in PowerPath <> the numbers in Windows. One would think if someone looked under properties of the disk in Windows, you could find the underlying information. Unfortunately, they aren’t there. Enter the INQ utility, from EMC. It’s available via public FTP here.
You will run this utility from DOS, and use the following flag inq -showvol -sym_wwn. It will show the physical drive (which is the Windows number) and the EMC Device #–which is available in PowerPath. It’s still an ugly manual process, but it gets us the data.