Logical Drives

Any advantages/disadvantages in having two separate logical drives when
adding array discs in SQL server. This space will be mainly used for backup
s
and t-log backups.
ThanksNiles wrote:
> Any advantages/disadvantages in having two separate logical drives
> when adding array discs in SQL server. This space will be mainly
> used for backups and t-log backups.
> Thanks
Are you saying you want to partition you hard drives in the array? If
you're like most customers, you are probably using a RAID 5 array for
the data (the cheapest redundant solution). If so, RAID 5 has terrible
write performance. You would be better off using a mirrored set for the
OS and another mirrored set for the log files. Log files should never
really be on a RAID 5 array since they are written to sequentially. Same
with a backup file.
Let us know how you plan to configure the arrays for the server.
David Gugick
Imceda Software
www.imceda.com|||I'll assume you have your RAID configuration correctly set up. So, having
multiple devices? SQL Server will spawn multiple threads if you have
multiple devices. However, if you use sqlmaint, it will not create multiple
devices, so there would be no performance advantage except if you had
multiple maintenance schedules.
Sincerely,
Anthony Thomas
"Niles" wrote:

> Any advantages/disadvantages in having two separate logical drives when
> adding array discs in SQL server. This space will be mainly used for back
ups
> and t-log backups.
> Thanks