2
votes
3answers
124 views

Server RAID and Partition Config for Small SQL Environment

I've got 5 databases that run on separate servers using SQL Express. Some of these include a Citrix Datastore, Citrix Edgesite Server, an AV db, Time and Billing App, and a document management ...
2
votes
1answer
422 views

many partitions on a single filegroup?¿ does it make sense?

I'm designing a datawarehouse solution and I'm a newbie in disk configuration issues, let me explain you. Our storage is spread over 6 storage enlosures having each of them 5 raid-1 disk arrays, and ...
0
votes
1answer
267 views

Strategy for SQL Server Partitioning

I have the following requirement: We store daily order details for 10 companies for the past year. Date              Company ...
4
votes
3answers
5k views

New Windows 2008 Disk Partitioning Offset question - should I worry about it?

We're about to hardware upgrade our exisiting Sql 2008 Server. So, I'm checking out some best practices with regards to hardware, like .. RAID levels for the HD and making sure the TempDB is on a ...
12
votes
4answers
14k views

Recommended disk/partition setup for a SQL Server

I'm looking for some advice regarding the best way to set up my disks/partitions for SQL Server. Here are some of my major concerns: How should the SQL files be seperated (data files, logs, temp)? ...