Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

migrated from serverfault.com Jun 27 '13 at 5:13

This question came from our site for professional system and network administrators.

add comment

1 Answer 1

up vote 2 down vote accepted

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.