How can I fix internal SQL Monitor Error for event QueryWaitStatsSampler?

StephenW

Hi,

I'm receiving this error on different servers every now and again that are being monitored and how do I resolve this? 

Invalid object name '###redgate_sqlmonitor_querywaitstats_*****'

I'm running SQL Monitor version V11.

Kind Regards,

Stephen

squigley

Hello Stephen,

Thanks for your inquiry and sorry to hear about your issue with SQL Monitor.

Can you confirm the exact version of SQL Monitor 11 that you're using from the Configuration>Abouts page?

I ask because the issue you're mentioning looks like one that was fixed in later versions of the tool.

StephenW

Hi Sean, 

Yes the version we are using is V11.0.15.5201. 

squigley

Hello Stephen,

Thanks for confirming.

Can you try upgrading to the latest version below and let me know if that helps?

Download Link: https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_11.1.6.8971.exe

Upgrade Documentation: https://documentation.red-gate.com/sm/maintaining-and-upgrading-sql-monitor/upgrading-sql-monitor