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

Why SQL Monitor doesn't display SQL user processes and affected/affecting queries under top waits?

Here are the list of useful information that SQL Monitor is not displaying.
1. Affected Queries from the listed waits under Top 10 waits ...it used to display; not anymore. 
2. SQL User Processes (top 10 by cpu)
3. Blocking Processes (Beta)
Tdereje
0

Comments

2 comments

Sort by
  • mmendes
    I am having the same issue.  I have 4 alerts on the same server for 100% processor utilization.  Two of those alerts show the sql queries running at the time of the alert, the other two do not and the screen says "No SQL statements to display.  ... Trace is not enabled for this instance.." when in fact it is enabled.

    Is there a fix for this?

    Thanks.
    mmendes
    0
  • Alex B
    Hi @mmendes

    I've previously raised this with the development team as SRP-10887 and I think they are planning on addressing it when they come to work on the trace functionality, though I don't have a time frame for when that may be.

    Kind regards,
    Alex
    Alex B
    0

Add comment

Please sign in to leave a comment.