January 9, 2008 at 1:07 am
Hi all,
wherever we create a database is it necessary to keep .ldf & .mdf file on different drive ?
Can anyone explain me..
Regards
Majid Jafar
January 9, 2008 at 1:39 am
mjafar (1/9/2008)
Hi all,wherever we create a database is it necessary to keep .ldf & .mdf file on different drive ?
Can anyone explain me..
Regards
Majid Jafar
These files can stay on the same drive. The ldf contains the log file, the mdf contains the data of your database. Every data modification will result in an entry in the ldf file, and eventually the modifications will also be applied to the mdf file. Since eventually both files are written, storing them on different drives (assuming the drives belong to different disks as well) could solve some disk bottlenecks. Other reasons may contain space management. It is easier to see how much space all your log files use? ...
Regards,
Andras
January 9, 2008 at 2:27 am
Actually a huge amount of data is updating on my database.
At same time user access the data.
Is it causes the performance issue because my ldf & mdf is on same drive..?
I mean read-write is happening twice on same drive.
Plz reply
Regards
Majid
January 9, 2008 at 2:31 am
Andras nailed it.
For databases that are small in terms of transactions, no it's not really that important if they are on the same drive.
Regardless, I like to adopt the seperate drive solution for data, logs and also tempdb. Even though I made the point above that small or low transactional databases do not really benefit, but for continuity and ease of management, I split those out too.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply