asked on
What's the best configuration if SQL server is running on SAN device?
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.
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.
Microsoft SQL Server 2005Server HardwareStorage
Last Comment
Qlemo
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.