I hope someone can help.
In my event logs on a windows server 2003 dc I am getting an informational message from Mssql$Sophos about every 5 minutes and it is filling the logs. Here is the message :
Event Type: Information
Event Source: MSSQL$SOPHOS
Event Category: (2)
Event ID: 2803
Date: 02/08/2010
Time: 12:36:48
User: N/A
Computer: Description:
SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
What i want to know is is there any way of stopping the message from appearing atall or atleast less frequent.
Thanks in advance
Gareth
Quote