SQL Server SPIDs

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
__________________________________
 
Back
Top