Browse by Tags

All Tags » General Tuning » File Under Grumpy (RSS)
30 March 2009 21:35

Parallel Worlds or slipped reality?

I’ve been planning a post on the subject of parallelism for some considerable time but the inability to be able to present reproducible tests for illustration had been a major concern. Things change however, I picked up on an interesting post  http...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
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 | 1 comment(s)
Filed under: , , ,
04 January 2007 16:48

Not Thinking it through - the saga continues

The saga continues ……….. Here below are the previous posts which relate to the management of a production SQL Server ( by a third party ). We asked that the job which re-indexes the database be disabled until such time as the issue of the database mode...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,