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 |
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
 Posted - 2007-10-30 : 02:57:23
|
| I understand the log files (LDF ) and data files (mdf ) should be on a different drives . I believe it leads to greater availabilty and speed . Are there any other reasons for to keep this on a separate drive.Also what considerations I should take care while creating a database of around 100 GB . (use of filegroups , growth % etc ). Is there any connection of number of users to number of disks SQL data file to be spread to . Also do I need to take care (through hardware / software for a Quad core CPU ) to take full advanage of Quad core CPU. |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-30 : 10:04:39
|
quote:
Originally posted by Hitesh Shah
I understand the log files (LDF ) and data files (mdf ) should be on a different drives . I believe it leads to greater availabilty and speed . Are there any other reasons for to keep this on a separate drive.Also what considerations I should take care while creating a database of around 100 GB . (use of filegroups , growth % etc ). Is there any connection of number of users to number of disks SQL data file to be spread to . Also do I need to take care (through hardware / software for a Quad core CPU ) to take full advanage of Quad core CPU.
What other reasons do you need?  Other considerations would include making sure backups are on a separate drive also and perhaps TempDB. Plus, what are your RAID configurations on these drives? And, how much RAM do you have available?
Future guru in the making. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-30 : 23:01:49
|
| Sql will use all processors by default, don't change that. |
|
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2007-10-31 : 06:06:19
|
| Hi , Thanks for ur replies . I c following in doc from MS . 1.For small servers with less than three disks performing mostly sequential I/O, or servers with approximately eight disks performing random I/O, PCI is sufficient. However, PCI-X is recommended and can service a wider range of servers with varying workload size.2.For large bandwidth demands on the I/O bus, use a different bus for the transaction log files.3.The number of data files within a single filegroup should equal to the number of CPU cores.Do we need to do anything specially for these .We'll be having 8 GB RAM with 45GB cache .We plan to have RAID 1 configuration each for 1. Application (73GB) 2. LDF log files (73GB)3. MDF data files (volume of more than 2 or more disks ) (300GB)4. Analysis services (for which there will be separate cluster (73 GB) Is there anything special to segregate analyses services data files on separate drive. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-31 : 22:55:23
|
| Use raid5 or raid10 for mdf files, put tempdb on its own array if possible. |
|
|
|
|
|
|
|
|
disk organization