Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database Files on RAID's Seperating for Performance...
Message
From
25/10/2002 10:15:45
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Database Files on RAID's Seperating for Performance...
Miscellaneous
Thread ID:
00715440
Message ID:
00715440
Views:
36
I have inherited a database and am trying to determine how to cleanup the structure.

There are 3 databases with multiple data files split over several logical drives (c,e,f,h,i,j,k and l). All these logical drives sit on 3 RAID arrays with ONE controller card. Each array is split into several logical drives
One Controller Card
Array - Drives
A - C,E,F
B - H
C - I,J,K,L

I understand seperating the datafiles (and log files) on seperate drives increases performance.

Question 1: In this scenario where each RAID Array is on the same controller card, is there a performance benefit ?

Question 2: If yes to question 1, Does the performance benefit continue on to the logical drives that are created by seperating a particular array into 4 logical drives (as in C).

What I'd like to do to make my administration easier is to compine the 3rd array (c) into one logical drive. (mostly to make it easier to restore to another server that might not have the same drive configuration.)

I'd keep the current situation if I could control where tables are created within each data file, but unfortunately the application creates tables (e.Piphany) and they are all created in the primary partition....my backups would definetly be eaiser if I could control where tables are created.
Reply
Map
View

Click here to load this message in the networking platform