2
votes
1answer
52 views

Consolidating SQL Server

We have a number of SQL Server 2008 R2 standard servers, each for a single application that we'd like to consolidate into one physical server. Running perfmon on these servers they're not using a ...
0
votes
2answers
172 views

Will a raid 10 help my db server in terms of trans/sec?

I've been reading about 10k drives being able to run 166 transactions per second vs 250/sec on 15k drives, which in both cases is just the number of rotations per second. What does this really mean ...
0
votes
3answers
661 views

Optimal setup of files, filegroups and RAID types for a large Microsoft SQL Server Database

First - while I'd totally be down for advice; I'm also interested if there are any good ways of measuring/collecting data in advance that I could use to determine which 'rules of thumb' to follow and ...
1
vote
4answers
253 views

Why database partitioning didn't work? Extract from thedailywtf.com

Original link. http://thedailywtf.com/Articles/The-Certified-DBA.aspx. Article summary: The DBA suggests an approach involving rigorous partitioning, 10 partitions per disk (3 actual disks and 3 ...
2
votes
3answers
4k views

Which is faster? 4x10k SAS Drives in RAID 10 or 3x15k SAS Drives in RAID 5?

I am reviewing quote for a server upgrade. (RHEL). The server will have both Apache and MySQL on it, but the reason for upgrade is to increase DB performance. CPU has been upgraded massively, but I ...