Performance Tuning Guide

Back Next

Recommendations for Microsoft SQL Server

You can configure parameters related to the Microsoft SQL Server to optimize the performance of the MDM Hub.

The following table lists the recommendations related to the Microsoft SQL Server environment:

Database Parameters	Recommended Setting	Description
AUTO_UPDATE_STATISTICS_ASYNC	ON	To enforce statistics update in asynchronous mode.
PARAMETERIZATION	FORCED	To parameterize SQL statements. Parameterized statements reduce the frequency of query compilations and recompilations to improve performance.
READ_COMMITTED_SNAPSHOT	ON	To allow other sessions to see data that is not yet a committed transaction.