Solved

What's the best configuration if SQL server is running on SAN device?

Posted on 2010-11-10
5
468 Views
Last Modified: 2012-05-10
Dear all experts,

I'm going to setup a SQL Server 2005 for my company, this server will be running on IBM HS22, DS 5020 (10 x 300GB fiber channel disc), dual path I/O.  This server is mainly used for online application (read /write) and seldom run the report.  What I would like to know are as follow:

Should I use RAID5, RAID6 or others?
Do I need to separate data files and the transaction log to another LUN?  Or just combine it into one drive?
What's the segment size (16K, 32K, 64K, etc??)
If it running on cluster, do I need to do other things?
Any others should be pay attention?

Many thanks for your help first.

0
Comment
Question by:towo2002
5 Comments
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 168 total points
ID: 34100827
RAID 1+0 (10) is what would be ideal.

Yes seperate the drives off if possible as they will have independant queue depths from an operating system perspective.

Below is a link regarding SQL Server 2005 sector sizes.

http://support.microsoft.com/kb/926930

Partition alignment is more important if you are not using Windows 2008. As per the link below.

http://support.microsoft.com/default.aspx?scid=kb;en-us;929491&sd=rss&spid=3198

0
 
LVL 7

Assisted Solution

by:D_Vante
D_Vante earned 166 total points
ID: 34111541
Your SAN vendor should be able to tell you which setup gives you the best performance for SQL.  Best IOPs
See if it supports thin provisioning.
0
 
LVL 18

Assisted Solution

by:BigSchmuh
BigSchmuh earned 166 total points
ID: 34153650
I would go with:
-RAID 1 for the OS & Swap
-RAID 10 for data/index
-TempDB may be stored on a parity (5/6) RAID array IF the raid controller has a large write back cache backed by a battery
-RAID 5 (or 6 if using drives with a UBE lower than 1 unrecoverable sector per 10^16 bits read) for Logs/Backups/Archives with 64KB stripe size maximum
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 34488515
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Why run Active Fulls in Backups 19 107
Problem with SqlConnection 4 159
My reclamation process on TSM is failing. 2 66
Question regarding IBM SAN Storage 4 17
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now