-k iqsrv16 database server option

Controls the collection of Performance Monitor statistics.

Syntax

iqsrv16 -k ...

Default

Performance Monitor statistics are collected

Applies to

All operating systems and database servers.

Remarks

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.