Archives for April, 2012

TEMPDB and buffer cache


Suppose you notice write latency on TEMPDB is well above acceptable values (in our case 150ms). What can you do? First you need to know TEMPDB is not like any other user database (because it’s a system DB). There is no automated checkpoint process writing your dirty pages to disk. Only if your transactionlog fills […]