SAN And Drive Config

Hi
I have been reading recently that the most important area of design in a SQL
system is the drive subsystem. With this I would appreciate some feedback on
the type of issues relating to this, drive spindles, speed of drives, LUN
configs on the SAN and so on.
Thanks
In an ideal world, you would have these all on different spindles:
O/S, SQL Server program files
TempDB
Data files
Log files
Backup files
Make sure the SAN admin(s) gets actual different spindles, not just
different LUNs in the same disk group. My terminology is probably off, but
I think the point is clear
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"News Microsoft" <thestig@.nobody.com> wrote in message
news:O98pYd$dFHA.2960@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have been reading recently that the most important area of design in a
> SQL system is the drive subsystem. With this I would appreciate some
> feedback on the type of issues relating to this, drive spindles, speed of
> drives, LUN configs on the SAN and so on.
> Thanks
>
>
|||Well, actually the MOST important area where the most performance can be
gained is in the database design. Assuming the database design is
optimal, then you are correct, look at the disk subsystem.
Disk subsystem design could be summarised in a white paper, not in a
single usenet message. Have a search in google - there' plenty of topics
online that discusses this. Sorry I don't have any links for you at the mo.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
News Microsoft wrote:
> Hi
> I have been reading recently that the most important area of design in a SQL
> system is the drive subsystem. With this I would appreciate some feedback on
> the type of issues relating to this, drive spindles, speed of drives, LUN
> configs on the SAN and so on.
> Thanks
>
>
|||awesome article on this topic on SQLServerCentral.com
check it out
Greg Jackson
PDX, Oregon