Activity overview
Latest activity by BrianH
Unstablesamples
My Storage_ and Performance_ UnstableSamples tables are ridiculously large and I cannot get them to purge (roughly 110 million rows each, going back to Red Gate Monitor install time).
How can I get...
jonstahura wrote:
I had data for a long time on the buffer page life and other sql values... then it just stopped.. everything is 0...
I check the log and it says everytihng is ok... i am getting machine information..
I am having a similar problem. Monitor has stopped gathering stats on a server that was previously monitored successfully for over a year. The connection status is monitoring/connected, but the log shows very little activity and metrics are no longer being displayed for this server.
I have removed and readded the server to monitoring (without deleting history) to no effect. Please help!
Brian / comments
jonstahura wrote:
I had data for a long time on the buffer page life and other sql values... then it just stopped.. everything is 0...
I check the log and it says everytihng is ok... i am gettin...
Retrieve all deadlock text
I would like to extract from the Redgate database all of the processes associated with deadlock alerts, victim or otherwise. In other words, the GUI displays the SQL statements involved in a deadl...