澳门在线威尼斯官方 > 电脑数据库 > SQL Server has encountered 1 occurrence(s) of cachestore flu

原标题:SQL Server has encountered 1 occurrence(s) of cachestore flu

浏览次数:173 时间:2019-10-30

2017-11-01 09:49:44.35 spid166     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.
2017-11-01 09:49:47.85 spid166     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.
2017-11-01 09:49:47.85 spid166     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.

数据库E途乐ROCR-VLOG中冒出形似记录,由此去寻觅有关的文书档案,开掘SQL Server在做一些配置退换时会通透到底消逝一遍实施安排缓存,那很好的解释了成都百货上千时候改善最大内部存款和储蓄器也会变成实践安插转移,SQL试行质量变化的情形。具体的合希腊语档为:

可是官方网站也表达此类现象只在SQL Server2006SP2以前的本子现身,今后的版本已经修复,具体表现还未有可见。

文档中列出了装有望引致此种景况出现的操作:

  • A database has the AUTO_CLOSE database option set to ON. When no user connection references or uses the database, the background task tries to close and shut down the database automatically.
  • You run several queries against a database that has default options. Then, the database is dropped.
  • A database snapshot for a source database is dropped.

    Note Database snapshots are only available in Microsoft SQL Server 2005 Enterprise Edition.

  • You change the database state to OFFLINE or ONLINE.
  • You successfully rebuild the transaction log for a database.
  • You restore a database backup.
  • You run the DBCC CHECKDB statement.

    Note This is true only in versions of SQL Server 2005 that are earlier than SQL Server 2005 SP2. After you install SQL Server 2005 SP2 or later versions, the whole procedure cache is not flushed when you run the DBCC CHECKDB statement.

  • You detach a database.
  • You specify one of the following options when you run the ALTER DATABASE statement:
    • OFFLINE
    • ONLINE
    • 威尼斯澳门在线 ,MODIFY FILEGROUP DEFAULT
    • MODIFY_NAME
    • MODIFY FILEGROUP READ_WRITE
    • COLLATE
    • MODIFY FILEGROUP READ_ONLY
    • READ_ONLY
    • READ_WRITE
  • The whole procedure cache is cleared if one of the following server options is changed by the RECONFIGURE statement:
    • cross db ownership chaining
    • index create memory (KB)
    • remote query timeout (s)
    • user options
    • max text repl size (B)
    • cost threshold for parallelism
    • max degree of parallelism
    • min memory per query (KB)
    • query wait (s)
    • min server memory (MB)
    • max server memory (MB)
    • query governor cost limit
Note Procedure cache will not be cleared if the actual value does
not change or if the new value for the max server memory server
option is set to 0.

本文由澳门在线威尼斯官方发布于电脑数据库,转载请注明出处:SQL Server has encountered 1 occurrence(s) of cachestore flu

关键词:

上一篇:【威尼斯澳门在线】安装TIMESTAMP和DATETIME的自行初

下一篇:MySQL安装