Activity overview
Latest activity by SDixon
The issue seems to be due to a data mismatch between the current and historic Query Performance Stats held in 2 tables by red Gate in the TempDB database called
dbo.redgate_sqlmonitor_topqueries_a.....
dbo.redgate_sqlmonitor_topqueries_b.....
Executing command "DBCC FREEPROCCACHE" to clear the current SQL Query Plan Cache / Clear the Current Execution Stats and dropping these 2 tables will fix the issue.
Hope that this helps
Thanks [image]
Steve Dixon / comments
The issue seems to be due to a data mismatch between the current and historic Query Performance Stats held in 2 tables by red Gate in the TempDB database called
dbo.redgate_sqlmonitor_topqueries_a....