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 |
|
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 |
 |
|
|
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 etcOther options include splitting the data file into different filegroups , across different drives - this depends on workload, data , and query typesJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
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. |
|
|
|
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. |
|
|
|
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 TempDBJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
.ldf and .mdf files of DB on save drive