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, 8x2.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 ASP.net in separate server
yes, i am using 64 bit os and sql server. No chance of having 2 servers however - asp.net 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....
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)