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