RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

Clear Cache Sql

Clear entire procedure and databuffer cacheCheckpoint --> Write dirty pages to diskDBCC FreeProcCache --> Clear entire proc cacheDBCC DropCleanBuffers --> Clear entire data cacheClear only a particular db procedure cache using undocumented DBCC commandDeclare @DBID intSelect @DBID =db_id(‘YourDBname’)DBCC FLUSHPROCINDB(@DBID) – Undocumented dbcc command to clear only a db proc cache  
Leggi tutto il post...
Categoria: Sql Server ALL
venerdì, 20 feb 2009 Ore. 21.07

Scrivi un commento

Non è possibile inviare commenti a questo Blog


Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003