Re: Optimal drive\partition config for SQL
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Thu, 19 Jan 2006 12:45:26 -0500
It is really hard to say without knowing exactly how much read and write
activity these users generate in regards to SQL Server. But given those disk
restrictions I would opt for a 2 disk Raid 1 for the OS and SQL Transaction
logs (all dbs). Then take the remaining 4 or 6 drives in a RAID 10 for the
data and tempdb files. Backing up to the same Raid that the data or log
files are on is never really a good idea for availability and performance
reasons. But if you will immediately copy them to tape it may be OK.
Otherwise I recommend backing up to a remote share somewhere.
--
Andrew J. Kelly SQL MVP
"Ariel" <Ariel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B410BD37-5DC1-43BE-871A-2500DB00C539@xxxxxxxxxxxxxxxx
> Hello,
>
> We are getting ready to migrate from a WMSDE based Windows Sharepoint
> Server
> deployment to SQL Server 2005. Here's the thing, I know nothing about
> SQL.
> But I'm guessing it's important to setup my HDDs properly to maximize SQL
> performance. I have about 50-60 WSS users that use the application to
> varying degrees. I have read that in order to optimize SQL performance, I
> should consider something like the following disk setup:
>
> array 1 : 2 disks, raid 1
> Part 1: win OS
> Part 2: tempdb
> Part 3: other log files
>
> array 2 : 4 disks, raid 10
> Part 1: all data,
>
> array 3 : 2 disks raid 1
> Part 1: main db (70% load) log files
> Part 2: temporary storage for backup, only used for maintenance.
>
> This looks good. It also looks expensive. Given my user load is light,
> do
> I really
> need this level of complexity, or can I just have 1 RAID 5 setup, or maybe
> RAID 1 for OS and RAID 5 for data? Any suggestion\recomendations would be
> greatly appreciated. Thanks!
>
.
- Prev by Date: Sql2k Scheduled job
- Next by Date: Re: SQL Express non-functional outside of VS 2005
- Previous by thread: Sql2k Scheduled job
- Next by thread: Re: Optimal drive\partition config for SQL
- Index(es):
Relevant Pages
|
