July 4, 2012
by
4 Comments | 2,679 views

VN:RO [1.9.17_1161]

Buffer pressure

Trying to determine if you have pressure in your buffer allocations can be difficult. Buffer cache hit ratio is an almost useless metric, so you need a mechanism to let you know if there’s a problem in that area. Read more

July 2, 2012
by
2 Comments | 7,611 views

VN:RO [1.9.17_1161]

WriteLog wait time

During a transaction, data is written to the log cache so that it’s ready to be written to the log file on commit, or can be rolled back if necessary. When the log cache is being flushed to disk, the SQL Server session will wait on the WriteLog wait type. Read more