Jon Gurgul's Blog

Tag: Trace

  • Capturing Deadlocks

    —

    by

    Jon Gurgul
    in

    So, deadlocks. “A deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock.” http://msdn.microsoft.com/en-us/library/ms178104.aspx How to capture deadlocks? How many ways can you capture a deadlock? Lots! Luckily I do not see a lot of deadlocks in…

  • SQL Server Profiler Trace

    —

    by

    Jon Gurgul
    in

    A Trace can easily be used to monitor what is happening within SQL Server, just start SQL Server Profiler via the Tools Menu in SSMS or via a shortcut. Once started it is a relatively easy process: 1. Connect to the SQL Server you wish to run the trace on. 2. Either use the default…