Symptoms
Microsoft SQL Server 2014 and 2016 may stop responding to client requests. This issue occurs when there are a significant number of SECURITY_CRYPTO_CONTEXT_MUTEX waits occurring.
When you view the waits, their statistics may resemble the following.
|
wait_type |
waiting_tasks_count |
wait_time_ms |
max_wait_time_ms |
signal_wait_time_ms |
|---|---|---|---|---|
|
SECURITY_CRYPTO_CONTEXT_MUTEX |
5689 |
84054706 |
191537 |
Resolution
The fix for this issue is included in the following 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:
Hotfix for SQL Server 2014 SP2
A supported update is available. We recommend that all customers apply this update.
Download the update SQLServer2014SP2-KB3173472-x64.exe now
Download the update SQLServer2014SP2-KB3173472-x86.exe now
Note After you install this update, the build will be updated to 12.0.5578.0.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology Microsoft uses to describe software updates.
