• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Yev K. · Jun 29, 2012 at 07:16 AM · extensions

Monitoring SQL Server Perfmon with AppMon

Hello,

We are running AppMon 4 in our production environment and have a need to monitor SQL Server Perform using AppMon. 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 privileges 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

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

2 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Andreas G. · Jun 29, 2012 at 01:52 PM

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

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Roman S. · Jun 29, 2012 at 01:38 PM

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

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

3 People are following this question.

avatar image avatar image avatar image

Related Questions

How to Pass Build Tag Variable to AppMon from Jenkins Plugin

Alfresco monitoring with AppMon agents

Is it possible to consume and display data from hystrix dashboards in AppMon?

Extended Email Plugin stopped sending email suddenly

Problem with Jira integration and nothing is being written in the in file .log

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A