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 Connectteam to configure this setting correctly.

blank

What to do next