Monitoring Adaptive Server Statistics

You can use the Windows Performance Monitor to monitor Adaptive Server statistics. For general information about the Windows Performance Monitor, see your Windows documentation.

Prerequisites
To enable performance monitoring, make sure that the SQL Perfmon Integration configuration parameter is set to 1. If necessary, use sp_configure to reset this parameter. You must restart Adaptive Server for the setting to take effect.
Task
Note: sybperf is not supported only on 64-bit computers.
To support performance monitor integration, Adaptive Server must be registered as a Windows Service. This registration occurs automatically when you:

  • Use the Services option through the Control Panel

  • Have configured Windows to start Adaptive Server as an automatic service

  1. Start the Windows Performance Monitor (perfmon.exe) from its program group.
  2. Select Edit > Add to Chart.
  3. If you are monitoring a local computer, go to step 4. If you are monitoring a remote computer, select it, and click OK.
  4. Select the Adaptive Server Counter group that contains the counter to monitor.
  5. Select the counter you want to monitor.

    For an explanation of a particular counter, select the counter and click Explain.

  6. If selecting a counter displays numbers in the Instance box, select the instance want to monitor.
  7. Click Add to activate the counter on the Performance Monitor display.
Parent topic: Manage Adaptive Server Databases