none
Error: 2803 Severity: 10 State: 1

    Question

  • Error: 2803, Severity: 10, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

    I am trying to find out ideas on how to troubleshoot this error message and exactly what it means. I have seen lots of articles call this error message out but nothing really explaining the significance of it or the true meaning, or even things to check when a similar error has been seen. The error is always preceeded by "Starting up database....." I don't necessarily know if that is related or not

    Any ideas on what this error typically means

    Wednesday, September 29, 2010 4:39 PM

Answers

  • Hi,

    We could use the statement “select  *  from  sys.messages  where  message_id = 2803  and  language_id = 1033” to query the general meaning of the error.And this error stands for “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”.

    The reason for this error is :
    When the database is set to AUTOCLOSE = ON, 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.'

    But to fix this issue, we often need more detail information such as event log and SQL Server error log. So please post these error log here, and we are happy to assit you.

    Please feel free to ask if you have any more questions.

    Thanks,
    Weilin Qiao

    Friday, October 01, 2010 9:59 AM
    Moderator

All replies

  • Hi,

    I feel that your database is auto close mode. Can you disable auto close option if enabled?


    Ramesh S
    www.sequalserver.com
    Wednesday, September 29, 2010 4:50 PM
  • Hi,

    We could use the statement “select  *  from  sys.messages  where  message_id = 2803  and  language_id = 1033” to query the general meaning of the error.And this error stands for “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”.

    The reason for this error is :
    When the database is set to AUTOCLOSE = ON, 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.'

    But to fix this issue, we often need more detail information such as event log and SQL Server error log. So please post these error log here, and we are happy to assit you.

    Please feel free to ask if you have any more questions.

    Thanks,
    Weilin Qiao

    Friday, October 01, 2010 9:59 AM
    Moderator