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 |
|
jedimike
Starting Member
2 Posts |
 Posted - 2010-04-09 : 12:48:20
|
| I have four sets of disks,Raid 1 - osRaid 1 - logsRaid 1 - tempdbRaid 10 - dataThe controller layouts are controller 1 - OS & ?controller 2 - data & ?Which controllers do I put the tempdbs and logs on? Please help |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-09 : 12:56:35
|
| If you put the logs on Controller 1 and tempdb on controller 2, it would probably spread the load a little better.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
 |
|
|
jedimike
Starting Member
2 Posts |
Posted - 2010-04-09 : 14:09:23
|
| Which does more work logs or tempdb? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-10 : 03:06:24
|
| Does it make sense to have Logs and Data on separate controllers as a safeguard against data loss in the case of controller failure? |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-10 : 08:58:47
|
quote:
Originally posted by jedimike
Which does more work logs or tempdb?
That's probably something you need to tell us. :)Seriously, it depends on your situation. The logs are used every time a change is made to the database. The tempDB is used when you use temp tables. It depends on which happens more. I'd say for most OLTP systems, the logs will be used far more often than the tempDB. For a reporting data warehouse, where updates to the data happen infrequently but many queries make use of the tempDB, it'll be the other way round.quote:
Originally posted by Kristen
Does it make sense to have Logs and Data on separate controllers as a safeguard against data loss in the case of controller failure?
That sounds like a pretty good point. A failure on either controller will at least leave you with an up to date copy of your data.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-10 : 10:19:45
|
| If the worst happens:Logs Controller has failed. Can you actually backup the DATA?Data controller has failed. Can you take a final/tail TLog backup?Is it actually possible to do these things with the other "half" of the database inaccessible?Because if not then its a moot point! |
|
|
|
|
|
|
RAID Layout with two controllers... help