SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 .ldf and .mdf files of DB on save drive
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ilimax
Posting Yak Master

Bosnia and Herzegovina
164 Posts

Posted - 05/07/2013 :  14:17:10  Show Profile  Reply with Quote
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

USA
1974 Posts

Posted - 05/07/2013 :  16:09:34  Show Profile  Visit chadmat's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
1908 Posts

Posted - 05/08/2013 :  12:15:23  Show Profile  Visit jackv's Homepage  Reply with Quote
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

USA
768 Posts

Posted - 05/08/2013 :  13:59:23  Show Profile  Reply with Quote
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 - 05/10/2013 :  03:35:26  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
1908 Posts

Posted - 05/10/2013 :  13:38:47  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000