Assume that you use an application to connect to an instance of Microsoft SQL Server 2014 and 2016. If there is an intensive use of the sp_prepare stored procedure (SP) that is not immediately followed by sp_unprepare, many SQL handle cached entries are generated. Additionally, a non-yielding scheduler error may appear in the error log.
This issue is fixed in the following cumulative updates for SQL Server:
- Cumulative Update 5 for SQL Server 2016 SP2
- Cumulative Update 13 for SQL Server 2016 SP1
- Cumulative Update 2 for SQL Server 2014 SP3
- Cumulative Update 15 for SQL Server 2014 SP2
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server: