Solved

Blocking and deadlock on SQL Server

Posted on 2014-02-12
1
286 Views
Last Modified: 2014-02-16
I want to find out any blocking or deadlock on the SQL Server.

Using sp_who2, there is nothing under field "BlkBy'.

If I use "select * from sysprocesses where blocked >0' I see a record setup. Does it mean this task is blocked some resource on the server ? In addition, what is meaning for 'AWAITING COMMAND' under column 'cmd'


Tks
0
Comment
Question by:AXISHK
1 Comment
 
LVL 10

Accepted Solution

by:
HuaMinChen earned 500 total points
ID: 39852774
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now