-k dbeng12/dbsrv12 server option

Controls the collection of Performance Monitor statistics.

Syntax

{ dbeng12 | dbsrv12 } -k ...

If you specify -k when you start the database server, then the database 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.

-k dbeng12/dbsrv12 server option

Syntax

Default

Applies to

Remarks

See also