SQL Server SPIDs

[Guest]

Hello, I don't know much about SQL Server processes/SPIDs but everytime our
web app creates a ADO.NET connection and closes it, the SPID is still hanging
around in "sleeping status" well after it's closed in the ADO.NET code.

Is this normal or I am making database calls inefficiently?

I also thought mutiple connection w/ the exact same connection string
becomes pooled. If pooled, will that not affect the number of SQL SPIDs
created.

Should I be concerned about the number of SPIDs the app is producing or is
this normal?

Thanks in advance,
Jim

 

[William \(Bill\) Vaughn]

Right. You're seeing the "connection" maintained in the connection pool.
It's perfectly normal.
It's not normal if this number does not level off. If it continues to grow
you're leaking connections--that's bad.




--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________