SQL Monitor - Long Running Query - Query Text not Captured

RameshShankarGRameshShankarG Posts: 18
edited October 3, 2016 5:33AM in SQL Monitor 6
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,

Comments

Sign In or Register to comment.