Browse by Tags

All Tags » General Tuning » memory (RSS)

dbcc dropcleanbuffers - or maybe not

As a consequence of another action I was prompted to want to clear the buffer cache – or to be more precise I tried to clear the buffer cache. So stepping back, what happens if you install more memory than the combined size of your databases? Most would...

Configuring Windows 2003 ( x64 ) for SQL Server

There is an almost constant stream of posts on forums asking about configuration of SQL Server 2005 memory, especially for x64 editions. Alongside these are also a number of posts concerning performance or perceived performance issues with x64 SQL Server...