This documentation supports the 18.08 version of Remedy Deployment.

To view the latest version, select the version from the Product version menu.

Microsoft SQL Server database configuration 18.08

This topic was edited by a BMC Contributor and has not been approved.  More information.

The following table describes the Microsoft SQL Server database-configuration settings used during the performance benchmark testing.

Note

The database system was shared with many other active databases.


Below configurations are set in Database Properties -> Options

SQL Server settingValue

ALLOW_SNAPSHOT_ISOLATION

OFF

READ_COMMITTED_SNAPSHOT

ON

PARAMETRIZATION

SIMPLE


Below configurations are set in Server Properties -> Advanced

SQL Server settingValue

Cost Threshold for Parallelism

50

Max Degree of Parallelism

8

Was this page helpful? Yes No Submitting... Thank you

Comments