Blocking (Urgent)

[Binoy]

Hello,

I've a problems with blocking
simple select * from table1
is blocked
how to know which statement is blocking
select * from table1 is spid 30 blocked by spid 26
and in current activity spid 26 has no select or any statement
how could i know the spid 26 statement ?
And can just select statement be blocked?

wht should we do to monitor locks?

Thanks

Binoy

[chak]

Try to execute the
Select * from table1 with (nolock)




------------
Binoy at 7/13/01 2:52:09 PM

Hello,

I've a problems with blocking
simple select * from table1
is blocked
how to know which statement is blocking
select * from table1 is spid 30 blocked by spid 26
and in current activity spid 26 has no select or any statement
how could i know the spid 26 statement ?
And can just select statement be blocked?

wht should we do to monitor locks?

Thanks

Binoy

[Jim]

In EM go into the Management section, then current activity, then process info. The last column shows what process is being blocked and the process id that is blocking it. Locate the blocking process, right click and hit properties. This will show what query is running. More than likely it is an update or insert query hitting the same data your select is needing. A select query uses a shared lock, so it can block also. To make your select query ignore locks and read "dirty data" use something like this:
select * from table1 with (nolock).


------------
Binoy at 7/13/01 2:52:09 PM

Hello,

I've a problems with blocking
simple select * from table1
is blocked
how to know which statement is blocking
select * from table1 is spid 30 blocked by spid 26
and in current activity spid 26 has no select or any statement
how could i know the spid 26 statement ?
And can just select statement be blocked?

wht should we do to monitor locks?

Thanks

Binoy