Red Gate forums :: View topic - Instance overview not reporting drive information correctly
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Instance overview not reporting drive information correctly

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mfal



Joined: 16 Sep 2011
Posts: 14

PostPosted: Fri Jan 20, 2012 6:10 pm    Post subject: Instance overview not reporting drive information correctly Reply with quote

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
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Mon Jan 23, 2012 3:23 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
mfal



Joined: 16 Sep 2011
Posts: 14

PostPosted: Mon Jan 23, 2012 9:33 pm    Post subject: Reply with quote

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
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Tue Jan 24, 2012 5:07 pm    Post subject: Reply with quote

Not all nodes have the other drives configured in Disk Management?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Tue Jan 24, 2012 5:19 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
mfal



Joined: 16 Sep 2011
Posts: 14

PostPosted: Tue Jan 24, 2012 6:57 pm    Post subject: Reply with quote

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
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Mon Jan 30, 2012 10:25 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group