Icon

Comments have been closed on this page. Please use AppMon & UEM Plugins forum for questions about this plugin.

Overview

Icon

Please note that most of this plugin's functionality was transferred to the Database Agent available in Dynatrace AppMon 6.3.

Plugin which monitors Microsoft's SQL Server via PerfMon.  Accepts database instance name as a configuration parameter (if needed)

Name and Version

SQL Server Monitor

Compatible with

6.x +

Author

Richard Boyd

License

dynaTrace BSD

Support Level

Not Supported

Download

com.dynatrace.diagnostics.plugin.SQLServerMonitor_1.0.0.jar

Description

Monitor plugin for Dynatrace to pull in SQL Server specific statistics via perfmon

Screenshots

Configuration:

Captured measures/counters:

Installation

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

Usage

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:

PropertyDefault ValueNotes
Counter Name TranslationfalseThe 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

Additional Note:

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

  1. Anonymous (login to see details)

    Hi Rick Boyd,  is this the same version you did for us while you were here?   I can not seem to get more than 3 sql servers to work in the monitor.   Probably something I am doing wrong.

    1. Anonymous (login to see details)

      I'm not sure why that would be, except possibly it's running too frequently or there is too much latency? 

  2. Anonymous (login to see details)

    Hello, I have install this last plugin for SQLServer. Unfortunately there is only 3 measures with values. All the others are "null" ? For the instance Name, I have put the simple name without MSSQL$ but still the same. Some measure have three key property. What is "instanceName" ? By default there is "_Total". Any idea ?

    Thanks for your help (smile)!

    1. Anonymous (login to see details)

      Hi Benoit,

      What measures are working?  Is anything showing the log?  You can get to the logfile by opening System Information -> (expand the server) -> Connected Systems -> (collector which is executing the monitor) -> Log Files.  Mine's the com.dynatrace.diagnostics.plugin.SQLPerfPluginMonitor.0.0.log

      Rick B

  3. Anonymous (login to see details)

    Morning Rick,

    There are only three measures with values. The log show:

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Locks, Lock Requests/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Locks, Average Wait Time (ms), _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Locks, Lock Requests/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Locks, Number of Deadlocks/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Locks, Average Wait Time (ms), _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:SQL Statistics, SQL Compilations/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Locks, Number of Deadlocks/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:SQL Statistics, Batch Requests/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:SQL Statistics, SQL Compilations/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Databases(*), Write Transactions/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:SQL Statistics, Batch Requests/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Databases(*), Log Flushes/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Databases(*), Write Transactions/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Lazy writes/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: ø`ý (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Databases(*), Log Flushes/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Checkpoint pages/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Lazy writes/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: ø`ý (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Page life expectancy, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Checkpoint pages/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Page reads/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Page life expectancy, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Buffer cache hit ratio, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Page reads/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Page writes/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Buffer cache hit ratio, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Access Methods, Page Splits/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: ø`ý (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Buffer Manager, Page writes/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Access Methods, Full Scans/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Access Methods, Page Splits/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: ø`ý (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:Databases, Log Cache Hit Ratio, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: ø`ý (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:Access Methods, Full Scans/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:General Statistics, User Connections, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: ø`ý (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:General Statistics, Transactions, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_0] failed to retrieve value from: MSSQL$<instance_Name>:SQL Errors, Errors/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: ø`ý (System error code: 0x3E5)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:General Statistics, Transactions, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.

     (System error code: 0x0)

    2015-10-14 09:19:41 WARNING [PerformanceMonitor@Sql Server Performance Monitor_1] failed to retrieve value from: MSSQL$<instance_Name>:SQL Errors, Errors/sec, _Total, Invalid data from PerformanceCounters. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: ø`ý (System error code: 0x3E5)

     

     If I take one measure (General Statistics\Transactions) and I try "by hand" the result is:

    C:\Windows\system32>typeperf -sc 3 "\\<server_Name>\MSSQL$<instance_Name>:General Statistics\Transactions"

    "(PDH-CSV 4.0)","\\<server_Name>\MSSQL$<instance_Name>:General Statistics\Transactions"

    "10/14/2015 09:25:07.488","19.000000"

    "10/14/2015 09:25:08.488","19.000000"

    "10/14/2015 09:25:09.504","19.000000"

    The command completed successfully.

    The strange thing is that for "General Statistics\User Connections", the log speak about System error code 0x3E5 but this is the only measure with a real value. If I create a new dashboard with only this measure, it works! I'm a little "lost" ??

    C:\Windows\system32>typeperf -sc 3 "\\<server_Name>\MSSQL$<instance_Name>:General Statistics\User Connections"

    "(PDH-CSV 4.0)","\\<server_Name>\MSSQL$<instance_Name>:General Statistics\User Connections"

    "10/14/2015 09:30:13.472","78.000000"

    "10/14/2015 09:30:14.472","78.000000"

    "10/14/2015 09:30:15.473","78.000000"

    The command completed successfully.

     Is there any test that I can try to be more accurate?

    Thanks,

    Benoît.

    1. Anonymous (login to see details)

      What user is running the collector service?  I typically see 0x0 when the user doesn't have permission to query the counters

      Rick B

    2. Anonymous (login to see details)

      So, in the end it now works.

      We switched to "finer" log level and could see that the plugin was actually retrieving the values.

      Then we noticed that the "Counter Name Translation" option was checked.

      => unchecking the option allowed to get the values.

       

  4. Anonymous (login to see details)

    There are three services accounts:

    • service1 : used for server, frontend and collector server. All on the same server,
    • service2 : used for SQL Server database,
    • service3 : used for the application to monitor and the dtwsagent installed locally.

    all those services are in the group "performance Monitor Users" on all servers.

    Benoît.

     

    1. Anonymous (login to see details)

      Please verify the service1 is a network account and not just a duplicate local account, and that the collector referenced in the monitor is one running on Windows.  

       

      The majority of the code of this plugin is a copy of the Windows Performance Monitor which is included with the product.  Please try using this one as well for the same host to verify everything is working for system counters

  5. Anonymous (login to see details)

    Thanks Rick,

    I will check that. I have seen another thing for the web server; I have IIS and it is still under "Local System". I suppose it is not a good idea. We have to change that to something like "Network service".

    Benoît.

  6. Anonymous (login to see details)

    We configured a windows collector for the SQL Server Monitoring pluging. From this collector we connect with dynatrace user to this SQL Server.

    Problem: we do not receive any data for the SQL perfmon counters.

    Our tests:

    • on our dynatrace server -> collectors -> connection ok
    • on our system profile -> monitor -> SQL Server monitor is running every 10 minutes
    • in our collector log we get a warning:
      • 2015-11-19 11:00:05 WARNING [UserPluginManager] com.dynatrace.diagnostics.plugin.perflib.perfmon.InvalidOperationException - not connected

        com.dynatrace.diagnostics.plugin.perflib.perfmon.InvalidOperationException: not connected

                       at com.dynatrace.diagnostics.plugin.perflib.perfmon.internal.PerformanceMonitorImpl.query(PerformanceMonitorImpl.java:207)

                       at com.dynatrace.diagnostics.plugin.WindowsPerformanceMonitor.execute(WindowsPerformanceMonitor.java:135)

                       at com.dynatrace.diagnostics.plugin.SQLServerMonitor.execute(SQLServerMonitor.java:92)

                       at com.dynatrace.diagnostics.sdk.UserPluginManager.a(SourceFile:752)

                       at com.dynatrace.diagnostics.sdk.UserPluginManager.b(SourceFile:489)

                       at com.dynatrace.diagnostics.sdk.UserPluginManager.executePlugin(SourceFile:285)

                       at com.dynatrace.diagnostics.sdk.MonitorPluginExecutor.execute(SourceFile:51)

                       at com.dynatrace.diagnostics.sdk.MonitorPluginExecutor.execute(SourceFile:26)

                       at com.dynatrace.diagnostics.scheduling.impl.ServerJobCenterRegistry.a(SourceFile:190)

                       at com.dynatrace.diagnostics.scheduling.impl.ServerJobCenterRegistry.a(SourceFile:413)

                       at com.dynatrace.diagnostics.scheduling.impl.ServerJobCenterRegistry.execute(SourceFile:337)

                       at com.dynatrace.diagnostics.scheduling.impl.SchedulerJob.a(SourceFile:101)

                       at com.dynatrace.diagnostics.scheduling.impl.SchedulerJob.work(SourceFile:92)

                       at com.dynatrace.diagnostics.scheduling.impl.SchedulerJob.executeJobInfo(SourceFile:241)

                       at com.dynatrace.diagnostics.scheduling.impl.QuartzJob.execute(SourceFile:45)

                       at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

                       at com.dynatrace.diagnostics.scheduling.impl.QuartzThreadPool$WorkerThread.run(SourceFile:788)

    • on the window collector machine, we made a connection to the SQL Server with our dynatrace user without having any problem -> connection ok
    • we've added a counter to check if we get any data from it -> reading perfmon stats ok

    Any idea why I can't make a connection from my DynaTrace environment to the SQL Server for reading the perform stats????? 

     

    1. Anonymous (login to see details)

      Hi Jannick,

      When you say you connected from the collector to the SQL Server, can you let me know what method you used to test this?  Can you please try (in the host where the collector is) Ctrl+Shift+right-click "Performance Monitor" in the administrative tools and Run as different user, using your dynatrace service account (same one as the collector service is running as).  Then try to connect and query the performance counters?  This will validate network and permissions are valid for your configuration.

      Thanks,

      Rick B

  7. Anonymous (login to see details)

    Hi Rick,

    I had this plugin working, for about 20 minutes, when it stopped and I just can't see why.  I have verified that the user account has access from the collector to the database server and can read perfmon stats (using Run As on the collector to run as the collector user).  The error is this (same for all counters):
     

    2016-01-20 09:36:10 WARNING [PerformanceMonitor@zTrade SQL Server Monitor_0] failed to retrieve value from: SQLServer:Locks, Number of Deadlocks/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: Unable to connect to the specified computer or the computer is offline.
    (System error code: 0x800007D0)

     

    The computer is online and I can connect to it from the collector machine using the same user ID as the collector (a domain ID).  I have tried deleting and recreating the config for this server in the plugin and restarted the collector (several times).  There is nothing in the logs that suggests anything changed when the plugin stopped working (checked both the plugin log and the collector log).

    So, I am at a bit of a loss now.  Any ideas on what might be the issue, or any other diagnostic route I could take?

    Thanks,

    Adrian.

    1. Anonymous (login to see details)

      Hi Adrian,

      I'm not sure why it would stop working...

      The plugin is based on the Windows Performance Monitor which comes out-of-the-box.  Can you configure that type of monitor for the collector and target host to see if that is working?

      Rick B

  8. Anonymous (login to see details)

    Hi Rick,

    After a lot of playing around that instance of SQL monitor appears to be stable, it has been up and running for 3 days now, but I am not entirely sure why (smile) 

    Anyway, I have two other instances of SQL server monitor and both are suffering from the same problem.  They both use the same domain service account as the working instance above, and I can query the counters manually from the collector, using a terminal window running as the service account used by the collector but both return this error:

    2016-02-12 09:08:19 WARNING [PerformanceMonitor@GW_IT SQL Server Monitor_1] failed to retrieve value from: SQLServer:Locks, Number of Deadlocks/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: Unable to access the desired computer or service. Check the permissions and authentication of the log service or the interactive user session against those on the computer or service being monitored.
    (System error code: 0xC0000BDB)

    Clearly this suggests permissions but as I say I can use the account that the collector uses and the typeperf command to query the counters from the collector machine to the db server, so I'm at a bit of a loss.

    I have also tried the Performance Monitor plugin, and that suffers exactly the same issue, I can get the Available MBytes counter manually (for example) but the plugin fails.

    Any ideas on what the issues could be?

    Thanks,

    Adrian.

     

  9. Anonymous (login to see details)

    Hello,

    We are attempting to implement this monitor and whenever we run a scheduled task the host we attempt to monitor disappears from the interface and the following message:

    2016-02-16 14:40:37 WARNING [Scheduler] [TTCE tedntcoltr05 dcrum monitors@tedntcoltr05t] Unable to run schedule SRO_FO_DB_0. : com.dynatrace.diagnostics.scheduling.impl.QuartzJobCenter runScheduleNow:1891
    org.quartz.JobPersistenceException: The job (SRO_FO.SRO_FO_DB_0) referenced by the trigger does not exist.
    at org.quartz.simpl.RAMJobStore.storeTrigger(RAMJobStore.java:321)
    at org.quartz.core.QuartzScheduler.triggerJob(QuartzScheduler.java:951)
    at org.quartz.impl.StdScheduler.triggerJob(StdScheduler.java:348)
    at org.quartz.impl.StdScheduler.triggerJob(StdScheduler.java:336)
    at com.dynatrace.diagnostics.scheduling.impl.QuartzJobCenter.runScheduleNow(SourceFile:1886)
    at com.dynatrace.diagnostics.scheduling.impl.QuartzJobCenter.runScheduleNow(SourceFile:2290)
    at com.dynatrace.diagnostics.scheduling.protocol.requests.RunScheduleNowRequestHandler.execute(SourceFile:17)
    at com.dynatrace.diagnostics.scheduling.protocol.requests.RunScheduleNowRequestHandler.execute(SourceFile:9)
    at com.dynatrace.diagnostics.scheduling.protocol.AbstractJobCenterRequestHandler.execute(SourceFile:69)
    at com.dynatrace.diagnostics.scheduling.protocol.AbstractJobCenterRequestHandler.execute(SourceFile:16)
    at com.dynatrace.diagnostics.sdk.communication.SessionRequestListener.handleCustomRequest(SourceFile:330)
    at com.dynatrace.diagnostics.sdk.communication.SessionRequestListener.handleRequest(SourceFile:94)
    at com.dynatrace.diagnostics.communication.tcp.connection.BaseRequestListener.notifyRequest(BaseRequestListener.java:50)
    at com.dynatrace.diagnostics.communication.tcp.session.DefaultService.notifyRequest(DefaultService.java:97)
    at com.dynatrace.diagnostics.communication.tcp.session.DefaultSession.notifyRequest(DefaultSession.java:469)
    at com.dynatrace.diagnostics.communication.tcp.session.DefaultSessionManager.handleSessionServiceRequest(DefaultSessionManager.java:715)
    at com.dynatrace.diagnostics.communication.tcp.session.DefaultSessionManager.notifyRequest(DefaultSessionManager.java:654)
    at com.dynatrace.diagnostics.communication.tcp.connection.DefaultSocketListener.notifySocketActive(DefaultSocketListener.java:91)
    at com.dynatrace.diagnostics.communication.tcp.connection.DefaultSocketListener.notifySocketActive(DefaultSocketListener.java:28)
    at com.dynatrace.diagnostics.communication.tcp.socket.DefaultSocketHandlerRunnable.notifySocket(DefaultSocketHandlerRunnable.java:114)
    at com.dynatrace.diagnostics.communication.tcp.socket.DefaultSocketHandlerRunnable.handleRequest(DefaultSocketHandlerRunnable.java:100)
    at com.dynatrace.diagnostics.communication.tcp.socket.DefaultSocketHandlerRunnable.execute(DefaultSocketHandlerRunnable.java:55)
    at com.dynatrace.diagnostics.util.threads.StatusRunnable.run(StatusRunnable.java:46)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)

     

    1. Anonymous (login to see details)

      Hi Jacob,

      I've replied to you via email.  Not sure what's going on here but we'll figure it out (smile)

      Rick B

  10. Anonymous (login to see details)

    I'm having the same problem as Jannick did above – the Dynatrace monitor just shows "Failed", with no additional information in the DT client.  The collector log shows the same "not connected" message and stack dump that he was seeing.

    I've run perfmon as you suggested – on the collector box, using ctrl-shift-click to run as the user running the collector service.  From here, I can click on performance monitor, and then add a counter on, for example, \\<db_host>\\MSSQL$<instance>:Buffer Manager\Buffer cache hit ratio (where db_host and instance are the values used to configure the monitor).  No issues seen here.

    Any other suggestions?  We're running Dynatrace 6.2.3; the user is a domain user in the Performance Monitor Users group.

    1. Anonymous (login to see details)

      Hi Gary,

      Please make sure the user is in Performance Monitor Users on both the collector host and the sql server host, that's what normally trips me up.

      Otherwise everything on this page applies to this plugin: How To Retrieve Performance Metrics with Windows Performance Monitor

      Rick B

      1. Anonymous (login to see details)

        That was it!  The user was in the group on the SQL server, but not on the collector.  After I updated the group on the collector, the monitor succeeds and I see values being returned.

        Thanks for the assist (and for the plugin)!

        Gary

  11. Anonymous (login to see details)

    Hi, Can I ask why this plugin has "Standalone" named in the title? Is there a reason for that, meaning it only works on a Standalone SQL Server and not a clustered environment?

    1. Anonymous (login to see details)

      Good question. It has nothing to do with standalone instances but it is a SQL Server Monitor Plugin that runs "on its own" and is not just an extension to the Windows Performance Monitor Plugin which we also provide. This plugin is executed on the scheduled interval and queries the core SQL Server Metrics through PerfMon. The OTHER SQL Server Plugin that we had for a little while longer is simply defining a set of new perf counters for the "Windows Performance Monitor" plugin. I hope this explains it

      I personally like the fact that this is available standalone as it really just provides the metrics for your SQL Server Instance that you specify in the properties. It doesnt require any other configuration.

      If you are interested in database monitoring you should also check out our new Database Agent Capabilities for SQL Server: Database Monitoring

      1. Anonymous (login to see details)

        Hi Andreas,

        Thanks for the info.  I must say that we are issues with the SQL Server Monitoring Plugin (Standalone) in DT. We have a service account that runs fine on the collector and it have admin right to the remote server and has the right on the sql db, We have manually tested that it can get the MS SQL counter values against the remote DB via the Perfmon (running under the service acc) or by typeperf, but the plugin either constantly errors or runs a bit and then stops working. I am starting to wonder if its a domain issue or maybe due to it being a cluster.

        I am interested in the new database capabilities for the MS SQL Server, but we are still currently on 6.2.3.  What version of SQL Server will the new DB agent (in 6.3) work with? 

         

        Thanks Stuart

         

        1. Anonymous (login to see details)

          Taken from 6.3 Release Notes: DB Agent supports Oracle Database 11g/12c and Microsoft SQL Server 2012/2014

          If the plugin stops then I suggest to look at the log file it produces. maybe thereis more informaiton in those logs. the best way forward is definitely to start looking into the DB Agent though. I hope you can upgrade soon

          1. Anonymous (login to see details)

            Hi Andreas,

            I think half the problem is understanding where we should poll to get the SQL plugin data from when running against a SQL cluster environment. We are running this against a clustered SQL environment, where we have a SQL cluster name, and then 2 DB SQL server nodes under it. Where should we be polling the monitoring, against the he SQL Cluster Name instance, or the 2 SQL nodes instances within the cluster? We are finding that when we direct the monitoring to SQL Cluster Name instance it sometimes works and then fails, but if we do each SQL DB server it works. I would have thought when this is in a cluster you would point it to run against the SQL cluster name, not the nodes under it?

             

            Thanks Stuart.

            1. Anonymous (login to see details)

              In my experience you are better off getting the node-level data rather than the cluster-level data for this type of monitoring (resource), whereas you'd want to do availability-type monitoring at the service/cluster level (and optionally also at the node level).

               

              Rick B

              1. Anonymous (login to see details)

                Thanks Rick,

                 

                Its all becoming clear why in a cluster env we should be polling the node level as we never have issues gathering the data at that level for the SQL plugin when in a cluster, whereas against the cluster name its sporadic for some reason, which we haven't found the cause, thanks.

                Thank you all for the helpful information.

  12. Anonymous (login to see details)

    Hi,

    When using the SQL Standalone plugin, what permissions does the plugin need on the DB server to retrieve the stats required. We have configured it so the DT collector service runs as a service account that has rights access rights on the SQL Server. But our DBAs are not willing to provide full sysadmin access so need to know the specific requirements, can you please provide that, thanks?

    1. Anonymous (login to see details)

      Hello,

      Have you try to put also the DBOwn in group "Performance Monitor Users" ?

      Regards.

    2. Anonymous (login to see details)

      Hi Stuart,

      I was out on paternity leave when you wrote this, sorry I missed it.  Hopefully you've resolved it by now but I'll answer here for anyone's benefit:

      The plugin doesn't query SQL server, but rather the Performance Monitoring stats published by Windows.  The service account only needs to be in the Performance Monitor Users groups on both the collector server and db server to successfully execute.

      Rick B

  13. Anonymous (login to see details)

    Hi Richard ;

    How are you ?

    I have some questions about the plugin, please help me.

    It is possile to monitor many instance of SQL or many servers  ?

    it is possible monitoring another version SQL, for exemplo,  SQL Enterprise 2008 or 2012 ?

    Thank you for help

    FDL

     

    1. Anonymous (login to see details)

      Hi Fabiano,

      Yes, the plugin can be configured to use "intersections" as well as individual hosts, which you can use by defining a hostgroup or set of hostgroups and all the SQL server hosts in the Infrastructure section of your server settings.  You would just need to create a monitor instance for each unique Database Instance name configured.  More info:

      Monitors | Infrastructure

      As far as I know the performance counters have not changed in any modern version of SQL Server, so you should be ok as far as different versions go.

      Hope that helps,

      Rick B

      1. Anonymous (login to see details)

        Hi Rick ;

        Please, what are the permissions what the user in the database servers ?

        FDL

         

         

         

        1. Anonymous (login to see details)

          The plugin doesn't query SQL server, but rather the Performance Monitoring stats published by Windows.  The service account only needs to be in the Performance Monitor Users groups on both the collector server and db server to successfully execute.

          Hope that helps

          Rick B

          1. Anonymous (login to see details)

            Hi Rick;

            We have dynaTrace 6.2 server software and three collectors running on Linux servers. Some point of attention in installing the plugin? Another point related to the user who will collect the performance of SQL servers, not visualized in the plugin configuration where should I put this User?

            When I created the task monitor appear an error , the file log is null (zero kb.). I setting the plug-in log how finer.

            1. Anonymous (login to see details)

              Hi Rick;

              I installed a new collector in the Windows Server , according the suggested above.

              But I saw in file log of Plugin , following error :

              016-07-26 11:04:59 WARNING [PerformanceMonitor@spobrdbdev01\spobrdbdev01_0] failed to retrieve value from: MSSQL$XXXXX01\XXXXXXX01:SQL Statistics, SQL Compilations/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: Unable to access the desired computer or service. Check the permissions and  authentication of the log service or the interactive user session against  those on the computer or service being monitored.

              Another point related to the user who will collect the performance of SQL servers, not visualized in the plugin configuration where should I put this User?

              Help me, please.

              Regards.

              FDL

              1. Anonymous (login to see details)

                I put the user in both the Performance Monitor Users groups, however the Monitor detail are still displayed nulls. I wonder if the dynaTrace Collector service settings, Log on, I should run the service with this User that was created?

                Details from Task Monitor :

                Access: Full Scans/sec: null

                Access: Page Splits/sec: null

                Buffer: Cache hit ration: null

                Buffer: Checkpoint pages/sec: null

                Buffer: Lazy writes/sec: null

                Buffer: Page life expectancy: null

                Buffer: Page reads/sec: null

                Buffer: Page writes/sec: null

                Database: Log Cache Hit Ration: null

                Database: Log Flushes/sec: null

                Errors: Errors/sec: null

                Locks: Average Wait Time (ms): null

                Locks: Number of Deadlocks/sec: null

                Locks: Requests/sec: null

                Stats: Batch Requests/sec: null

                Stats: SQL Compilations/sec: null

                Stats: Transactions: null

                Stats: User Connections: null

                 

                When I see the log Plug-in SQL errors are:

                2016-07-26 11:04:59 WARNING [PerformanceMonitor@XXXXX01\XXXXX01_0] failed to retrieve value from: MSSQL$XXXXXX01\XXXXXX01:SQL Statistics, SQL Compilations/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: Unable to access the desired computer or service. Check the permissions and  authentication of the log service or the interactive user session against  those on the computer or service being monitored.

                (System error code: 0xC0000BDB)

                2016-07-26 11:04:59 WARNING [PerformanceMonitor@XXXXX01\XXXXX01_0] failed to retrieve value from: MSSQL$XXXXX01\XXXXX01:SQL Statistics, Batch Requests/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: Unable to access the desired computer or service. Check the permissions and  authentication of the log service or the interactive user session against  those on the computer or service being monitored.

                (System error code: 0xC0000BDB)

                2016-07-26 11:04:59 WARNING [PerformanceMonitor@XXXXX01\XXXXX01_0] failed to retrieve value from: MSSQL$XXXXX01\XXXXX01:Buffer Manager, Lazy writes/sec, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: Unable to access the desired computer or service. Check the permissions and  authentication of the log service or the interactive user session against  those on the computer or service being monitored.

                 

                In the SQL server I run perfmon and see the counters accumulating values.

                Can help me in this case?

                Regards

                FDL

                 

                 

  14. Anonymous (login to see details)

    Hello,

    Have you try some command line to check if the value are retrieved ? Like below:

    C:\Windows\system32>typeperf -sc 3 "\\<server_Name>\MSSQL$<instance_Name>:General Statistics\User Connections"

    "(PDH-CSV 4.0)","\\<server_Name>\MSSQL$<instance_Name>:General Statistics\User Connections"

    "10/14/2015 09:30:13.472","78.000000"

    "10/14/2015 09:30:14.472","78.000000"

    "10/14/2015 09:30:15.473","78.000000"

    The command completed successfully.

     If yes, check also what it is mention by Laurent about the "Counter Name Translation" option.

    1. So, in the end it now works.

      We switched to "finer" log level and could see that the plugin was actually retrieving the values.

      Then we noticed that the "Counter Name Translation" option was checked.

      => unchecking the option allowed to get the values.

    2.  

    Regards,

    Benoît.

    1. Anonymous (login to see details)

      Hi Benoit;

      First Step  : I performed the command, It is success:

      C:\>typeperf -sc 3 "\\SQLSERVER01\SQLServer:General Statistics\User Connections"

      "(PDH-CSV 4.0)","\\SQLSERVER01\SQLServer:General Statistics\User Connections"

       "07/27/2016 13:33:35.938","130.000000"

      "07/27/2016 13:33:36.952","131.000000"

      "07/27/2016 13:33:37.966","131.000000"

      The command completed successfully.

      C:\>typeperf -sc 3 "\\SQLSERVER01\SQLServer:Buffer Manager\Buffer cache hit ratio"

      "(PDH-CSV 4.0)","\\SQLSERVER01\SQLServer:Buffer Manager\Buffer cache hit ratio"

       "07/27/2016 13:35:01.710","99.974214"

      "07/27/2016 13:35:02.724","99.941721"

       "07/27/2016 13:35:03.738","99.941721"

      The command completed successfully.

       

      Secound Step : I verified the parameter "Counter Name Translation" and now It is unchecked.

       

      Third step: I see what in the Instance name is "default", so I left blank the Setting "Instance Name" .

      Still I see errors in the log Plug-in :

      (System error code: 0xC0000BDB)

      2016-07-27 12:28:31 WARNING [PerformanceMonitor@SQLSERVER01_0] failed to retrieve value from: SQLServer:Locks, Lock Requests/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: Unable to access the desired computer or service. Check the permissions and  authentication of the log service or the interactive user session against  those on the computer or service being monitored.

      (System error code: 0xC0000BDB)

      2016-07-27 12:28:31 WARNING [PerformanceMonitor@SQLSERVER01_0] failed to retrieve value from: SQLServer:Locks, Average Wait Time (ms), _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: Unable to access the desired computer or service. Check the permissions and  authentication of the log service or the interactive user session against  those on the computer or service being monitored.

      (System error code: 0xC0000BDB)

      2016-07-27 12:28:31 WARNING [PerformanceMonitor@SQLSERVER01_0] failed to retrieve value from: SQLServer:Locks, Number of Deadlocks/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: Unable to access the desired computer or service. Check the permissions and authentication of the log service or the interactive user session against those on the computer or service being monitored.

      Can you help me ;

      Regards;

      FDL

       

       

      1. Anonymous (login to see details)

        Hi,

        So you do not have Instance Name for the Database you follow. Let's check the owner of each part:

        all dynatrace services used the same service name for example "serv_dyna"

        The database "SQL Server (MSSQLSERVER)" service used service name for example "serv_sqlown"

        Those two "serv_xxx" must be in the "Performance Monitors Users" AND in "Administrators" Groups.

        Try this,

        Regards,

        Benoît.

        1. Anonymous (login to see details)

          Hi Benoit;


          Thanks for listening.

            See the actions taken:

            Step 1

           Validate service MSSQL: Name: SQL Server (MSSQLSERVER) "E: \ Program Files \ Microsoft SQL Server \ MSSQL11.MSSQLSERVER \ MSSQL \ Binn \ sqlservr.exe" -sMSSQLSERVER
           

          Step 2

           Validate the log collector service: This set to User access to the database. This included the Admin Group and Performance Monitor Users.
           

          Step 3

           Enter the name "MSSQLSERVER" in the parameter of the instance in the Dyantrace SQL Server monitor.
           

          Step 4

           Still without collecting SQL Server perfromance data .

          (System error code: 0x0) 2016-07-28 11:49:31 WARNING [PerformanceMonitor@SQLSERVER01_0] failed to retrieve value from: MSSQL$MSSQLSERVER:General Statistics, Transactions, null: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.  (System error code: 0x0) 2016-07-28 11:49:31 WARNING [PerformanceMonitor@SQLSERVER01_0] failed to retrieve value from: MSSQL$MSSQLSERVER:Databases, Log Flushes/sec, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.  (System error code: 0x0) 2016-07-28 11:49:31 WARNING [PerformanceMonitor@SQLSERVER01_0] failed to retrieve value from: MSSQL$MSSQLSERVER:Databases, Log Cache Hit Ratio, _Total: Unable to get Value. Please check if the host is reachable and the requested Performance Counter is available. Detailed error message: The returned data is valid.  (System error code: 0x0)

          Access: Full Scans/sec: null Access: Page Splits/sec: null Buffer: Cache hit ration: null Buffer: Checkpoint pages/sec: null Buffer: Lazy writes/sec: null Buffer: Page life expectancy: null Buffer: Page reads/sec: null Buffer: Page writes/sec: null Database: Log Cache Hit Ration: null Database: Log Flushes/sec: null Errors: Errors/sec: null Locks: Average Wait Time (ms): null Locks: Number of Deadlocks/sec: null Locks: Requests/sec: null Stats: Batch Requests/sec: null Stats: SQL Compilations/sec: null Stats: Transactions: null Stats: User Connections: null

           

          Log Monitor:

          Schedule Details Name: SQLSERVER01 Status: scheduled Description:  Type: SQL Server Monitor Last Run: 12:23:31 (BRT) Last Run Result: ok Next Run: - Current Run: - Duration (last run): < 1s Schedule: Every Minute Execution Target: Collector01@Collector01.serasa.intranet Plugin Active: active Result Status: success Result: Last polling execution terminated successfully Message: Success Detailed message: Plugin execution successful Retrieved measurements: Access: Full Scans/sec: null Access: Page Splits/sec: null Buffer: Cache hit ration: null Buffer: Checkpoint pages/sec: null Buffer: Lazy writes/sec: null Buffer: Page life expectancy: null Buffer: Page reads/sec: null Buffer: Page writes/sec: null Database: Log Cache Hit Ration: null Database: Log Flushes/sec: null Errors: Errors/sec: null Locks: Average Wait Time (ms): null Locks: Number of Deadlocks/sec: null Locks: Requests/sec: null Stats: Batch Requests/sec: null Stats: SQL Compilations/sec: null Stats: Transactions: null Stats: User Connections: null

           

          What if I send the configuration prints to your email?

          Can I send the prints to your email, you could contact by email "fabiano.lizzardo@experian.br. Please.

          Regards;

          FDL

           

          1. Anonymous (login to see details)

            The issue is, I do not have access to the dynatrace configuration. I'm not a customer site. I just try to remember the setting we have. I have some pictures just in case but it seem now, you have the same setting as us. You can try to send me some print at benoit.monfort@gmail.com . Will see ?

            Regards, Benoît.

            1. Anonymous (login to see details)

              Hi Benoit;

              I Send the evidences of implementation the SQL Server Monitoring Plugin (Standalone) in his email.

              it is possible to realize remote session if necessary?

              Thank you for help me in this case .

              Regards;

              FDL

               

              1. Anonymous (login to see details)

                Hi Fabiano,

                I've just look your image and the first thing I saw is the Name of the "SQL Server Monitor". In my case I have leave the original name. Try to Rename to "SQL Server Performance Monitor".

                To summarize:

                • Server1 : dynatrace server, collector and frontend
                • Server2 : the SQL Server with Database MSSQLSERVER. You want to follow this Database, right ?

                In my case I used "service account" from a domain and not local account. But not sure it is the root cause because the command "typeperf" works!

                From "Server1" the command 

                typeperf -sc 3 "\\SQLSERVER01\SQLServer:General Statistics\User Connections"

                works! it's true?

                typeperf -sc 3 "\\SQLSERVER01$MSSQLSERVER\SQLServer:General Statistics\User Connections"

                works also ?

                Regards,

                Benoît.

                 

                1. Anonymous (login to see details)

                  Hi Benoit;

                   

                  I rename the name of SQL Server Monitor.

                  My Dynatrace Server is an Server Linux (Red Hat) and my collector is Windows Server.

                  Follow the results from the collector server (Windows).

                  C:\>typeperf -sc 3 "\\SPOBRDBDEV01\SQLServer:General Statistics\User Connections

                  "(PDH-CSV 4.0)","\\SPOBRDBDEV01\SQLServer:General Statistics\User Connections"

                  "07/29/2016 09:31:09.194","130.000000"

                  "07/29/2016 09:31:10.209","130.000000"

                  "07/29/2016 09:31:11.223","130.000000"

                  The command completed successfully.

                  C:\>typeperf -sc 3 "\\SPOBRDBDEV01$MSSQLSERVER\SQLServer:General Statistics\User ctions"

                  Error: No valid counters.

                  1. Anonymous (login to see details)

                    So, you have to remove MSSQLSERVER in the setting for Instance Name.

                    Benoît.

                    1. Anonymous (login to see details)

                      Hi Benoit;

                      Now the values are shown in the measurements. I will build the Dashboards;

                      Access: Full Scans/sec: 53.0

                      Access: Page Splits/sec: 3.0

                      Buffer: Cache hit ration: 100.0

                      Buffer: Checkpoint pages/sec: 14.0

                      Buffer: Lazy writes/sec: 0.0

                      Buffer: Page life expectancy: 9213.0

                      Buffer: Page reads/sec: 11.0

                      Buffer: Page writes/sec: 35.0

                      Database: Log Cache Hit Ration: 0.0

                      Database: Log Flushes/sec: 9.0

                      Errors: Errors/sec: 1.0

                      Locks: Average Wait Time (ms): 27.0

                      Locks: Number of Deadlocks/sec: 0.0

                      Locks: Requests/sec: 5163.0

                      Stats: Batch Requests/sec: 569.0

                      Stats: SQL Compilations/sec: 1.0

                      Stats: Transactions: 0.0

                      Stats: User Connections: 138.0

                       

                      Thank you for help in this case;

                      Regards;

                      FDL

                      1. Anonymous (login to see details)

                        ok great !

                        Regards,

                        1. Anonymous (login to see details)

                          Hi Benoit;

                          Good Works!!

                          Did you have some sample dashboard to send me, as I will demonstrate to support teams. It would be nice if it had a dashboard file to send me, please;

                          Regards;

                            FDL

                  2. Anonymous (login to see details)

                    I do not know about the mix between Linux and Windows for the service account. Try with dynatrace.

                    Benoît.

                    1. Anonymous (login to see details)

                      Fabiano,

                      I can't have access to your email. 

                      Technical details of permanent failure:
                      Google tried to deliver your message, but it was rejected by the server for the recipient domain xxxxx by yyyyyyyy <IPAddress>

                      The error that the other server returned was:
                      <IPAddress>. You are not allowed to connect.

                      Regards,

                      1. Anonymous (login to see details)

                        Benoit;

                        Thank you for help . The file was received, I will adjust it.

                        Regards;

                         FDL

                         

                        1. Anonymous (login to see details)

                          ok perfect, your welcome !

                          Benoît.

  15. Anonymous (login to see details)

    Hi,

    Because I want to monitor MS-SQL 2008. I need to use this plugin. I have some questions. Please help. 
    Question1: Where to specify the DB login user and password to get more detail information ?
    Question2: I got all null value. Where is wrong ? 

    1. Anonymous (login to see details)

      Hi Max!  Please ensure your collector you are executing with is in the "Performance Monitoring" group in Windows on BOTH the collector server and the MS SQL server.  This plugin does not (and cannot) use a DB user.

      This plugin is in essence an extension of Windows Performance Monitor so if you follow the instructions in that document under "Authentication and Permissions" it should work

      Rick B