Sign in | Join | Help

Grumpy Old DBA

The Grumpy Old DBA is an independent DBA who usually specialises in production support and the performance, tuning and optimisation of databases and applications.

This Blog

  • Home
  • Contact
  • About

Syndication

  • RSS
  • Atom
  • Comments RSS

Search

  • Go

Tags

  • Best Practice
  • Code Tuning
  • Consistency / dbcc
  • Diagnostics
  • File Under Grumpy
  • General Tuning
  • Indexes
  • memory
  • operating systems
  • Partitioning
  • Replication
  • SAN
  • SQL Bits
  • SQL2008
  • SSRS
  • Technical Links
  • Things I hate
  • Training & Certification
  • Trending and Statistics
  • x64

Navigation

  • Home
  • Blogs
  • Forums
  • Photos
  • Downloads

Archives

  • September 2008 (1)
  • August 2008 (3)
  • July 2008 (2)
  • June 2008 (3)
  • May 2008 (2)
  • April 2008 (3)
  • March 2008 (4)
  • February 2008 (5)
  • January 2008 (4)
  • November 2007 (2)
  • October 2007 (3)
  • September 2007 (7)
  • August 2007 (4)
  • July 2007 (6)
  • June 2007 (3)
  • April 2007 (1)
  • March 2007 (1)
  • January 2007 (2)
  • December 2006 (7)
  • November 2006 (14)
  • October 2006 (5)
  • September 2006 (3)
  • August 2006 (1)

Browse by Tags

All Tags » memory » File Under Grumpy (RSS)
  • Diagnostics
  • General Tuning
22 February 2008 20:34

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...
Posted by GrumpyOldDBA | with no comments
Filed under: File Under Grumpy, Diagnostics, General Tuning, memory
Powered by Community Server (Commercial Edition), by Telligent Systems