Post reply

Digging for more detail on secondary transaction log files

  • June 8, 2011 at 9:42 am

    #251467

    Does anyone know of any good articles which elaborate on how a secondary transaction log file will be utilized by the Engine? BOL seems to briefly cover this but I'm not sure that it's exactly what I'm looking for, unless the real answer is as seemingly simple as BOL makes it - that it just uses the first log file until it is full, then proceeds on to filling up the next. That seems...overly simplistic?

  • June 8, 2011 at 9:57 am

    #1335780

    It may seem overly simplistic, but at the core it's correct. SQL uses the files serially, never in parallel. Hence there's no advantage to having say 2 5GB log files as opposed to 1 10GB log file.

    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

  • June 8, 2011 at 10:05 am

    #1335789

    Many thanks, Gail.

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

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