CODEWITHSUNDEEP
sql-server-2019sqloledbsp-reset-connection
oleg
oleg

Reputation: 1

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 remote host.
OLE DB provider "SQLNCLI11" for linked server "SQL1" returned message "Client unable to establish connection"

What is causing the connectivity issue? Why is sys.sp_reset_connection running for so long and could it run faster?

Upvotes: 0

Views: 412

Answers (0)

Related Questions