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. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.
from SQLServerCentral.com Articles http://ift.tt/Y4GoHZ
Nenhum comentário:
Postar um comentário
Leave your comment here!