Monitoring SQL Server Perfmon with Dynatrace
Hello,
We are running Dynatrace 4 in our production environment and have a need to monitor SQL Server Perform using Dynatrace. There is a plugin available here: SQLServer Monitoring Plugin
After setting up the plugin successfully I get the following message when trying to run it:
"Collector does not support windows monitors."
The response I received from Dynatrace is this:
In order to execute the windows performance monitor you need a collector that runs on windows. The collector should also run under a windows user account that has the privilidges to access these SQL performance counters
So - make sure you have a collector on a windows box and also make sure that you select this collector in your monitor settings.
If anyone else has comments related to this please let me know.
Thanks
Thanks Yev for posting this after we had this discussion per email.
@Roman: thanks for your additional input on this - I asked Yev to post our email thread on the forum because I think others will benefit from this as well.
The SQL Server Plugin that we offer on the community extends the set of Windows Performance Counters that our Windows Performance Monitor can capture. In order for us to capture these counters we need to run our monitor plugin on a Collector that runs on Windows. In order to avoid any security problems with acceessing these counters we recommend running the Collector under a Windows User Account that has the correct privilidges to access the performance counters from that SQL Server Instance.
It is also a Best Practice to have a separate Collector that you use for monitoring only. With that you have a good separation in Collectors that capture information from Agents and Collectors that collect additional System Metrics.
Andi
HI Yev,
The SQL monitoring plugin uses Windows performance counters to gather data from what I remember. The limitation here is that the library used to query them is only available on Windows (not Linux, AIX, ...). Since the monitoring plugins are executed on a collector you will need at least one collector instance that is running on Windows for this plugin.
Or am I missing the point of your question here?
Best, Roman
