Re: SQL 2000 on SAN

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

>>From what I am reading, most people say that you should treat your SAN
just like local disks.  So the best disk layout we could ask for would
look like this:

One LUN with RAID 10 space for log files & tempdb
One LUN with preferably RAID 10 space, but RAID 5 is ok for DB files

I just understand the theoretically ideas behind a SAN.  Can one set of
fault tolerant controllers mount two separate LUNs that connect to two
different sets of disks.  Now the above would assume that the provider
has multiple SAN segments that are divided into RAID10 or RAID 5 space,
correct?  If they have all the SAN in one big RAID 5 set then the above
is impossible...

Also, I have read in a few places about optimizing disk I/O on
databases and tempdb by creating one file per CPU so your disk I/O is
better threaded.  Is this still the case when your database files are
located on a SAN volume?

Thank You,
Kevin

.

Relevant Pages

  • Re: How to verify/fix High Disk Read Latencies in Exch2003 ?
    ... Exchange production servers are, the SAN is an EMC CX600. ... >>> current log file on disk and continues until data in the log buffers ... Comingling occurs whe two or more LUNs reside ...
    (microsoft.public.exchange.admin)
  • Re: Adding more iSCSI LUNs to existing MSCS 2000
    ... MVP - Windows Server - Clustering ... > If I add an iSCSI or fibre channel disk to 2 machines at once, ... > Adding a LUN, no problem. ... > both disks are not reading/writing to the LUN on the SAN. ...
    (microsoft.public.windows.server.clustering)
  • Re: HP EVA4000 / IBM DS4300 / EMC CX3-20/40
    ... disk array with the virtual raidsets on top. ... So, the system admin, and the DBAs had to create and manage lots of ... separate LUNs and *manually* manage the performance among them to ... applications on the SAN. ...
    (comp.arch.storage)
  • Re: How to verify/fix High Disk Read Latencies in Exch2003 ?
    ... Do they all map LUNs to your SAN? ... > wondering how the disk could be highly utilized if I have no users ... >> following formulats for the RAID type of each LUN: ...
    (microsoft.public.exchange.admin)
  • Re: LVM striping on luns
    ... from a SAN attached via fibre channel. ... In a SAN environment you have to consider that one LUN on a RAID can influence the performance of the others LUNs on the same RAID as far as they share the same disks. ... On a stripped filesystem, reads and writes occur on all the Physical Volumes of the pool, if one of them becomes slow, the performance of the whole filesystem will also becomes slow. ...
    (RedHat)