> I've inherited a SQL server that has several databases. Most of the
> databases were configured with 2 transaction logs. It is my understanding
> that SQL writes to the Tranaction Logs sequentially, so I don't see any
> benefit to multiple files. The server has sufficient room for the
> Transaction Logs to expand, so space isn't an issue.
>
> Also the databases were configured with the Data and Log Files on the same
> drive / volume. The server is configured with SAN attached storage which
> is
> presented as multiple drives (17). I am in the process of designing a
> plan
> to separate the Data and Log files. This server has 60 databases of
> various
> sizes, and is primarily utilized as a data warehouse environment. There
> is
> nightly processing that occurs to update the databases, but are typically
> read only from that point.
>
> My question is where is the best location for the transaction logs? Is it
> better to keep the transaction logs on a couple of the drives that contain
> only transaction logs, or distribute them accross the drives with Data
> Files
> (but not the Data Files of the same Database)?
>
> The nightly process that happens does load multiple database at the same
> time.
>
> Any suggestions would be appreciated.
>
> Thanks,
> John