Browse by Tags

DBCC CHECKDB flusing the cache!

Published 15 May 7 9:54 AM | SqlServer-QA.net (SSQA)

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...

Filed under: sql server, management, ssis, security, ssms, perfmance, cache, flush, checkdb

What events will cause a flushing of plan in cache?

Published 14 May 7 7:17 AM | SqlServer-QA.net (SSQA)

We already know that using DBCC FREEPROCCACHE will have the affect of flushing all the cache with immediate affect and also DBCC FREESYSTEMCACHE (new in SQL 2005) has similar affect but will flush the plans asynchronously that are marked as unused anymore...

Filed under: sql server, management, memory, security, perfmance, plan, cache

Get statistics on Query plan optimizer execution

Published 11 May 7 4:48 AM | SqlServer-QA.net (SSQA)

As you might know PERFMON (SYSMON) and DMVs in SQL 2005 are very handy to know internal resource information about the SQL Server engine. So you might be thinking what might be the cause of this poor performance when you have a simple query to run and...

Filed under: sql server, stats, security, query, optimization, perfmance, reporting