August 21, 2008 at 1:53 pm
Is there a way to free the buffer cache without stop starting the SQL Server service? I am testing some code out and I need the pool to be free between each iteration. Checkpointing and dbcc FREESYSTEMCACHE ('all') has no effect in case you might want to suggest those. What would be especially nifty is if I could free the cache objects for a particular database.
Thanks
August 21, 2008 at 6:26 pm
Run a checkpoint, followed by DBCC DROPCLEANBUFFERS. That's database wide. I think there is an option to clear the buffer pool per database, but I can't recall the command now. Need to get back to office to find that out...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply