Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Samples and Examples
  4. Part 3: Tools and Utilities
  5. Part 4: SDK Resources

Microsoft SQL Server Configuration Parameters

Microsoft SQL Server Configuration Parameters

To run the database performance test, prepare the Microsoft SQL Server database environment to be similar to the Informatica benchmark environment. You can compare the database performance test results with the benchmark environment only if the configuration of the two database environments are similar.
The Informatica benchmark environment uses the following Microsoft SQL Server database properties configuration:
Property
Description
AUTO_UPDATE_STATISTICS_ASYNC
Specifies whether or not to enforce statistics update in asynchronous mode. The Informatica benchmark environment was set to
ON
. Default is
OFF
.
PARAMETERIZATION
Specifies whether or not all SQL statements in the database must be parameterized. The Informatica benchmark environment was set to
FORCED
. Default is
SIMPLE
.
READ_COMMITTED_SNAPSHOT
Specifies whether or not to allow other sessions to see data that is not yet a committed transaction. The Informatica benchmark environment was set to
ON
. Default is
OFF
.

0 COMMENTS

We’d like to hear from you!