| Author |
Topic |
|
david_ste
Starting Member
4 Posts |
 Posted - 2007-03-16 : 16:12:44
|
| I have detached a SQL Server 2005 database from one server and attached it to another SQL Server 2005 and I now get the following in the error Log and in the event viewer evry 10 - 20 minutes or so.SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.2007-03-16 12:37:14.64 spid17s SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.2007-03-16 12:37:14.64 spid17s 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.Starting up database 'DBName'It appears under different SPID's 18, 20, 24 ...... and consistently has the 4 errors in a rowFull Text indexing is running for both servers but I dont know if this is the cause of the error. I would greatly appreciate any help to get rid of this as I have trawled the net and not found anything of use.Thank You. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-03-16 : 16:15:43
|
| The database is not set to auto-close, is it? |
 |
|
|
david_ste
Starting Member
4 Posts |
Posted - 2007-03-16 : 17:17:33
|
| Just tried setting it from Books online but could not tried DbName.AutoClose = false is there a way I can tell how this property is set?PS Thank you for your quick reply I appreciate it. |
|
|
|
david_ste
Starting Member
4 Posts |
Posted - 2007-03-16 : 17:46:17
|
| The DB was set to auto close have now set it to false and so far everything looks good. Thank you. |
|
|
|
davidoptrics
Starting Member
1 Post |
Posted - 2009-03-23 : 11:24:08
|
We've been getting the same series of errors. We use SightMax (live chat) software for clients to talk to us from our sites.We recently upgraded, and have been getting those same events in our event log:1. SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.2. SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.3. 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.4. Starting up database 'SightMaxDatabase'. Can you advise me if the auto close could be an issue here? It's currently set to "true" when I check with SQL Management Studio Express. There was an original SQL 2005 Express database with the previous version, and when we "upgraded" it also upgraded the database.Could setting it to "false" cause any issues with a chat program that may have about 30 people at a time chatting?ThanksDavidwww.Optrics.com |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-03-23 : 16:19:03
|
quote:
Can you advise me if the auto close could be an issue here? It's currently set to "true" when I check with SQL Management Studio Express.
If you have any database set to autoclose, then you will be seeing these messages. Whenever the DB is closed, the cache is flushed.Having it true is likely to give you problems under the conditions you describe. If autoclose is true, whenever the last connection to the DB closes, SQL cleanly shuts the DB down. The next time someone accesses it, the DB has to be opened and brought on line, then the query has to be compiled (closing the DB flushes cache), then the data has to be queried off disk again (closing the DB flushes cache) and then only can the query run.With autoclose on, you're probably seeing random slowdowns caused by the close and open of the DB.--Gail ShawSQL Server MVP |
|
|
|
manu0417
Starting Member
1 Post |
Posted - 2009-04-02 : 02:42:43
|
| I'm getting the messages as below.SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.2009-03-16 12:37:14.64 spid17s SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.2009-03-16 12:37:14.64 spid17s 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.This is when creating a snapshot. The snapshot is dropped and recreated daily. I'm getting this message everytime the snapshot is created. How can I avoid this?Thanks in advance. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-02 : 09:40:37
|
| Whenever a database is dropped (even if it's a snapshot) the cache is flushed. No way to avoid it. It may be just the cache for the DB that's being dropped, I don't recall.--Gail ShawSQL Server MVP |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-09 : 22:52:04
|
| Yes, Cache are Flushed When Attaching/Detaching databases. Even DBCC CheckDB flushed the cache before SP2. |
|
|
|
|
Attach DB causing cachestore flush