I'm profiling/tracing our production system trying to determine why occassional deadlocks are happening. I'm also just trying to examine the longest running queries sent by applications to see if I can tune them. There are several statements like below that had a higher duration relative to all traced statements.
exec sp_cursorfetch 180255319, 2, 1, 1
exec sp_cursorfetch 180257335, 2, 1, 1
How can I determine what is going on here? thanks.