March 15, 2010 at 10:59 am
I see a lot of SPID's with sleeping status and the application is .NET SQLClient Data Provider
To prevent these issues i want to set the proper waiting time to SPID's.....How do i do it???
What's the ideal wait time???
Regards,
Sandeep
March 15, 2010 at 11:20 am
I think you are looking for a solution for a problem that doesn't exist.
March 15, 2010 at 11:25 am
When a process is sleeping it simply means this:
Sleeping - Currently running no requests
March 15, 2010 at 2:07 pm
It just means that the connection is open but is running no queries at this point in time. It's not a problem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2010 at 2:12 pm
Thanks Gail and Lynn
March 15, 2010 at 2:48 pm
Well, it would be a problem if you had a large number of these - are you talking tens, hundreds or thousands?
March 15, 2010 at 3:12 pm
If there are thousands, then likely some app isn't closing its connections properly. That needs fixing, but in the application. It's not something that's solved from the SQL side.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply