cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

DPA Database Instance Monitor Errors

Hi,

I'm starting to experience DPA Database Instance Monitor Errors when the monitored SQL Server is under a high load and users are experiencing timeouts.

I'm getting the message:

Monitor for database [WG-SQL] failed in job [QuickPollJob] due to [The query has timed out.]. Will attempt to retry every [60] seconds...

Is this something to worry about ?

Tags (1)
0 Kudos
1 Reply
Level 14

If you go to your logs: <install_dir>\iwc\tomcat\logs and open contime.csv in a spreadsheet, filter it by the instance/database ID you are seeing the error in

  • "select id, name from cond" (against your repo)

AND by quickpoll* jobs.

We will attempt to execute 600 QPs in a 10 minute period. I consider about 80 - 85% of successful executions statistically valid - so anything north of let's call it around 500. If your successful executions at times dips below 500, you may want to open a support case and dig a bit deeper. If it is a highly active instance or unresponsive for any reason, these can time out.

0 Kudos