resolving blocking issues as a dba | SQL Server Performance Forums

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/

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |