Facing Problem

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,

ShaileshYou've really told us nothing here. Have you determined if there is a
blocked process? what happens if you run sp_who?

--
Tom

----------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

"VU2LOC" <vu2loc@.gmail.com> wrote in message
news:1137493777.837548.11200@.g47g2000cwa.googlegro ups.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|||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.googlegro ups.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