| Author |
Message |
mfal
Joined: 16 Sep 2011
Posts: 10
|
 Posted: Fri Jan 20, 2012 6:10 pm Post subject: Instance overview not reporting drive information correctly |
 |
|
I have several instances on a cluster and trying to monitor them through Red Gate Monitor. Each instance has a separate drive LUN assigned to them (i.e. inst 1 - M:, inst2 - N:. inst3 - O:, etc.). Under each drive LUN, we have several different mount points for our files.
When looking at the different instance overviews, all of them only show a single LUN, the O:. I can see all the mount points attached to O:, but all the individual instances are showing the same drive and mount points.
Any information on why this occurs? |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Mon Jan 23, 2012 3:23 pm Post subject: |
|
|
We've had a few complaints about the drive information, but from what I can tell, SQL Monitor goes to the SQL Server Computer and queries HKEY_LOCAL_MACHINE\SYSTEM\MountedDevices for all values that begin with \DosDevice. So if your drive letter isn't listed in there (and I'm sorry I don't know enough about Windows Internals to say whether a mount point, etc would show up in this key) then you shouldn't see the drive letter in SQL Monitor.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
mfal
Joined: 16 Sep 2011
Posts: 10
|
| Posted: Mon Jan 23, 2012 9:33 pm Post subject: |
|
|
| The mountpoints do show up, but the problem is that for all instances only one set of cluster drives shows up (the O: drive). I'm looking for why only this drive would show and none of the other cluster drives would appear. |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Tue Jan 24, 2012 5:07 pm Post subject: |
|
|
Not all nodes have the other drives configured in Disk Management?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Tue Jan 24, 2012 5:19 pm Post subject: |
|
|
What have you got highlighted - the name of the cluster or one of the nodes? Highlighting the SQL Instance name as far as I know doesn't make it show a list of the drives.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
mfal
Joined: 16 Sep 2011
Posts: 10
|
| Posted: Tue Jan 24, 2012 6:57 pm Post subject: |
|
|
| I've got the instance highlighted. No matter which instance I highlight, it shows the same drive letter/mount point set and not the one assigned to that instance. |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Mon Jan 30, 2012 10:25 am Post subject: |
|
|
From what I see, SQL Monitor is reporting physical disks rather than logical disks. But it should also report any disks that are configured as a cluster's shared resource.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
