Technical FAQs

Ask a Question

Active Pager Module Event ID 2803 appears in the Windows Application Event Log every 5 minutes

Goals and Symptoms

Symptoms
A similar message is displayed in the Windows Application Event Log under the Source MSSQL$POWERLOGICES:

SQL Server has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore (part of plan cache) due to some database maintenance or reconfigure operations

Causes and Fixes

Cause

When the database is set to AUTOCLOSE = TRUE, an operation that initiates an automatic database shutdown clears the plan cache for the instance of SQL Server. Clearing the plan cache causes a recompilation of all subsequent execution plans and can cause a sudden, temporary decrease in query performance. In SQL Server 2005 Service Pack 2, for each cleared cachestore in the plan cache, the SQL Server error log contains the following informational message: "SQL Server has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore (part of plan cache) due to some database maintenance or reconfigure operations". This message is logged every five minutes as long as the cache is flushed within that time interval.

By Default APM has this AUTOCLOSE set to TRUE









Resolution

1. Open SQL Management Studio and connect to the POWERLOGICES instance
2. Right click on each of the databases (PLES_AEHistory, PLES_APM, PLES_HotStandby, PLES_Logging) and click on Properties. The databases present may vary depending on the eSoltuions software programs installed.
3. Click on the Options page and set Auto Close to False



Was this helpful?
What can we do to improve the information ?