most i/o logs or database

Hi,

This question is for SQL 2000 and 2005.

Using a single standard database (full recovery model), and assuming the
database and logs are on different physical disks.

If I have a process that is mainly writing continuously to the database,
would you expect the logs or the database to require the most disk
performance?

Thanks,

James

James  wrote:
> Hi,
>
> This question is for SQL 2000 and 2005.
>
> Using a single standard database (full recovery model), and assuming the
> database and logs are on different physical disks.
>
> If I have a process that is mainly writing continuously to the database,
> would you expect the logs or the database to require the most disk
> performance?
>
> Thanks,
>
> James
>
>

Logs.  You want fast writes for the transaction log.


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com