• Create a trace, put the output of the trace in a file and run the trace. This is uses lesser resources than running the trace on profiler. Also set the DBCC Traceon statement to record any deadlock information on the SQL logs.

    "Keep Trying"