Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Best server files placement
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Aged Yak Warrior

808 Posts

Posted - 05/05/2014 :  15:31:01  Show Profile  Reply with Quote

I have this almost production ready sql 2012 built by consultant.

It has mdf(1gb), ldf(5gb) and temdb(8mg) all sitting on C drive.

That box also has D (SSD 100 GB free) and E 750 GB of 1 TB free.

My plan is to let the OS has the C.

move tempdb to E, and mdb+ldb to D.

Is that a good plan?


Almighty SQL Goddess

38200 Posts

Posted - 05/06/2014 :  15:33:50  Show Profile  Visit tkizer's Homepage  Reply with Quote
How are C, D and E configured? Are they separate disks? Or just partitions? It's important to understand your load to determine which files are more heavily used than others.

Tara Kizer
SQL Server MVP since 2007
Go to Top of Page

Constraint Violating Yak Guru

352 Posts

Posted - 05/20/2014 :  17:57:09  Show Profile  Reply with Quote
I'd put both the mdf and tempdb on the SSD. It is usually recommended to put those on different drives but with SSD I believe that is less of a concern. Since ldf is sequential writes a spinning disk can handle that fine so E drive.
Go to Top of Page

Constraint Violating Yak Guru

352 Posts

Posted - 05/26/2014 :  18:29:31  Show Profile  Reply with Quote
I was just running some performance tests on my system and actually found performance to be better with the LDF on a HDD than a SSD by about 30%. A traditional HDD is the way to go for truly sequential writes.
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 05/27/2014 :  01:51:36  Show Profile  Visit jackv's Homepage  Reply with Quote
Are any of your disks mirrored ? This could be a factor where you place your files. For example, if you place files on SSD and it isn't mirrored, than in a DR situation , you may lose the data , if failovr is required.
In that situation ,place permanent data on mirrored disks

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next 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.03 seconds. Powered By: Snitz Forums 2000