- You have some applications connect to Microsoft SQL Server 2012 or SQL Server 2014 that use connection pooling.
- There are many distinct or different logins that are used by applications to connect to SQL Server.
- The application has a very frequent connect-query-disconnect pattern. In Perfmon, the MSSQL$<instancename>:General Statistics -> Connection Reset/sec value is in thousands. SQL Server runs a stored procedure that's named sp_reset_connection to clean up and reset the connection state for the pooled connection so it can be used by the new login.
Note: If you're monitoring wait statistics, you may also notice an increase in the CMEMTHREAD wait type during the affected timeframe.
Note This issue doesn't occur if the login(s) belongs to the sysadmin role. To protect the instance of SQL Server and the data that's stored on it, we suggest you to have logins with minimal required privileges.