Red Gate forums :: View topic - Disk Avg.read time statistics not collected for a drive
Return to www.red-gate.com RSS Feed Available

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

Disk Avg.read time statistics not collected for a drive

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kannappaganesh



Joined: 03 Feb 2014
Posts: 2

PostPosted: Mon Feb 03, 2014 11:50 pm    Post subject: Disk Avg.read time statistics not collected for a drive Reply with quote

SQL monitor not collecting disk avg.read time and avg.disk queue length statistics for one drive (F: ) in a monitored server. Other logical disk counters are collected for the drive. For other drives in the machine, all statistics are collected.
Any idea what is causing this and suggestions for fix.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Wed Feb 05, 2014 1:55 pm    Post subject: Reply with quote

Are you monitoring a cluster where f: is a shared resource and you are not looking at the currently active node?
Back to top
View user's profile Send private message
kannappaganesh



Joined: 03 Feb 2014
Posts: 2

PostPosted: Thu Feb 06, 2014 5:33 pm    Post subject: Reply with quote

Brian,
Yes, we are monitoring a cluster with F: shared, but looking at the currently active node. The statistics for other counters like disk avg.write time etc.. are collected by SQL Monitor for F: drive. So, the drive is accessible.. Only the two avg read time and disk queue length are not collected.
Back to top
View user's profile Send private message
avibooks



Joined: 17 Feb 2014
Posts: 13
Location: New Zealand

PostPosted: Mon Jun 09, 2014 1:10 am    Post subject: Reply with quote

Has there been any resolution for this issue? I am experiencing a similar issue on our SQL cluster
Back to top
View user's profile Send private message
avibooks



Joined: 17 Feb 2014
Posts: 13
Location: New Zealand

PostPosted: Tue Jun 10, 2014 12:38 am    Post subject: Reply with quote

I am able to get the performance counters for Disk avg. read/write time using Performance monitor on the server where the base monitor is located, but SQL Monitor is not displaying the disk counters.
Back to top
View user's profile Send private message
thefragile



Joined: 23 Jun 2014
Posts: 4

PostPosted: Mon Jun 23, 2014 4:39 pm    Post subject: Reply with quote

Anyone ever figure this out? Having the same issue. Data is getting collected for a clustered drive for everything except Read Time. Seems to be looking at the passive node and causing access denied errors there. How can I tell SQLMonitor the drive is currently on the other node for that sensor?
Back to top
View user's profile Send private message
avibooks



Joined: 17 Feb 2014
Posts: 13
Location: New Zealand

PostPosted: Mon Jun 23, 2014 11:59 pm    Post subject: Reply with quote

Apparently this is a known bug (SRP-9314) in SQL Monitor. The response I got from Red Gate in ticket "Unable to get Disk avg. read/write time for certain drives" was that they are aware of the bug but cannot say when it will be looked at.
Back to top
View user's profile Send private message
thefragile



Joined: 23 Jun 2014
Posts: 4

PostPosted: Tue Jun 24, 2014 2:02 pm    Post subject: Reply with quote

Thank you for that information Avibooks.

That is most unfortunate as it's happening on a crucial drive.

Did you attempt to remove and re-add the cluster to SQLMonitor? I haven't tried that yet, but thought it might be worth a shot...
Back to top
View user's profile Send private message
avibooks



Joined: 17 Feb 2014
Posts: 13
Location: New Zealand

PostPosted: Tue Jun 24, 2014 11:35 pm    Post subject: Reply with quote

No, I have not tried that yet. Could you let me know if that works out for you. Thanks.
Back to top
View user's profile Send private message
thefragile



Joined: 23 Jun 2014
Posts: 4

PostPosted: Fri Jul 04, 2014 1:27 am    Post subject: No dice Reply with quote

Removing the server, letting the data purge, and then re-adding the cluster did not work for me. This is frustrating. I'm going to open a ticket with Redgate with this issue (so they have another instance to add to their issue tracking), and then consider starting from scratch..
Back to top
View user's profile Send private message
avibooks



Joined: 17 Feb 2014
Posts: 13
Location: New Zealand

PostPosted: Fri Jul 04, 2014 3:50 am    Post subject: Reply with quote

Funnily enough the disk read/write time stats on the drives in my cluster started getting populated again. Not all at once though. They came trickling in; one day the Disk Avg. Read time for one drive started getting populated, few days later the Disk Avg. Write time for another drive and so on so forth until all drive statistics were back.

No guarantee it's going to stay the same the next time we perform a cluster failover though!
Back to top
View user's profile Send private message
thefragile



Joined: 23 Jun 2014
Posts: 4

PostPosted: Sat Jul 12, 2014 5:22 pm    Post subject: Reply with quote

Interesting! We're going to start fresh sadly, sometime very soon.

One thing I noted when removing the cluster and re-adding it was that before, it had cluster name, then under that, the nodes listed separately. And we could click node1, see stats, then node2, different stats for CPU, memory, etc, and so on with all nodes. After re-adding it, it was simply the cluster name with no nodes listed under it. So it appears they changed the way it handles clusters in some version or another. And my guess would be that the issue we're running in to is tied to that change somehow. Only a guess of course Smile

Glad to hear yours is sorting itself out without having to lose any other data! Smile I'll post back again to confirm that starting fresh 'fixes' it for us. How could it not though? New instance, new DB... if it doesn't, I'll really start getting concerned...
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