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

db server drive config for web app Expand / Collapse
Author
Message
Posted Thursday, October 16, 2008 7:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 29, 2010 2:12 PM
Points: 2, Visits: 16
I've read a lot of the posts and it has been most helpful but the database server drive recommendations seem to be situation specific.

My situation:

Dell PE 2900 16gb RAM, 1 quad core 2.5ghz cpu (for now), 8 + 2 drive bays, Sql Server 2005 Standard

- how many users? 25 concurrent users
- how big are the databases? 2 databases , 1 - 60gb, 1 - 600gb
- oltp or dss? 90% oltp, 10% dss
- how much read versus write activity? 66% read, 33% write
- when running reports/batch jobs how much data would be read? largest table (Account Master) is 4.6gb and it is hit in every job/report
- if you know then what sort of IO rate do you need for your apps? Don't know. What I can say is that the oltp users are on the other side of a VPN tunnel over 10mb Internet connection and that is where I need to focus my performance.

I need to fill up the 10 drive bays with some RAID configuration/s of: OS & Binaries, Data, TLogs, Tempdb?

I have two Drive Choices for the 10 bays (max out while I have the budget): 450gb 15K SAS, 1tb 7.2K Nearline SAS

I considered the 1tb 7.2k Nearline SAS due to $ savings and increased capacity but am waffling due to possible performance decrease?

What would be your suggestions?

Much Thanks, Briang
Post #586930
Posted Thursday, October 16, 2008 8:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 29, 2010 2:12 PM
Points: 2, Visits: 16
I posted question in three forums due to time constaints. I am updateing this post with a reply from other forum. Hope Mr. Harvey does not mind. Thanks Mr.Harvey.
-----------------------------------------------------------------
I hope you will be running the 64-bit version of SQL Server.

With 10 drive bays I might go for one mirrored pair for the OS and
paging, the C: drive in other words; a second mirrored pair for
database log files, and the other six drives in a RAID 10 set.
Allocating dollars, the log drives would be the first place to use the
high performance drives. If you also used them for the data in the
six drive RAID 10 set that would only give you 1.35GB. Since you are
already at 660 GB of data I would sat that is marginal and would
probably go for the slower, higher capacity drives for the data.
However I would make certain to get six; you would have enough space
with fewer, but extra spindles means more performance. I would go
with whatever is cheaper for the C: drive. The log and data for
tempdb would be split the same way log and data are for the other
databases.

Roy Harvey
Beacon Falls, CT
Post #587037
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse