Advertisements
Home > Performance Tuning, Troubleshooting > How to troubleshoot Writelog wait type?

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).

Advertisements
  1. danieladeniji
    April 3, 2012 at 7:06 am

    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.

    Thanks,
    Daniel

  2. April 3, 2012 at 9:36 am

    Hi Daniel,

    Why do you suspect the problem is in HBA? What is you’re latency you are experiencing? How much throughput is being generated by SQL Server? IOPS? Have you eliminated SQL Server as the cause (e.g. database design, indexes, statistics, SQL code being executed)?

    For HBA cards, we can look at the queue depth setting; have a read at http://blogs.msdn.com/b/joesack/archive/2009/01/28/sql-server-and-hba-queue-depth-mashup.aspx.

  1. No trackbacks yet.

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: