Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes occur in a database the changes are formed as transactions...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
04-22-2008
Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl
Well another cache related blog in a row since last few days! I have had weird issues on one of the SQL Server 2005 SP1 instance that, whenever DBCC CHECKDB is executed the performance of particular stored procedure ( complexed calculations ) has gone down to sea bed! To ensure my findings using DMVs...