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

TderejeTdereje Posts: 1 New member
edited March 15, 2018 6:13PM in Redgate Monitor
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)
Tagged:
· Share on Twitter

Answers

  • mmendesmmendes Posts: 1 New member
    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.
    · Share on Twitter
  • Alex BAlex B Posts: 1,157 Diamond 4
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.