Solved

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

Posted on 2010-11-10
5
470 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 69

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

Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
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 tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

773 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