Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2010-11-01 : 13:16:19
|
| Hi,My plan as follow,1. 1 Dedicated Server for SQL Server 2005 Enterprise Edition (64 bit)2. SAN Storage with 3 physical drives such as RAID0, RAID1, and RAID5I'm gonna to install my SQL Server 2005 Enterprise Edition (64 bit) as follow1. SQL Server Program Files into RAID02. SQL Server Log Files (ldf) into RAID13. SQL Server Data Files (mdf) into RAID5Did my SQL Server installation is apply for performance wise?Need advice |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-01 : 13:23:00
|
| RAID1+0 for MDF perhaps?You got another drive you can store backups on?Is RAID0 mirrored? or just a single drive? (sorry, I can never remember!) I would not want O?S to be on a single drive and be a single point-of-failure.What about TEMPDB? |
 |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2010-11-01 : 13:30:04
|
| I've only SAN Storage with 3 physical drives such as RAID0, RAID1, and RAID5How I can fully utilise on it? |
|
|
|
|
|
|
Need advice to save SQL Server Files into SAN