SQL Server 2005: Improving performance for thousands or Insert requests. logout-login time= 120ms.
- by Rad
Can somebody shed some lights on how SQL Server 2005 deals with may request issued by a client using ADO.NET 2.0. Below is the shortend output of SQL Trace. I can see that connection pooling is working (I believe there is only one connection being pooled).
What is not clear to me is why we have so many sp_reset_connection calls i.e a series of:…