You may want to further customize your adapter instance configuration using the microsoftsqlserver.properties file.
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
To validate data collection, see: Validating Data Collection (Microsoft SQL Server).