Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How to see blocking processes in sql server and How to handle this position???

2 Posts 2 Posters 0 Views 1 Watching

A Offline
A Offline
Aman786Singh

wrote on last edited by

#1

Thanks in advance
W 1 Reply Last reply

0
A Aman786Singh

Thanks in advance
W Offline
W Offline
Wendelius

wrote on last edited by

#2

sp_lock2 is a good tool for resolving lock blocks. If you find a locking issue, you can use KILL statement to kill the session

The need to optimize rises from a bad design.My articles[^]
1 Reply Last reply

0

Log in to reply