This documentation supports the 18.08 version of Remedy Deployment.

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

Remedy Deployment 18.08 ... Performance tuning and benchmarks Performance benchmarking for Remedy BMC Remedy ITSM Suite 18.08 Solution Performance Benchmarks Software component configuration settings 18.08.00

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
Last modified by Himanshu Raul on Dec 10, 2019
contributor_unapproved

Comments

BMC Remedy Smart Reporting 18.08 performance benchmark configuration settings
Preparing
© Copyright 1991-2018 BMC Software, Inc. © Copyright 1991-2018 BladeLogic, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2020 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.