one transaction log per filegroup?

[plsullivan63]

Is a single transaction log created for a database or, if you have a
primary and a secondary file group in that database, are two
transaction logs generated? Yep, a newbie.
Thanks,
Phil

[Mike Epprecht \(SQL MVP\)]

Hi

SQL Server uses only one virtual log file per database at a time, so having
multiple transaction log files will not help.

Transaction logs are only a performance problem when they are not on disks
that are optimal for them. As they are sequential writes, RAID-10 is best,
and on separate drives to the database files so the IO is not shared by data
reads.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<pl**********@gmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...

Is a single transaction log created for a database or, if you have a
primary and a secondary file group in that database, are two
transaction logs generated? Yep, a newbie.
Thanks,
Phil

[plsullivan63]

Thanks Mike; you've been a great help in our efforts. Happy Holidays!
Phil