Options

SQL Query Fragments

tleblanctleblanc Posts: 17 Bronze 2
edited January 17, 2014 4:39AM in SQL Monitor Previous Versions
I'm getting a deadlock and the SQL fragment that is displayed is truly that--a fragment. Is there any way to see the whole query?
· Share on Twitter

Comments

  • Options
    Adam WAdam W Posts: 111 Silver 3
    Hi,

    SQL Monitor is able to capture the full query only when you are running trace. Trace can be enabled from the Configuration > Trace page. Please note that trace has a performance impact on your monitored server and should only be used for a short period of time when diagnosing a problem.
    · Share on Twitter
Sign In or Register to comment.