I appeciate that you may have performed such tests previously - but as hardware and software evolve its often worth repeating such tests (goes away to do the suggested one tonight).
Note that I am not trying to argue away the issue about write caching - it *has* to increase the risk of database corruption following a power failure, however if your backups are regular and reliable this may be a risk worth taking to achieve acceptable performance at a low price.
regards
Mark
scott.marlowe wrote:
Assuming that the caching was on, I'm betting your database won't survive a power plug pull in the middle of transactions like the test I put up above.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
