PostgreSQL has the option to turn off fsync and synchronous commits (http://www.postgresql.org/docs/9.1/static/runtime-config-wal.html). Does SQL Server has this option somewhere?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from serverfault.com Jun 27 '13 at 5:13
This question came from our site for system and network administrators.
No, Sql server doesn't let you turn off synchronous writes to the log file. If you were able to do so, then you would lose ACID compliance.
If this is a "make it go as fast as possible" scenario, then a better approach is to analyze wait statistics to identify what the bottleneck actually is. Risking data corruption is never a good idea.