3
votes
3answers
2k views

adding additional disks to existing RAID 5

I have been handed the challenge of adding 4 additional drives to an IBM ThinkServer with a RAID 5 array on an MS Windows Server 2008 Std. living life as a SQL server. First question is "is it even ...
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 ...
2
votes
2answers
327 views

Need help with MS SQL SAN disk array provisioning

We have a HP MSA70 with 20x300gb 2,5" 10k disks allocated for our SQL2008 server. Our usage of the SQL server is: 50 concurrent users of our ERP system(Visma business) - 70/30 read/write. 2500 ...
0
votes
1answer
364 views

Advantages of multiple SQL Server files with a single RAID array

Originally posted on stack overflow, but re-worded. Imagine the scenario : For a database I have RAID arrays R: (MDF) T: (transaction log) and of course shared transparent usage of X: (tempDB). I've ...
0
votes
1answer
326 views

Does multiple files in SQL Server when using RAID help reduce conflicts in growth and file-locking?

I've been reading around and get the impression that if you are using RAID then using multiple SQL Server files within a filegroup won't yeild any more improvements, and the benefits are purely ...
0
votes
3answers
227 views

Which Raid to store SQL backup files?

Following is my current SQL Server raid configuration: Raid1 with log files ~ 500GB Raid10 with data files ~ 1TB I would like to keep 3 day worth of daily full backup and hourly transaction log ...
0
votes
1answer
546 views

Raid Caching configuration suggestions

I'm wondering if there's the optimal Cache setting for the following Raid controllers and raid setups. (OS: windows 2008 R2, App: II7, DB: SQL Server 2008 R2 Enterprise) PERC 6/i: (The default ...
6
votes
5answers
2k views

What is the best way to configure 6 disk raid for SQL Server + OS?

I'm setting up a SQL Server on Win 2k8 with following hardware: 6 x WD RE3 500G SATA PERC H700 I've read some suggested that putting log file and OS on its own RAID1 while the rest of data is on ...
1
vote
2answers
168 views

SQL server availability issue: large query stops other connections from connecting

I've got a high-spec (multicore, RAID) server running MS SQL 2008, with several databases on it. I have a low throughput process that periodically needs a small amount of information from one of the ...
3
votes
6answers
3k views

1 logical drive vs 2 logical drivers on 1 raid controller to separate data from log files?

I'm configuring a new server: it has 1 raid controller with 8x 146 Gb disks. The system is currently configured in Raid 1+0 but has only 1 logical drive, which is not that optimal as data and ...
1
vote
6answers
1k views

Using two filegroups on one RAID 10

If a Microsoft SQL Server 2008 Standard Edition server is configured as below, does option 1 provide an advantage over option 2? Base configuration: 32GB RAM 2 x Xeon 7460 (6 core) Windows Server ...