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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2014-05-05 : 15:31:01
|
| 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
38200 Posts |
Posted - 2014-05-06 : 15:33:50
|
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2014-05-20 : 17:57:09
|
| 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. |
|
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2014-05-26 : 18:29:31
|
| 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. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-05-27 : 01:51:36
|
| 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 disksJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Best server files placement