SQL Perfmon Integration (Windows only)

Summary information

Default value

1 (on)

Valid values

0 (off), 1 (on)

Status

Static

Display level

Intermediate

Required role

System administrator

Configuration group

SQL Server Administration

SQL Perfmon Integration enables and disables the ability to monitor Adaptive Server statistics from the Windows Performance Monitor.

Adaptive Server must be registered as a Windows Service to support monitor integration. This occurs automatically when you start Adaptive Server using the Services Manager in the Sybase for the Windows program group, and is the default configuration when you use the Sybase installer or the syconfig utility to create an Adaptive Server.

The 15.7 version of sybperf exposes a set of Adaptive Server counters that are more useful for monitoring Adaptive Server performance.