SQL Server Performance

WRITELOG wait types - what your SQL Server is saying?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Oct 12, 2007.

  1. Anonymous New Member

    Whenever the SQL Server is struggling to write the transactions to the disk, you would observe WRITELOG wait type within SP_WHO2 results. So when you observer such wait types then you should be worried on the disks performance, either you plan for shrinking the transaction log (which is a temporary workaround) or add a second log file on a different disk. The reason behind for this wati type is heavy rollback activity adds additional log and disk I/O contention, and such activity has been observed...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/10/12/2452.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=2452" width="1" height="1">

Share This Page