Controls the collection of Performance Monitor statistics.
{ dbsrv10 | dbeng10 } -k ...
All operating systems and servers.
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.