Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


db server drive config for web app


db server drive config for web app

Author
Message
b groves
b groves
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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
b groves
b groves
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search