Solved

Blocking and deadlock on SQL Server

Posted on 2014-02-12
1
284 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

760 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

21 Experts available now in Live!

Get 1:1 Help Now