Posted by Tony Rogerson on 09/30/08 11:37

Hi Shailesh,

Check out if there are any transactions not being committed that may be
causing blocks..

Check for open tran, DBCC OPENTRAN - look it up in books online to
understand its use.

Run sp_who2 and check for any spids that are blocked, a number in the blk
column.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"VU2LOC" <vu2loc@gmail.com> wrote in message
news:1137493777.837548.11200@g47g2000cwa.googlegroups.com...
> Well I am the MS-SQL user I always face the problem in my application.
> After some time my application stop working goes in to the not
> responding stage. Then I have to KILL some session which are SPID > 51.
>
> After this my problem is getting resolved after this I can able to
> create new sessions. Please help me ot with this issues.
>
> regards,
>
> Shailesh
>

[Back to original message]