Some reasons for SQL Server cache cleanup

1, DBCC FREEPROCCACHE;

2. DBCC FREESYSTEMCACHE (' All ') | DBCC FREESYSTEMCACHE (' pool_name ');

3, declare @dbid as int = db_id (' Studio '); DBCC FLUSHPROCINDB (@dbid);

4. Disconnecting the database

5. Turn Auto_Close on or off

6. Use the following command

Alter DATABASE .... collation

ALTER DATABASE .... Modify Name

ALTER DATABASE .... MODIFY Filegroup

ALTER DATABASE .... Set online

ALTER DATABASE .... set offline

ALTER DATABASE .... SET Emergency

ALTER DATABASE .... Set READ_ONLY

ALTER DATABASE .... Set Read_write

7. Delete Database

　　

Some reasons for SQL Server cache cleanup