This article describes an issue when you encrypt data on Microsoft SQL Server on Windows 10, version 1607, Windows Server 2016, Window 8.1 or Windows Server 2012 R2. A hotfix is available to resolve this issue. The hotfix has a prerequisite.
Symptoms
Assume that you encrypt data on a SQL Server that is running on Windows 10, version 1607, Windows Server 2016, Window 8.1, Windows RT 8.1, or Windows Server 2012 R2. Multiple open key operations occur in one SQL Server connection. In this situation, you notice that the Private (KB) and Working Set (KB) columns for SQL Server keep increasing in the Resource Monitor.
Cause
This issue occurs because of an issue inside the rsaenh.dll file, version 6.3.9600.16384. SQL Server internally uses Cryptography Next Generation (CNG) functions to manage data encryption. If you use the VMMAP tool, take an analysis of the process or collect Xperf data with heap tracing, you would see that most memory consumption is accounted from the default heap.Â
This issue would only occur if in SQL Server if you use data encryption by using a symmetric key that uses a certificate, and then you execute queries that open and close the symmetric key in a recursive loop on a Windows Server 2016 or Windows Server 2012 R2-based computer.Â
Resolution
To resolve this issue for Windows RT 8.1, Windows 8.1, and Windows Server 2012 R2, install update rollup 2975719, or get the standalone package for this update tbhrough the Microsoft Update Catalog website.
To resolve this issue for Windows 10, version 1607 or Windows Server 2016, install update rollup 4284833.
Update information
Prerequisites
To apply this update for Windows 8.1, Windows RT 8.1, or Windows Server 2012 R2, you must first install the update 2919355. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2919355 Windows RT 8.1, Windows 8.1, and Windows Server 2012 R2 Update: April 2014
Registry information
To use the hotfix in this package, you do not have to make any changes to the registry.
Restart requirement
You have to restart the computer after you apply this update.
Update replacement information
This update does not replace a previously released update.
Â
The global version of this hotfix installs files that have the attributes that are listed in the following tables. The dates and the times for these files are listed in Coordinated Universal Time (UTC). The dates and the times for these files on your local computer are displayed in your local time together with your current daylight saving time (DST) bias. Additionally, the dates and the times may change when you perform certain operations on the files.
Windows RT 8.1, Windows 8.1, and Windows Server 2012 R2 file information notes Important Windows 8.1 hotfixes and Windows Server 2012 R2 hotfixes are included in the same packages. However, only "Windows 8.1" is listed on the Hotfix Request page. To request the hotfix package that applies to one or both operating systems, select the hotfix that is listed under "Windows 8.1" on the page. Always refer to the "Applies To" section in articles to determine the actual operating system that each hotfix applies to.
-
The files that apply to a specific product, milestone (RTM, SPn), and service branch (LDR, GDR) can be identified by examining the file version numbers as shown in the following table:
Version
Product
Milestone
Service branch
6.3.960 0.17 xxx
Windows RT 8.1, Windows 8.1, and Windows Server 2012 R2
RTM
GDR
-
The MANIFEST files (.manifest) and the MUM files (.mum) that are installed for each environment are listed separately in the "Additional file information for Windows RT 8.1, Windows 8.1, and Windows Server 2012 R2" section. MUM, MANIFEST, and the associated security catalog (.cat) files, are very important to maintain the state of the updated components. The security catalog files, for which the attributes are not listed, are signed with a Microsoft digital signature.
For Windows 10, Version 1607 and Windows Server 2016
For a list of the files that are provided in this update, download the file information for cumulative update 4284833.
For Windows RT 8.1
File name |
File version |
File size |
Date |
Time |
Platform |
---|---|---|---|---|---|
Rsaenh.dll |
6.3.9600.17200 |
165,824 |
07-Jun-2014 |
10:06 |
Not applicable |
For all supported x86-based versions of Windows 8.1
File name |
File version |
File size |
Date |
Time |
Platform |
---|---|---|---|---|---|
Rsaenh.dll |
6.3.9600.17200 |
189,016 |
07-Jun-2014 |
10:20 |
x86 |
For all supported x64-based versions of Windows 8.1 and of Windows Server 2012 R2
File name |
File version |
File size |
Date |
Time |
Platform |
---|---|---|---|---|---|
Rsaenh.dll |
6.3.9600.17200 |
216,368 |
07-Jun-2014 |
12:46 |
x64 |
Rsaenh.dll |
6.3.9600.17200 |
189,016 |
07-Jun-2014 |
10:20 |
x86 |
Workaround
To work around this issue, encrypt the SYMMETRIC key by using a password instead of a certificate.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
More Information
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
Additional file information for Windows RT 8.1, Windows 8.1, and Windows Server 2012 R2
Additional files for Windows RT 8.1
File property |
Value |
---|---|
File name |
Arm_09dd58757800de51b3c5310c5b3922b3_31bf3856ad364e35_6.3.9600.17201_none_59cfebc2519c83cc.manifest |
File version |
Not applicable |
File size |
698 |
Date (UTC) |
09-Jun-2014 |
Time (UTC) |
17:03 |
Platform |
Not applicable |
File name |
Arm_microsoft-windows-rsaenh-dll_31bf3856ad364e35_6.3.9600.17201_none_f4bcac7acc9d1dc5.manifest |
File version |
Not applicable |
File size |
2,617 |
Date (UTC) |
07-Jun-2014 |
Time (UTC) |
11:11 |
Platform |
Not applicable |
Additional files for all supported x86-based versions of Windows 8.1
File property |
Value |
---|---|
File name |
X86_9dcb6de35b79d4c35c2bbaeb31b3559e_31bf3856ad364e35_6.3.9600.17201_none_b28f8a3e24abb79c.manifest |
File version |
Not applicable |
File size |
698 |
Date (UTC) |
09-Jun-2014 |
Time (UTC) |
16:14 |
Platform |
Not applicable |
File name |
X86_microsoft-windows-rsaenh-dll_31bf3856ad364e35_6.3.9600.17201_none_f4ba3a22cc9ffeff.manifest |
File version |
Not applicable |
File size |
2,617 |
Date (UTC) |
07-Jun-2014 |
Time (UTC) |
10:43 |
Platform |
Not applicable |
Additional files for all supported x64-based versions of Windows 8.1 and of Windows Server 2012 R2
File property |
Value |
---|---|
File name |
Amd64_9dcb6de35b79d4c35c2bbaeb31b3559e_31bf3856ad364e35_6.3.9600.17201_none_0eae25c1dd0928d2.manifest |
File version |
Not applicable |
File size |
700 |
Date (UTC) |
09-Jun-2014 |
Time (UTC) |
17:10 |
Platform |
Not applicable |
File name |
Amd64_dbf4f750b16b2ab5f215db3f98fa3563_31bf3856ad364e35_6.3.9600.17201_none_6ae995bb3e5f63b1.manifest |
File version |
Not applicable |
File size |
702 |
Date (UTC) |
09-Jun-2014 |
Time (UTC) |
17:10 |
Platform |
Not applicable |
File name |
Amd64_microsoft-windows-rsaenh-dll_31bf3856ad364e35_6.3.9600.17201_none_50d8d5a684fd7035.manifest |
File version |
Not applicable |
File size |
2,621 |
Date (UTC) |
07-Jun-2014 |
Time (UTC) |
13:11 |
Platform |
Not applicable |
File name |
X86_microsoft-windows-rsaenh-dll_31bf3856ad364e35_6.3.9600.17201_none_f4ba3a22cc9ffeff.manifest |
File version |
Not applicable |
File size |
2,617 |
Date (UTC) |
07-Jun-2014 |
Time (UTC) |
10:43 |
Platform |
Not applicable |