- A rapid decline in the SQLServer:Buffer Manager\Page life expectancy performance counter values. When this issue occurs, the counter is near 0.
- The peak value of the SQL Server: Buffer manager\LazyWrites/sec counter is more than 1 for several seconds.
- An increase in the SQLServer:Memory Manager\Free Memory (KB) performance counter values.
This causes a temporary release of more memory than is required to return to a steady state. For example, the buffer pool can release more data pages than required, inflating the free list depths and reducing the page life expectancy (PLE) for the buffer pool. In this situation, you'll notice a quick decline in the SQLServer:Buffer Manager\Page life expectancy performance counter values and a quick increase in SQLServer:Memory Manager\Free Memory (KB) performance counter values.
Cumulative Update 4 for SQL Server 2012 SP1The fix for this issue was first released in Cumulative Update 4. For more information about how to obtain this cumulative update package for SQL Server 2012 SP1, click the following article number to go to the article in the Microsoft Knowledge Base:
However, we recommend that you install this hotfix as soon as possible. Although the problem is short-lived, it may occur again. Additionally, the decrease in performance may be severe when the issue occurs.
Article ID: 2845380 - Last Review: Aug 14, 2013 - Revision: 1