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 2012 Forums
 SQL Server Administration (2012)
 Best server files placement
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Hommer
Aged Yak Warrior

794 Posts

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

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?

Thanks!




tkizer
Almighty SQL Goddess

USA
37471 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
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

ferrethouse
Constraint Violating Yak Guru

343 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

ferrethouse
Constraint Violating Yak Guru

343 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

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2079 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
--------------------
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