Activity overview
Latest activity by Al
Hi Alex, Is there a tsql query I can execute that will return the top queries for the top wait stats? We want to know what are the top statements for our top SQL server wait stats without needing to enable the [Cluster].[SqlServer].[TopQueries].[QueryWaitStats] in the ConfigurationFileEditor.exe tool. Thank You! Al / comments
Hi Alex,Is there a tsql query I can execute that will return the top queries for the top wait stats?We want to know what are the top statements for our top SQL server wait stats without needing to ...
Hi Alex, We have not had a Stack Dump due to ##redgate_sqlmonitor since disabling Query Wait Statistics. Thank You for your knowledge and wisdom! Al / comments
Hi Alex,We have not had a Stack Dump due to ##redgate_sqlmonitor since disabling Query Wait Statistics.Thank You for your knowledge and wisdom!Al
Hi Alex, The Query Wait Statistics has been disabled in Redgate Monitor for our critical SQL Server with a default instance. Thank You! Question, How do I verify the Query Wait Statistics are actually disabled; is there a TSQL query that I can run to verify? Reason that I am asking is I still see two “Redgate Monitor - Monitoring” sessions connected to the TempDB database in suspended status on our default instance. Thanks, again, Al / comments
Hi Alex,The Query Wait Statistics has been disabled in Redgate Monitor for our critical SQL Server with a default instance. Thank You!Question,How do I verify the Query Wait Statistics are actually...
How to disable the Query Wait Statistics in Redgate Monitor?
Answered
How do I disable the Query Wait Statistics for our monitored SQL Server instance in our Redgate Monitor repository database?Redgate Monitor has caused two SQL Stack Dumps on our business critical S...