Controls the collection of Performance Monitor statistics.

Syntax

{ dbsrv11 | dbeng11 } -k ...

Applies to

All operating systems and database servers.

Remarks

The database server collects Performance Monitor statistics by default.

If you specify -k when you start the database server, then the server does not collect Performance Monitor statistics. The -k option does not affect the collection of column statistics used by the query optimizer.

This option should only be used in situations where the database server is running on a multi-processor computer where it can be shown by testing to improve performance. For most workloads, the benefit will be negligible, so use of this option is not recommended. When you disable the performance counters, this information is not available for analyzing performance problems.

You can also change the setting for the collection of Performance Monitor statistics using the sa_server_option system procedure. See sa_server_option system procedure.

See also

• -ks server option
• -ksc server option
• -ksd server option
• Monitoring statistics using Sybase Central Performance Monitor