Instance overview not reporting drive information correctly

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha

Instance overview not reporting drive information correctly

Postby mfal » Fri Jan 20, 2012 6:10 pm

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?
mfal
 
Posts: 14
Joined: Fri Sep 16, 2011 8:07 pm

Postby Brian Donahue » Mon Jan 23, 2012 3:23 pm

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby mfal » Mon Jan 23, 2012 9:33 pm

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.
mfal
 
Posts: 14
Joined: Fri Sep 16, 2011 8:07 pm

Postby Brian Donahue » Tue Jan 24, 2012 5:07 pm

Not all nodes have the other drives configured in Disk Management?
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Tue Jan 24, 2012 5:19 pm

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby mfal » Tue Jan 24, 2012 6:57 pm

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.
mfal
 
Posts: 14
Joined: Fri Sep 16, 2011 8:07 pm

Postby Brian Donahue » Mon Jan 30, 2012 10:25 am

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests