|
Home > Archive > MS SQL Server > December 2006 > most i/o logs or database
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 |
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
| |
| Tracy McKibben 2006-12-12, 7:12 pm |
| 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
|
|
|
|
|