Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Server Configurations - SQL 2008 R2 Expand / Collapse
Author
Message
Posted Monday, May 20, 2013 3:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:17 AM
Points: 172, Visits: 408
Hi All,
I am in the process of putting together a proposal to upgrade our Production Server and wanted to ask a couple of questions of the experts on this site.

Basic Specification is ;

Windows Server 2008 OS
SQL 2008 R2 - Single Default Instance
ERP System with 6 Databases of around 6 gig each ( 36 gig total ... this is 4 years of data )

Daily / Hourly tasks running

Full Backup @ 2am
T-Log backup every 2 hours from 6am - 10pm


Processor - is a given that it will be high spec

Memory - 16gb or 32gb

I am looking at the following for storage;

PARTITION 1 - RAID 1 - OS ( 2 Drives 300gb each ) or 500gb depends at time of purchase

PARTITION 2 - RAID 1 - SQL Databases and Indexes ( 2 Drives 1 tB each )

PARTITION 3 - RAID 1 - SQL Logfiles ( 2 Drives 1 tB each )

PARTITION 4 - RAID 1 - TempDB ( 2 Drives 1 tB each )

PARTITION 5 - RAID 5 - Backups and software storage/updates ( 3 Drives 1 tB each )


Thoughts and suggestions on configuration please











________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1454462
Posted Monday, May 20, 2013 4:34 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:28 AM
Points: 42,468, Visits: 35,538
That's a very low number of drives for each RAID array. Low usage DB I presume, since they are pretty small...




Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1454475
Posted Monday, May 20, 2013 7:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:17 AM
Points: 172, Visits: 408
Hi Gail,
Thats why I am asking for suggestions - the book said to set up the Raid 1 and Raid 5 for Backups - but not about sizing or number of drives.

The space is correctly identified - so could have 4 500gb drives on Raid 1 possibly ?!

Thanks
Steve


________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1454515
Posted Monday, May 20, 2013 7:22 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:28 AM
Points: 42,468, Visits: 35,538
I hope the book didn't say RAID 0, because that's something you never want to use for a database.

IO throughput is a function of the number of spindles you have in an array, the more spindles, the higher the data transfer rate.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1454524
Posted Monday, May 20, 2013 7:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:17 AM
Points: 172, Visits: 408
definetly not RAID 0

________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1454534
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse