Sql Server : Difference between FREESYSTEMCACHE, FREEPROCCACHE, DROPCLEANBUFFERS, etc

Posted by Sqltimes
On July 25, 2015
0 Comments

Quick one today: In a previous post, we discussed the different ways to clean Sql Server cache. Now we look at another one. DBCC FREESYSTEMCACHE. 1 2 DBCC FREESYSTEMCACHE('ALL') GO DBCC FREESYSTEMCACHE As the name suggests, FREESYSTEMCACHE allows us to free up any unused cache in Sql Server memory. Sql Server usually, cleans up any […]

Posted by Sqltimes
On July 18, 2015
0 Comments

Quick one today: A few weeks ago, we ran into an interesting error. This nebulous error has caused some confusion in the team, as it occurred during a high pressure situation. After the event passed, and everyone came back to normal state, it became apparent that this is a innocuous error. Lock request time out period […]

Posted by Sqltimes
On July 11, 2015
0 Comments

Quick one today: Sometimes there is a need to track the usage patterns of transactional log file usage. There is a quick and efficient way to gather this data on regular basis. 1 2 3 4 5 -- -- Check the log file space usage -- DBCC SQLPERF(LOGSPACE) GO It gives, Database Name, Log Size […]

Posted by Sqltimes
On July 4, 2015
0 Comments

Quick one today: Earlier, there was an interesting question that came up during a discussion. When we perform ‘ALTER INDEX ALL ON dbo.test REBUILD’ does it change the data COMPRESSION status of the table? In short, no. It keeps it the way it was before the REBUILD started. Since this is a REBUILD (without changing […]

Sql Server : Difference between FREESYSTEMCACHE, FREEPROCCACHE, DROPCLEANBUFFERS, etc

Sql Server Error Messages : Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

Sql Server : How to check transactional log file usage

Sql Server : ALTER INDEX REBUILD does not change data COMPRESSION status of the table