You may want to further customize your adapter instance configuration using the microsoftsqlserver.properties file.

Important: Dashboards that include index metrics will not show data unless you change the collection mode as follows:
collection_mode=include_index_queries

Prerequisites

Properties

The following additional configuration settings can be found in the microsoftsqlserver.properties file located in the $VCOPS_BASE/user/plugins/inbound/sql_server_adapter/conf/ folder. You can modify the entries in the file, and they will be read in during the next collection.

Property Description Default Value
maximum_number_of_events_to_return_per_collection This setting limits the total number of events to return per collection cycle. The default value is blank, which returns all events. blank
relationships_sync_interval This setting allows you to specify the sync interval (how many collection cycles to wait) for returning relationships. blank
max_relationships_per_collection This settings limits the total number of relationships to return per collection cycle. The default setting is blank, which returns all relationships. blank
initial_max_scripts_per_execution This setting limits the total number of initial scripts to run per execution. 1000000
subsequent_max_scripts_per_execution This setting limits the total number of subsequent scripts to run per execution. 100
collection_mode

This setting limits the collection mode to exclude index-based queries by default, because of their performance impact. The default setting is normal collection mode, but the alternative setting is include_index_queries to include index-based queries.

Events not collected by default:

Highly Fragmented Indexes

Mildly Fragmented Indexes

Missing Beneficial [sic] Index

Never Accessed Indexes

Unused Maintained Indexes

Potentially Inefficient Indexes

Database resource metrics not collected by default:

user_seeks

user_scans

user_lookups

user_updates

normal
excluded_queries This setting allows you to specify the exact query to exclude that may be causing performance concerns. The value(s) entered here must be semi-colon (;) delimited, using the Management Pack-specific name for the query. We recommend contacting our Customer Support team to configure this setting correctly. blank

What to do next