Activity overview
Latest activity by robert.rainville
HI currently evaluating SQL Monitor 5.2.1
And I have kind of the same problem with the long running queries alert
Incomplete
SQL fragment
Command Type: EXECUTE etc...
But also a lot of false alert even though the metric is set to alert on queries taking more than 3 minutes (180 secs) and excluded BACKUP & RESTORE
I am getting a lot of alerts with query duration of only a couple seconds, which makes it a real pain to find the real alerts (getting over 200 alerts overnight out of which maybe only 4 or 5 really took more than 180 secs)
here's a couple exemples:
Process ID: 78
Process name: SQLCMD
Database: master
Host: *******
User: *********
Process login time: 1 Jun 2016 7:25 AM
Query start time: 1 Jun 2016 7:25 AM
Query duration: 0 sec
SQL process fragment
Command Type: EXECUTE
Process ID: 102
Process name:
Database: VCDB
Host:**********
User: ****************
Process login time: 1 Jun 2016 3:02 AM
Query start time: 1 Jun 2016 6:32 AM
Query duration: 0 sec
SQL process fragment
Command Type: UPDATE
Thanks
Robert / comments
HI currently evaluating SQL Monitor 5.2.1
And I have kind of the same problem with the long running queries alert
Incomplete
SQL fragment
Command Type: EXECUTE etc...
But also a lot of false alert ...