DBCC DROPCLEANBUFFERS失效了？

你也可以通过如下语句查看当前内存中clean页面和脏页的数量和大小：

 SELECT   *  ,

  [  DirtyPageCount  ]   *   8   /   1024   AS   [  DirtyPageMB  ]  ,

  [  CleanPageCount  ]   *   8   /   1024   AS   [  CleanPageMB  ] 

 FROM  

(  SELECT  

(  CASE   WHEN  ( [  database_id  ]   =   32767  )

  THEN  N ‘  Resource Database  ‘ 

 ELSE   DB_NAME  ( [  database_id  ] )  END )  AS   [  DatabaseName  ]  ,

  SUM  ( CASE   WHEN  ( [  is_modified  ]   =   1  )

  THEN   1   ELSE   0   END )  AS   [  DirtyPageCount  ]  ,

  SUM  ( CASE   WHEN  ( [  is_modified  ]   =   1  )

  THEN   0   ELSE   1   END )  AS   [  CleanPageCount  ] 

 FROM   sys.dm_os_buffer_descriptors

  GROUP   BY   [  database_id  ] )  AS   [  buffers  ] 

 ORDER   BY   [  DatabaseName  ] 

 GO 

DBCC DROPCLEANBUFFERS失效了？

标签：

查看更多关于DBCC DROPCLEANBUFFERS失效了？的详细内容...