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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-14 : 08:33:04
|
| Phil writes "Is there an optimal way to setup your server partitions before installing SQL Server 2000? Also, is it best to install all components on one partition or spread it out?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-14 : 09:47:20
|
| If the partitions are on the same physical drive, there's not much benefit in putting the SQL Server files on separate partitions. In fact it can hamper I/O performance because it can cause excessive head movement.If you have multiple drives, you can place data files on one drive and the log file(s) on another and allow parallel read/write operations. The same applies to the system files. Look in Books Online under "filegroups", there is a wealth of information on how to arrange files on multiple drives to get the best performance. |
 |
|
|
|
|
|
Server Setup Pre-Installation