Post reply

One Log Writer per instance?

  • November 11, 2013 at 1:35 am

    #300833

    Hi guys,

    Looking at sys.sysprocesses I saw one Log Writer process, rather than one per database. Does this mean that worker threads are used by databases A, B & C to avoid this being a bottle neck?

    Dird

  • November 11, 2013 at 1:48 am

    #1665382

    The log writer process is not the process that writes logging records to disk. User processes do that. Hence why you see user processes with WRITELOG waits (a wait for a log write to disk to complete)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply