The stored procedure built into the SQL Server executable that is called when a connection is returned to the connection pool by a Data Access API.
Questions tagged [sp-reset-connection]
5 questions
186
votes
3 answers
What does "exec sp_reset_connection" mean in Sql Server Profiler?
Trying to understand what Sql Profiler means by emitting "sp_reset_connection".
I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed,
RPC:Completed exec sp_reset_connection
SQL:BatchStarting SELECT…
Ray
- 12,101
- 27
- 95
- 137
13
votes
4 answers
Can I stop sp_reset_connection being called to improve performance?
My profiler trace shows that exec sp_reset_connection is being called between every sql batch or procedure call. There are reasons for it, but can I prevent it from being called, if I'm confident that it's unnecessary, to improve…
Rory
- 40,559
- 52
- 175
- 261
8
votes
4 answers
Why so many sp_resetconnections for C# connection pooling?
We have a web service coded in C# that makes many calls to MS SQL Server 2005 database. The code uses Using blocks combined with C#'s connection pooling.
During a SQL trace, we saw many, many calls to "sp_resetconnection". Most of these are short…
Aaron Silverman
- 22,070
- 21
- 83
- 103
1
vote
2 answers
Is there a java.sql.Connection class's equivalent function for SQL Server sp_resetconnection functionality?
Imagine a simple connection pool for java.sql.Connection. After the connection has been released back to the pool we have no idea if any transactions are open, any temporary tables created, etc.
Rather than manually checking if getAutoCommit() is…
Aaron Silverman
- 22,070
- 21
- 83
- 103
0
votes
0 answers
sys.sp_reset_connection runs for up to 5 minutes
sys.sp_reset_connection runs for up to 5 minutes on SQL Server 2019 CU13 [SQL1] .
At the same time other SQL Servers [SQL100..SQL200] that have linked server to [SQL1] are timing out:
TCP Provider: An existing connection was forcibly closed by the…
oleg
- 1