How can we help you today? How can we help you today?

SQL Monitor - Long Running Query - Query Text not Captured

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,
RameshShankarG
0

Comments

2 comments

Sort by
  • mschier
    We have actual the same issue:
    viewtopic.php?f=197&t=79535
    mschier
    0
  • 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.
    RameshShankarG
    0

Add comment

Please sign in to leave a comment.