Tag Archives: Performance

The Load Poll

Posted on December 21, 2012 by way0utwest

I was taking to someone recently and this person had a large transaction load on their SQL Server. At least, I thought it was a large load. This person said they experienced 1000tps most of the time and this made … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Load Poll

Leaving Some Headroom

Posted on July 26, 2012 by way0utwest

I was reading this piece on scaling Dropbox and something caught my eye. It’s a very interesting read, especially if you deal with scaling, and I’d encourage everyone that works with technology to read it. The one thing that really caught my … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Leaving Some Headroom

RECONFIGURE can flush the procedure cache

Posted on January 19, 2012 by way0utwest

I ran across this KB article the other day, which lists a few ways in which performance is affected by various maintenance or administrative type operations. In KB article 917818, it notes that some operations cause a performance issue. Some … Continue reading →

Posted in Blog | Tagged , , | Comments Off on RECONFIGURE can flush the procedure cache

The Cost of Page Checksums

Posted on July 25, 2011 by way0utwest

What’s the overhead for a page checksum? I’ve seen various numbers thrown out, but I thought that Paul Randal had written at one point that it was around 1-2%. I can’t find a reference, but in this post, Paul doesn’t … Continue reading →

Posted in Blog | Tagged , | 1 Comment