SQL Server Performance

resolving blocking issues as a dba

Discussion in 'SQL Server 2008 T-SQL Performance Tuning' started by sqldbarocks, Jan 13, 2011.

  1. sqldbarocks New Member

    can any one pls share
    how to find and resolving blocking using ssms? can any one provide me clear idea pls?
  2. Luis Martin Moderator

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

    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
  4. satya Moderator

Share This Page