• 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 PTC S. · Feb 04, 2015 at 07:50 PM ·

Unable to use SQL Server Monitoring Plugin

I have installed SQL server monitoring plugin for my DynaTrace 5.5 but I am unable to use that plugin. I can't create anjy monitors for the same. Please suggest me what should be done. I need to monitor SQL Server Database using this plugin.

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 PTC S. · Mar 02, 2015 at 06:35 PM

Hi, I have a service account which has the access to start and stop dynatrace collector and server on the PSM server(it is a different machine). The database server is on a different machine and SQL server is connected using SQL server authentication and not windows authentication. I am not able to configure my plugin in this case. Can someone help me in doing it.

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 Thomas L. · Feb 05, 2015 at 06:08 AM

Are there any more details you can share on this? I would suggest you follow these steps again (obtained from the SQLServer Monitoring Plugin page)

Installation

1) (optional - only if your SQL Server Instance doesnt use the default name) Edit the plugin.xml file contained in the downloaded zip/jar in order to change the default instance name for SQLServer to your default SQLServer instance name. The default instance name that is used is SQLServer. In case your default instance name is different you can replace every occurance with your instance name. This change is not mandatory as it can also be changed later in the dynaTrace Client. It is however more convenient to change it in the file because there are many instances it need to be changed. 2
2) Open the Server Preferences dialog and open the Plugins tab
3) Choose "Import Plugin..." and select the downloaded (or modified) zip/jar file 
4) Verify that the plugin was correctly installed. Verify that the plugin "Sql Server Performance Monitor" shows up in the list of installed plugins 

In order to subscribe to Sql Server Performance Measures you have to: 
1) Edit your System Profile 
2) Add a new Monitor 
3) Select "Windows Performance Monitor" 
4) Specify "Sql Server Performance Monitor" as the monitors name (This is important if you also want to use the Sql Server Dashboard that is attached to this plugin) 
5) Specify the hostname of SQL Server in the monitor properties 
6) View a list of all Measures that you now have subscribed. You can view and modify the list on the Measures tab

Note: Credentials are not required to be entered into the plugin itself. The plugin runs on a dynaTrace Collector, and the credentials which are executing the selected dynaTrace Collector need to have permission to query SQLServer PerfMon metrics from the SQLServer machine being speciifed in the Plugin.

For troubleshooting advice concerning querying Windows Performance Counters in dynaTrace, see the following pages:

  • How To Retrieve Performance Metrics with Windows Performance Monitor
  • Advice in Forum

 

You can also try reinstalling the plugin to see if that helps. 

 

Tom

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

1 Person is following this question.

avatar image

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