Tell me about the issue and I’ll help you find the solution you need.
FIX: SQL Cache Memory decreases and CPU usage increases when you rebuild an index for a table in SQL Server
Content provided by Microsoft
Applies to: Microsoft SQL Server 2014 EnterpriseMicrosoft SQL Server 2014 EnterpriseMicrosoft SQL Server 2014 DeveloperMicrosoft SQL Server 2014 DeveloperMicrosoft SQL Server 2014 StandardMicrosoft SQL Server 2014 StandardMicrosoft SQL Server 2014 WebMicrosoft SQL Server 2014 WebMicrosoft SQL Server 2012 Service Pack 2Microsoft SQL Server 2012 DeveloperMicrosoft SQL Server 2012 EnterpriseMicrosoft SQL Server 2012 StandardMore
When you rebuild an index for a table in Microsoft SQL Server 2012 or SQL Server 2014, SQL Cache Memory may decrease and CPU utilization increases. Additionally, SQL Server may experience out-of-memory errors.
This issue occurs because much memory is consumed by the MEMORYCLERK_SQLLOGPOOL memory clerk that is used internally for transaction log activities.
Note This issue only occurs when you use AlwaysOn availability groups in SQL Server 2012 or SQL Server 2014.
The issue was first fixed in the following cumulative update of 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: