log files

there is controversial topic in my dept. If we put log files of databases on
different mirrored drive we will improve the performance.
Is that true for system dbs too. What are your reccomendations, guys?
In my oppinion sys db should be secured on different mirrored drive with sql
executables.Eli Milkova wrote:
> there is controversial topic in my dept. If we put log files of
> databases on different mirrored drive we will improve the performance.
> Is that true for system dbs too. What are your reccomendations, guys?
> In my oppinion sys db should be secured on different mirrored drive
> with sql executables.
If by system database you mean tempdb, then the answer is yes. Ideally,
tempdb should be on an array with fast sequential write access (RAID 1
or RAID 10). If you're talking about master, model, and msdb, then the
answer is probably no. You can keep those databases on the array that
holds the rest of the DBs since are generally small and are accessed and
changed with less frequency that user databases. I would not generally
recommend they are on placed the OS array. The OS array is best for the
OS and applications, not database files.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com