Name and Version
SQL Server Monitor
Monitor plugin for Dynatrace to pull in SQL Server specific statistics via perfmon
|Import the Plugin into the Dynatrace Server via the Dynatrace Server Settings menu -> Plugins -> Install Plugin. For details how to do this please refer to the Dynatrace documentation: Plugin Management|
This plugin is an alternative to the existing SQLServer Monitoring Plugin which extends the Windows Performance Monitor plugin built-in to Dynatrace. The difference in this plugin is it uses the instance name in the configuration dialog, so there's no need to change metric properties of the plugin or individual monitor instances in order to monitor database instances. There are only two configuration properties:
|Counter Name Translation||false||The Translation check box enables the Performance Counter name translation. Select this check box if you notice missing Measures due to some target machines running a non-English language version of Windows.|
|Instance Name||<blank>||The instance name of the database to be monitored. Leave blank if default (i.e. no instance name is used), otherwise populate with the configured instance's name|
More information about Monitors: doc
The instance name is just part of the Performance Object's prefix. If the DBA is unable to give you the instance name or you are having issues, you can use Windows' Performance Monitor tool to check the available performance counters on the remote host. There are two possible prefixes:
- SQLServer: In this case, there has not been an instance name created for the database. Leave the "Instance Name" property in your configuration blank.
- MSSQL$<instance-name>: In this case an instance name has been given to this database. If, for instance, the prefix is "MSSQL$PROD01:" you will use prod01 (the property is case-insensitive) as the Instance Name value in the configuration.
Feel free to contribute any changes on GitHub