New server setup question – disks | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

New server setup question – disks

Hello everyone!!
I am not a DBA but have a bit of experience with administering SQL Server 2005 and now need to decide on hardware for a new server.
QUESTION:I would like to ask for your opinion on the disk setup I am proposing…
2U dell server, dual quad core, 32GB RAM, 8×2.5" sas 15Krpm 73GB disks.
Volume 1: RAID 1, 2 disks. OS & TempDB (73gb)
Volume 2: RAID 10, 4 disks. Datafiles (146gb)
Volume 3: RAID 1, 2 disks. TransacitonLogs (37gb)
sql server will contain 5 databases, ~5-10GB each. Doing a lot of writes and reads (OLTP). The server is also an ASP.NET application server
Besided asking for general comments on this, I wonder if I should put TempDB on Volume 1 or Volume 2? I suspect Volume 2 is a better option..
Thank you all in advance!!

It is better for tempdb a separate disk as you did
use 64 bit O.S
if you can , let SQL server in dedicated server , and in separate server

yes, i am using 64 bit os and sql server. No chance of having 2 servers however – and sql must be on the same machine for now.
I am concerned about putting TEMPDB on volume 1 since this is raid 1 and I heard that TEMPDB should ideally be on raid 0 or 10….

RAID 1 for tempdb is a new one on me. I would be curious as to the rationale.

well, most articles suggest wither RAID 10 OR RAID 0 for tempdb.
I don’t have a raid 0 volume available so my choice is:
(a) put temp db on RAID 10 volume, but this would put it on the same volume/spindles as datafiles for databases
(b) put temp db on one of my RAID 1 volumes (either the OS volumne, or transaction logs volume)

i suggest (a)


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |