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 |
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
 Posted - 2010-08-26 : 15:08:39
|
| We are about to install SQL 2008 on a server with two drives, no RAID. The data files are going on the c drive and the log files are going on the d drive. Wouldn't it be better to put the log and data files on one drive and the tempdb on the other? I have 2! CPUsThanks,JimEveryday I learn something that somebody else already knew |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-08-26 : 15:46:21
|
From my admin quote:
Jim,What do you mean? The operating system is on "C", the Log files are on "D" and the DB files are on "E". What do you consider the Primary partition? Thanks
JimEveryday I learn something that somebody else already knew |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-08-26 : 18:34:35
|
| Thanks Tara,This server is going to be a "sandbox". Right now I do all my dev/test/prod in the same place. This server will be a reporting server. It will be updated with some basic info about once a month. The queries are mostly "big", meaning that the typical result set will be 100s of thousands of records and will have 50+ columns. Once stuff is figured out, it gets promoted to production. Backups are nice, but if the server went down for 3 days it wouldn't affect the company at all. There will be 3 databases on, about 50G each, with a typical query needing about 1G. There will only be myself and a handful of others using it. No RAID, not sure about the RAMJimEveryday I learn something that somebody else already knew |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-08-27 : 09:43:43
|
quote:
Jim, I still don't get it….the log files and database files are on two separate hard drives.Thanks
I don't think I understand the difference between a drive and a disk, if there is any. I thought a disk could have several drives. In my understanding, the F: drive would be a partition on the disk?JimEveryday I learn something that somebody else already knew |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
New Server, 2 drives, no raid