Skip to main content
Tweeted twitter.com/#!/StackDBAs/status/135044389167833088
correcting RAID level author originally indicated
Source Link
Nick Chammas
  • 14.8k
  • 17
  • 76
  • 123

I am going to rebuild one IBM 3400 server from scratch. This server is dedicated to a SQL Server 2008 instance running on Windows 2008 R2.

I am going to make new RAID configuration. I have 6 SCSI 73 GB drives inside the machine and an IBM ServerRAID 8K controler. What would be a good way to set the RAID levels? Should I have two, three or one field on my controler?

I am considering to make one of following solutions:

  1. Use all the disk and make a RAID 10 pool.
  2. Use 4 disks for a RAID 11e pool and use it to store the database data and OS, and use the other 2 disks in a RAID 0 pool and use that to store the database logs.
  3. Some other combination.

Is a larger stripe unit size better?

This server will be a subscriber to a replicated database. Its primary task is going to be reporting and data retrieval, with only the replication agent making writes. The size of the database is around 90 GB.

I am going to rebuild one IBM 3400 server from scratch. This server is dedicated to a SQL Server 2008 instance running on Windows 2008 R2.

I am going to make new RAID configuration. I have 6 SCSI 73 GB drives inside the machine and an IBM ServerRAID 8K controler. What would be a good way to set the RAID levels? Should I have two, three or one field on my controler?

I am considering to make one of following solutions:

  1. Use all the disk and make a RAID 10 pool.
  2. Use 4 disks for a RAID 1 pool and use it to store the database data and OS, and use the other 2 disks in a RAID 0 pool and use that to store the database logs.
  3. Some other combination.

Is a larger stripe unit size better?

This server will be a subscriber to a replicated database. Its primary task is going to be reporting and data retrieval, with only the replication agent making writes. The size of the database is around 90 GB.

I am going to rebuild one IBM 3400 server from scratch. This server is dedicated to a SQL Server 2008 instance running on Windows 2008 R2.

I am going to make new RAID configuration. I have 6 SCSI 73 GB drives inside the machine and an IBM ServerRAID 8K controler. What would be a good way to set the RAID levels? Should I have two, three or one field on my controler?

I am considering to make one of following solutions:

  1. Use all the disk and make a RAID 10 pool.
  2. Use 4 disks for a RAID 1e pool and use it to store the database data and OS, and use the other 2 disks in a RAID 0 pool and use that to store the database logs.
  3. Some other combination.

Is a larger stripe unit size better?

This server will be a subscriber to a replicated database. Its primary task is going to be reporting and data retrieval, with only the replication agent making writes. The size of the database is around 90 GB.

grammar, formatting, and flow fixes
Source Link
Nick Chammas
  • 14.8k
  • 17
  • 76
  • 123

Help Me to choice Raidme choose a RAID level combination for MSSQL2008a SQL Server 2008 instance

I am going to rebuild one IBM 3400 server from zeroscratch.
This This server is dedicated for SQL2008 sql server and underto a SQL Server 2008 instance running on Windows 2008 R2 OS. I

I am going to make new RAID configuration.
I I have 6 SCSI 73 GB discdrives inside serverthe machine and an IBM ServerRAID 8K controler.
What will What would be a good way to set RADIthe RAID levels.
Should? Should I have two, three or one field on my controler. I?

I am considering to make one of following solutions:

  1. Use all the disk and make a RAID 10 fieldpool.
  2. Use 4 disks for a RAID 1e1 pool and hold there SqlDatause it to store the database data and OS, and use the other 2 2 disks for Raidin a RAID 0 pool and hold there SQL Loguse that to store the database logs.
  3. AnySome other combination ?.

I am also confused with Stripe-unitIs a larger stripe unit size perhaps it is better to be bigger ?
This

This server will be a subscriber of oneto a replicated database and. Its primary task for him is going to be reporting and data retrieval, while Writingwith only doing Replicationthe replication agent making writes. Size The size of the database data file is around 90 GB.

Help Me to choice Raid level combination for MSSQL2008 Server

I am going to rebuild one IBM 3400 server from zero.
This server is dedicated for SQL2008 sql server and under 2008 R2 OS. I am going to make new RAID configuration.
I have 6 SCSI 73 GB disc inside server and IBM ServerRAID 8K controler.
What will be good way to set RADI levels.
Should I have two, three or one field on my controler. I am considering to make one of following solutions:

  1. Use all disk and make RAID 10 field.
  2. Use 4 disks for RAID 1e and hold there SqlData and OS and use other 2 disks for Raid 0 and hold there SQL Log
  3. Any other combination ?

I am also confused with Stripe-unit size perhaps it is better to be bigger ?
This server will be subscriber of one replicated database and primary task for him is going to be reporting and data retrieval, while Writing only doing Replication agent. Size of database data file is around 90 GB.

Help me choose a RAID level combination for a SQL Server 2008 instance

I am going to rebuild one IBM 3400 server from scratch. This server is dedicated to a SQL Server 2008 instance running on Windows 2008 R2.

I am going to make new RAID configuration. I have 6 SCSI 73 GB drives inside the machine and an IBM ServerRAID 8K controler. What would be a good way to set the RAID levels? Should I have two, three or one field on my controler?

I am considering to make one of following solutions:

  1. Use all the disk and make a RAID 10 pool.
  2. Use 4 disks for a RAID 1 pool and use it to store the database data and OS, and use the other 2 disks in a RAID 0 pool and use that to store the database logs.
  3. Some other combination.

Is a larger stripe unit size better?

This server will be a subscriber to a replicated database. Its primary task is going to be reporting and data retrieval, with only the replication agent making writes. The size of the database is around 90 GB.

Source Link
adopilot
  • 2.4k
  • 8
  • 31
  • 46

Help Me to choice Raid level combination for MSSQL2008 Server

I am going to rebuild one IBM 3400 server from zero.
This server is dedicated for SQL2008 sql server and under 2008 R2 OS. I am going to make new RAID configuration.
I have 6 SCSI 73 GB disc inside server and IBM ServerRAID 8K controler.
What will be good way to set RADI levels.
Should I have two, three or one field on my controler. I am considering to make one of following solutions:

  1. Use all disk and make RAID 10 field.
  2. Use 4 disks for RAID 1e and hold there SqlData and OS and use other 2 disks for Raid 0 and hold there SQL Log
  3. Any other combination ?

I am also confused with Stripe-unit size perhaps it is better to be bigger ?
This server will be subscriber of one replicated database and primary task for him is going to be reporting and data retrieval, while Writing only doing Replication agent. Size of database data file is around 90 GB.