Re: High Performance/High Availability SAN config.. Old Skool vs. New School Question..
From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 07/07/04
- Previous message: Geoff N. Hiten: "Re: SQL2k standard on Win2k3 Web Ed. Wont install"
- In reply to: Larry Kippenhan: "High Performance/High Availability SAN config.. Old Skool vs. New School Question.."
- Next in thread: Geoff N. Hiten: "Re: High Performance/High Availability SAN config.. Old Skool vs. New School Question.."
- Reply: Geoff N. Hiten: "Re: High Performance/High Availability SAN config.. Old Skool vs. New School Question.."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 7 Jul 2004 15:31:25 -0400
I find the various SAN vendors, especially the field salesweasels, only
understand selling a SAN for storage consolidation with LOTS of front-end
servers. They don't 'get' the concept of a SAN dedicated to a small number
of machines that need superfast IO. Sometimes their specialists understand
this, but getting to someone with that level of expertise can be difficult.
Generally speaking, the rules you know for direct attach still hold true for
SAN storage, but with a few gotchas (Alignment offset comes to mind first).
Make sure to get an expert that understands the unique IO patterns of SQL
Server as opposed to general file storage. If the vendor cannot provide
access to such an expert during a pre-sales consultation, then you probably
should keep looking. Of course, you need to understand your data
organization and IO patterns as well.
-- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "Larry Kippenhan" <LWKNOSPAM@att.net> wrote in message news:uNNso6DZEHA.556@tk2msftngp13.phx.gbl... > Well, the time has finally come to upgrade the old SQL Server and SAN. > > So, as I seek out all of the appropriate vendors for my Disk and Server > needs, I start to get some information about disks (SAN) that totally flies > in the face of experience. > > I come from a mixed background of SQL Server and Oracle, and I feel that I > am pretty on top of things as far as how to configure the disks to get the > most out of my IO. > > The issue that seems to be troubling me the most is the SAN vendors that are > claiming that I can have one big Disk Group, and put my Data file groups, > and my Index file groups on different LUNs on the same Disk Group > (essentially sharing Data and Index on the same disks). It even sounds like > they are advocating throwing TempDB there as well. I fully understand that > disks are faster, and controllers are more efficient and all that compared > to even 5 years ago, but I can't quite swallow that... > > If what they are saying is true, then I may as well re-integrate my index > filegroup back into the data filegroup and forget segregating the loads. > > I should also mention that they are at least advocating keeping the random > IO and the sequential IO on separate Disk Groups. > > Does anyone have any recent experience with the newer, large SAN configs, > and experienced the same questions recently? > > Just to give you an idea of the scale, the original 3 year growth config > included about 120 disks to be configured to keep performance maxxed for IO. > Of course I will be using RAID 10 for just about everything (except dumps, > they will be raid 5). > > On a side note, I did almost have to reach through the phone and strangle > the life out of some storage Guru who mentioned that I could consider RAID 5 > for my data.... Fortunately for him I was unable to accomplish that.. > > Thanks again everyone. > > Please respond to this forum. > > Thank you very much. > > Larry > >
- Previous message: Geoff N. Hiten: "Re: SQL2k standard on Win2k3 Web Ed. Wont install"
- In reply to: Larry Kippenhan: "High Performance/High Availability SAN config.. Old Skool vs. New School Question.."
- Next in thread: Geoff N. Hiten: "Re: High Performance/High Availability SAN config.. Old Skool vs. New School Question.."
- Reply: Geoff N. Hiten: "Re: High Performance/High Availability SAN config.. Old Skool vs. New School Question.."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
