How to troubleshoot Writelog wait type?

Few weeks ago when I was teaching the SQL Server PTO Workshop, I didn’t do a deep dive into how to troubleshoot writelog wait type.  Before I wrote something, I decided to look what was out there.  I think Sakthivel does a far more justice to the issue then I would have.  Please have a read, how T-Log works and why you might see writelog wait type.

  • Sakthivel Chidambaram; What is WRITELOG waittype and how to troubleshoot and fix this wait in SQL Server? (Link)
  • SQLCAT, Lindsey Allan; Diagnosing Transaction Log Performance Issues and Limits of the Log Manager (Link)
  • SQLCAT Blog; Deploying SQL Server 2005 with SAN #3 (Link)
  • CSS SQL Server Engineer Blog; Discussion About SQL Server I/O (Link)
  • MSDN, SQL Server 2005 Technical Articles; SQL Server I/O Basics, Chapter 2 (Link)
  • Bob Dorr, Microsoft SQL Server Principal PFE; Microsoft SQL Server Database Engine I/O PowerPoint Presentation (Link)

(copied links from Sakthivel’s Blog).


  1. Mohit:

    I am having quite a bit of I/O issues and wanted your thoughts on how to determine my current configuration of read\write on the HBA Controller.

    I know how to investigate performance of reads\writes via Perfmon. But, will like to know how ti go about determine whether someone has set explicit ratios on SCSI or HBA Controllers.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.