Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How do I Zoom In on a Profiler Deadlock graph?

Unanswered How do I Zoom In on a Profiler Deadlock graph?

  • Wednesday, June 13, 2012 3:43 PM
     
     
    Sign In to Vote
    0

    Greetings. Using 2K, sp1.

    I used Profiler yesterday to trap a bunch of deadlock info in the graphs. However, there seems to now be no way to Zoom In to see my graphs in more detail.

    I just learned that (in a new trace) I can save my trace to a table, reopen it, and then Zoom In within Profiler itself, but that does me no good for yesterdays traces.

    Ideas?

    TIA, ChrisRDBA

    • Moved by Tom Phillips Wednesday, June 13, 2012 9:06 PM Tools question (From:SQL Server Database Engine)
    •  
     

All Replies

  • Wednesday, June 13, 2012 3:53 PM
     
     
    Sign In to Vote
    0

    Hi,

    Pls see step-7 onwards:

    http://msdn.microsoft.com/en-us/library/ms190465.aspx

    Check out my blog on SQL Server at http://sqlactions.com This posting is provided "AS IS" with no warranties, and confers no rights.

     
  • Wednesday, June 13, 2012 3:55 PM
     
     
    Sign In to Vote
    0

    Check this Deadlock Analysis – READ Deadlock from SQL ERRORLOG

    you will able to see what causing issue and what is the root cause of the issue.

    DBATAG
    MCITP, MCDBA
    Follow UP : Blog ; TWITTER ; FACEBOOK ; YOUTUBE ; LINKED in ; ASK a QUESTION ; Email ;

     
  • Thursday, June 14, 2012 2:55 PM
     
     
    Sign In to Vote
    0

    I appreciate both of your ideas, but neither of them really answers my question (unless I'm misreading).

    I have existing graphs, but no saved trace. I can open them, but not Zoom In on them. How do I accomplish this?

    Thanks.

    TIA, ChrisRDBA