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 |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-06-09 : 03:44:17
|
| I have created a database(40GB)with the data and log files in the following hard disk drives...D:\dat1.mdfD:\log1.ldff:\dat2.mdff:\log2.ldfg:\dat3.mdff:\log3.ldfwill there be any performance boost up if i change the file storage as follows...d:\dat1.mdfd:\dat2.mdfd:\dat3.mdff:\log1.ldff:\log2.ldff:\log3.ldfIf yes, how can i accomplish this..Thanks |
|
|
kjmraohyd
Starting Member
34 Posts |
Posted - 2006-06-09 : 04:41:51
|
| It all depends on the kind of RAID implementation and also on your application. Keeping data and log files on different array of drives will definately gives you performance.Jaganmohan Rao |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-06-09 : 05:19:01
|
| At the very minimum, keep the data and log in diff drives, and if you do have more physical drive, seperating the data file into diff drives is not a bad idea. might can seperate the index and the actual data if you really want to get down to speed. |
|
|
|
sreehari
Starting Member
37 Posts |
Posted - 2006-06-09 : 05:41:51
|
How can i move the data and log files..do i requre t detach the database first...?quote:
Originally posted by Westley
At the very minimum, keep the data and log in diff drives, and if you do have more physical drive, seperating the data file into diff drives is not a bad idea. might can seperate the index and the actual data if you really want to get down to speed.
|
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-06-09 : 06:17:53
|
| That would be the "fastest way" if you can allow downtime (depend on how big those log files are), or you can create another Log file on the other drive, and empty the old ones? same goes to data, but this is very slow (if the size is big), and I hardly try it, so all input are welcome.make sure you do a backup before you start anything :) |
|
|
|
|
|
|
|
|
Distribution of data and log files...