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 |
|
sureshot
Yak Posting Veteran
72 Posts |
 Posted - 2007-04-12 : 19:24:16
|
| I still have transactions in use mainly to set isolation levels. There are obviously no update/delete statements in them. I'm pretty sure this will still add rows to the transaction log even though there won't be any writes to the db data files. Is it still a critical best practice to use RAID 1/0 instead of RAID 5 for the logs? Looking to re-use some existing storage rather than buy new ones. Thoughts? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-04-12 : 22:17:45
|
| if db is read only, i cant think of any difference between various isolation levels.also, as long as have good backup, i'll put read only db on raid 5 |
 |
|
|
|
|
|
Read-Only Database Transaction Log