Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 8 replies
  • Subscribers 1 subscriber
  • Views 3745 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Mssql$Sophos in event logs

Gazza

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

:4322


This thread was automatically locked due to age.
  • 0

    Hello Gazza,

    seeing also Event ID 17137 - "Starting up database SOPHOSxx"? Check whether the database option Auto Close for the SOPHOSxx database is set to ON (or True) and if it is set it to OFF.

    Christian

    :4325
  • 0

    Thanks for the reply Christian.

    I am getting that event aswell. Where do i need to go to check that setting

    Thanks

    :4333
  • 0

    Hi Gareth,

    This wouldn't happen to be a database that was upgraded to SQL Server 2005 Express, would it?

    The following command should switch off auto-close - you don't mention which version of Enterprise Console is installed, so if you are running 4.5, please change sophos4 to sophos45:

    osql -E -S .\sophos -d sophos4 -Q "alter database sophos4 set auto_close off"

    To confirm that auto-close option is set to off:
    osql -E -S .\sophos -d sophos4 -Q "exec sp_dboption @dbname='sophos4', @optname='autoclose'"

    Cheers,

    Lil

    :4338
  • 0

    To answer your question yes it is.

    I tried your suggestion lilhavoc but it is giving me an error saying :

    Error: No user selected. try -u or -e switches

    I am not sure of the correct syntax for this so any help would be much appreciated.

    Thanks

            Gareth

    P.s. I am running enterprise console 4

    :4369
  • 0

    Hi Gareth,

    Can you break down the command and check if the following works...

    osql –E –S .\sophos

    If this short command fails and still returns the error regarding no user selected, make sure you type the command in manually rather than pasting from this page.  If the command does work you should see a new line in the command prompt showing...

    1>_

    Now type the following commands exactly as shown...

    use sophos4

    go

    exec sp_dboption @dbname='sophos4', @optname='autoclose'

    go

    exit

    Let me know how it goes.

    Lil

    :4373
  • 0

    I have to apologise for being a bit thick .

    I typed your original command in but didnt realise that the switches were case sensitive. After typing the commands excactly as you have them in your original post it worked fine.

    Thanks for your help lilhavoc

                   Gareth

    :4375
  • 0

    No worries -- just glad it worked in the end -- no one deserves spam in the event log!!!

    Cheers,

    Lil

    :4378
  • 0

    Hi, i was getting the same message, i have made just what you say about set AUTO_CLOSE OFF and it seems to be ok, bye bye spam!

    I'm using W2003, SQL Server 2005 Express and EC4.5.

    Thanks,

    Alberto

    :10819
Unfiltered HTML