Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andyjaar
Starting Member
8 Posts |
 Posted - 2005-02-07 : 10:06:01
|
| Hi,We have just got some new servers and will be installing SQL Server 2000. We will be starting off by migrating 2 databases (around 1GB in size each, but likely to increase after migration). I have a few questions about how we should partition the hard drive and would appreciate any advice:(1) Would it help to put the program files on one partitionand the database files on another?(2) Going further, would it help performance to set up each database on a different hard disk partition?(3) Going even further, would it help to seperate the data and log files onto different partitions?We want to ensure the new systems are best set up to allow for an expected increase in traffic.Thanks for any help.Andy Hall. |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-02-07 : 12:54:28
|
| Generally, you want to install SQL server to one array (RAID 1) where the OS is, then you want another array (RAID 1) to store your transaction logs (LDF), and then you want a third array (RAID 5 usually) to store your data (MDF).With that being said, have you determined that you have disk bottlenecks? This setup will help you avoid such bottlenecks, but there's no reason do to this unless you have issues. With databases that are as small as yours, adding RAM to the machine would probably be a more cost effective upgrade.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
andyjaar
Starting Member
8 Posts |
Posted - 2005-02-08 : 03:58:00
|
| We have got completely new servers, which includes a CPU + RAM upgrade. The database is currently performing without many problems, but we expect a 3x or 4x in traffic to the web server so we are just trying to make sure we have the best set up in place to avoid possible future bottlenecks.We only have 2 raid arrays on the new server - would it be best to put program files + OS on the first and then data+logs on the second? Or would a different combination be more suitable?We have daily backups and truncations of our log files.Thanks for your help |
|
|
|
|
|
|
|
|
Partitioning for SQL Server 2000 install