When using MS-SQL what commit-mode is recommended?

Products

• CA Workload Automation DE

Issue/Introduction

What commit mode is best suited for SQL DB used by dSeries?

Should it be Synchronous or Asynchronous?

Environment

OS: Any

Database: MS-SQL

Resolution

The SQL database supports Synchronous and Asynchronous commit modes.   The Asynchronous is mainly used in cluster and Always-On setup.  The database will not wait for transaction confirmation.  The synchronous mode is used more performance intensive though it emphasizes on high availability.  

Broadcom has no specific recommendation on which mode to be used.  Please consult your DBA and/or Microsoft to determine the requirements.

Additional Information

See Microsoft documentation for more details.