• Thanks for this information.

    Main issue is slowness and when ever slowness occurs i see temp block in databases ,so when i kill the culprit blocker the issue resolved.I was able to trace culprit stored procedure but it is tuned.

    How to check memory pressure?