|
Home > Archive > Microsoft SQL Server forum > December 2005 > one transaction log per filegroup?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
one transaction log per filegroup?
|
|
| plsullivan63@gmail.com 2005-12-20, 1:24 pm |
| 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\) 2005-12-20, 8:24 pm |
| 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: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<plsullivan63@gmail.com> wrote in message
news:1135105221.803070.50000@g43g2000cwa.googlegroups.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@gmail.com 2005-12-21, 3:24 am |
| Thanks Mike; you've been a great help in our efforts. Happy Holidays!
Phil
|
|
|
|
|