What's the best configuration if SQL server is running on SAN device?
Posted on 2010-11-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.