|
Posted by Tony Rogerson on 10/04/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
>
Navigation:
[Reply to this message]
|