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 |
|
jane2000
Starting Member
3 Posts |
 Posted - 2008-10-04 : 14:30:25
|
| MSPress book suggests 1) To avoid disk contention, do not put data files on the same drive that contains the OS. 2) Put transaction log files on a separate drive from data files to reduce disk contention. 3) Put the tempdb database on a separate drive if possible to get better performance.Many practices in the book also requires 3 volumes-- D, E, and F.So can I just purchase a second hard drive disk, partition it into 3 or 4 parts with Acronis Disk Director, then put the data files into the separate partition named as drive D, E, F, for example? Will it meet the MSPress book's requirement?Thank you very much. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-06 : 01:52:07
|
| No, because the target is to split many I/O-operations to many diskdrives with there own write-read heads. In your case there is ONE diskdrive with no extra write-read heads.GreetingsWebfredPlanning replaces chance by mistake |
 |
|
|
jane2000
Starting Member
3 Posts |
Posted - 2008-10-07 : 23:15:55
|
Thank you so much for your help. So in order to study for the MS SQL Server 2005 70-431 by myself, Do I need to purchase at least another internal hard drive, one external hard drive, and another Sandisk 8GB Cruzer USB 2.0 Flash Drive to represent the D,E,F volume required from the MSPress book?Any input is greatly appreciated.quote:
Originally posted by webfred
No, because the target is to split many I/O-operations to many diskdrives with there own write-read heads. In your case there is ONE diskdrive with no extra write-read heads.GreetingsWebfredPlanning replaces chance by mistake
|
|
|
|
lepeniotis
Yak Posting Veteran
75 Posts |
Posted - 2008-10-08 : 05:03:13
|
quote:
Originally posted by jane2000
Thank you so much for your help. So in order to study for the MS SQL Server 2005 70-431 by myself, Do I need to purchase at least another internal hard drive, one external hard drive, and another Sandisk 8GB Cruzer USB 2.0 Flash Drive to represent the D,E,F volume required from the MSPress book?Any input is greatly appreciated.quote:
Originally posted by webfred
No, because the target is to split many I/O-operations to many diskdrives with there own write-read heads. In your case there is ONE diskdrive with no extra write-read heads.GreetingsWebfredPlanning replaces chance by mistake
No Not at all!! The best way to study for 70-431 is to buy the Microsoft Self pace training books you can find it as used in a very low price! It's the best option whith tests and the simulations that you need. you can find the entire MCITP database administrator for an extremenly low price. and it has a cd with test simulations and practise examples.MSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
|
|
|
jane2000
Starting Member
3 Posts |
Posted - 2008-10-08 : 12:12:07
|
| Thank you very much for your help.Yes. I already purchased the MS SQL Server 2005 Implementation and Maintenance Self-Paced Training Kit. On page 58 in the book, it requires:1)To avoid disk contention, do not put data files on the same drive that contains the operating system files.2) Put transaction log files on a separate drive from data files to reduce disk contention.3) In environment in which there is intensive use of tempdb databases, you can get better performance by putting tempdb on a separate drive, which lets SQL Server perform tempdb operations in parallel with database operations.In the practice on the next page, p. 59, in the book, it requires that "To run this sample properly, you need three volumes--D,E,and F-with a Sales_Data folder on each of them."So I am wondering in order to have different volume or disk requirement, can I just buy a 500GB second hard drive and make 4 partions and leave 3 partition as drive D, E, F? Or Do I need to purchase a second internal hardrive, an external hard drive, and a Sandisk 8GB Cruzer USB 2.0 Flash Drive to represent the D,E,F?Any input is greatly appreciated. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-10-08 : 14:06:43
|
| Depends on what the sample is. If it is just getting a feel for how to install SQL Server with tempdb on a different drive than the master database, then logical partitions are fine. If you are looking to do a stress test, then you will need more physical drives.One small note: SQL Server technically only supports SCSI drives for production uses. IDE, USB, and I am not sure but I suspect SATA drives are not supported. They work 99 out of 100 times, but they do have a risk of becoming corrupt under a significant load. The interfaces for IDE, USB, and (probably) SATA drives do not support a specific low level method that SQL Server requires for synchronous writing. |
|
|
|
|
|
|
|
|
Put different data files in different partitions?