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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 .ldf and .mdf files of DB on save drive

Author  Topic 

ilimax
Posting Yak Master

164 Posts

Posted - 2013-05-07 : 14:17:10
How bad would be to have .mdf and .ldf files of one db on save drive in clustered environment?
Is this going to make slower server when do re-indexing in this DB?

chadmat
The Chadinator

1974 Posts

Posted - 2013-05-07 : 16:09:34
Clustered has no bearing. It is recommended to split data and log files onto different drives. Whether you will see a noticeable difference in performance is impossible to answer without knowing a lot more about your environment.

-Chad
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-05-08 : 12:15:23
To maximise the splitting the drives - i.e data and logs - needs to to be underpinned by the drives being two separate IO channels , such as separate adapters , separate disks etc

Other options include splitting the data file into different filegroups , across different drives - this depends on workload, data , and query types

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2013-05-08 : 13:59:23
It also depends a lot on the SAN you are using and how it is configured, and how the paths are setup in the HBA's, how many HBA's you have, how much cache the SAN has and a whole lot of other considerations.
Go to Top of Page

srimami
Posting Yak Master

160 Posts

Posted - 2013-05-10 : 03:35:26
To put it simple, not a good practice to have .mdf and .ldf files on the same drive. And Yes, it will slower the performance while re-indexing.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-05-10 : 13:38:47
It also worth highlighting , there are perfomance gains related to separating the TempDB on its own dedicated drive - due to large amount of spillover activity in TempDB

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -