Activity overview
Latest activity by avibooks
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! / comments
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 dr...
No, I have not tried that yet. Could you let me know if that works out for you. Thanks. / comments
No, I have not tried that yet. Could you let me know if that works out for you. Thanks.
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. / comments
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 ...
Hi Chris,
Thanks for that. Is there currently any workaround for this bug?
Regards,
Avinash / comments
Hi Chris,
Thanks for that. Is there currently any workaround for this bug?
Regards,
Avinash
Hi Chris,
Thanks for your response. I have just emailed support@red-gate.com with the attached log files.
Regards,
Avinash / comments
Hi Chris,
Thanks for your response. I have just emailed support@red-gate.com with the attached log files.
Regards,
Avinash
Unable to get Disk avg. read/write time for certain drives
Hi there,
We are using SQL Monitor on our production SQL cluster and after installing windows updates and restarting the SQL cluster, we are unable to get certain disk statistics for some of our dr...
Has there been any resolution for this issue? I am experiencing a similar issue on our SQL cluster / comments
Has there been any resolution for this issue? I am experiencing a similar issue on our SQL cluster
Hi Chris,
Thanks for your response. I received your email a few hours ago and have carried out the changes that you suggested.
However, performing those changes entirely disables the data collection for those types of metrics. After performing the change there is no data displayed under Top 10 Waits" or "Top 10 Queries" which is not really what we want.
Even though the data collection is disabled, this does not prevent that query (in the initial post) from executing. It just means that the query runs in practically no time with extremely low resource consumption due to there being no data present for the period run for.
Thanks and Regards,
Avinash / comments
Hi Chris,
Thanks for your response. I received your email a few hours ago and have carried out the changes that you suggested.
However, performing those changes entirely disables the data collectio...
I have not heard back yet regarding this issue. Is there a resolution to the problem?
Thanks,
Avinash / comments
I have not heard back yet regarding this issue. Is there a resolution to the problem?
Thanks,
Avinash
Hi Chris,
I have reduced the data purge window for the "Performance diagnostics data" and "SQL process data" to 3 days.
However, this does not seem to have solved the issue stated initially.
Regards,
Avinash / comments
Hi Chris,
I have reduced the data purge window for the "Performance diagnostics data" and "SQL process data" to 3 days.
However, this does not seem to have solved the issue stated initially.
Regard...