troubleshooting Question

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

Avatar of towo2002
towo2002 asked on
Microsoft SQL Server 2005Server HardwareStorage
4 Comments3 Solutions503 ViewsLast Modified:
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.

ASKER CERTIFIED SOLUTION
EvilPostIt
IT Director

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros