SQL Monitor - Long Running Query - Query Text not Captured

RameshShankarG

Hi,

We have a licensed version of RedGate SQL Monitor, have configured long running query alert. We have been receiving many notifications from SQL Monitor, but none of the alerts are showing the Query Text in the email. It just shows SELECT, EXECUTE etc., I have given below the examples.

SQL process fragment
Command Type: EXECUTE

SQL process fragment
Command Type: INSERT

SQL process fragment
Command Type: SELECT

Why the alerts not showing the full query that was identified? Please clarify ASAP.

Thanks,

mschier

We have actual the same issue:
viewtopic.php?f=197&t=79535

RameshShankarG

Thanks, mschier. But it seems that, RedGate did not fix the issue, still we are using SQL Monitor 5.2.7.4854, getting bunch of alerts everyday with sql frament just as "select", "insert", "update" etc., This is really not helpful to identify and fix long running queries.

Redgate team, please reply on this issue.