SQL Server Performance Forum – Threads Archive

resolving blocking issues as a dba

can any one pls share
how to find and resolving blocking using ssms? can any one provide me clear idea pls?

---

Use Profiler to find out queries causing blocks.
Check execution plan for those queries and try to optimize.

---

Dear, I was asked to check with sys.sysprocess dmv -> blocked by column;…Am I doing right way??
actually not having much idea abt this .very new to this post.Is there any gud step by step article to achieve blocking in a easy way..?
Any help is apritiated

---

There are plenty of resources available on how to resolve:
http://www.sql-server-performance.com/tips/blocking_p1.aspx
http://support.microsoft.com/kb/323630
http://support.microsoft.com/kb/224453
http://www.simple-talk.com/sql/sql-tools/how-to-identify-blocking-problems-with-sql-profiler/

---

]]>