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:

Cumulative Update 1 for SQL Server 2016

Cumulative Update 12 for SQL Server 2014 SP2

 

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:

Latest cumulative update for SQL Server 2016

Latest cumulative update for SQL Server 2014

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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×