Icon

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

Icon

NEW PLUGIN AVAILABLE. USE THIS INSTEAD: SQL Server Monitoring Plugin



 

 

 

 

 

 

 

 

 



  1. Anonymous (login to see details)

    FYI.. I have installed, tested, and am currently using the SQL Server Performance Monitor pluggin and dashboard with dynaTrace 5.0.0.

    1. Anonymous (login to see details)

      Hi Where do you pass the credentials?

      1. Anonymous (login to see details)

        Hi Sri,

        The account which is running the collector service needs to have the rights to read the performance counters.

        Chris

    2. Anonymous (login to see details)

      We are getting an error when Importing folder.

      Any Suggestions? Thanks!

      1. Anonymous (login to see details)

        Extract the ZIP file into a folder. When importing it you need to select the first subfolder that is part of the zip file. This contains the actual plugin. The subfolder is called com.dynatrace.diagnostics.plugin.PerfMonSqlServer_3.2.0.0

        1. Anonymous (login to see details)

          Thanks!  Thats what I had done.  I downloaded again and extracted to a differant folder and it imported successfully...

  2. Anonymous (login to see details)

    Some tips to configure this monitor.

    By default the collector under windows runs as Local Service account which doesn't have permissions to access Perf Counters.

    Even adding "Local Service" to the Performance Monitoring Group doesn't help.

    HEnce you have to create a new user or an existing user, add it to the Performance Monitoring Group and then run the monitoring collector with that user.

    Second, the collector on windows might not launch because windows (7) locks down the directories C:\PRogram Files\dynaTrace\. Make sure you are changing the directory permissions to have write access to the user under which the collector is running (osgi / conf) etc.

    1. Anonymous (login to see details)

       

      Second, the collector on windows might not launch because windows (7) locks down the directories C:\PRogram Files\dynaTrace\. Make sure you are changing the directory permissions to have write access to the user under which the collector is running (osgi / conf) etc.

       

      Our admin is saying you cannot change write permissions for anything under Program Files. The installer doesn't launch otherwise. What should we do?

       

  3. Anonymous (login to see details)

    Would be great if we can extract an integer value from the output and put it into a result measure, right now we can only return a failure or success based on pattern match, which is not enough sometimes.

    Thanks,

    Flora

  4. Anonymous (login to see details)

    All,

    I have configured the user and have my collector running with that user. I have launched perfmon from the collector machine using the same user as the collector and on PerfMon I can se the metrics.

    However the monitor keeps telling me it could not find the server. On the monitor I have made sure I have selected the right collector and have made several changes to the how the host is configured in dynaTrace. I have also informed the full IP address of the server with no luck.

    Anything else I should try in order to have this working?

    Regards,

    Igor

  5. Anonymous (login to see details)

    On dT 5.6 while attempting to import this plugin we get the following message: "An error occurred while trying to install the Plugin."  We have attempted on two separate installs, even used a folder that was used to import with 5.5 (which worked in 5.5).

  6. Anonymous (login to see details)

    Is there a way to run this plugin on a Linux collector?  Or does the way the plugin is implemented require it to run on a Windows collector?  We have a customer who wants to put their entire dynaTrace infrastructure on Linux.

    1. Anonymous (login to see details)

      The plugin requires a windows collector becuase it uses windows libraries to query these values

      1. Anonymous (login to see details)

        Hello Andreas,

        Would it be possible to make a new version of the plugin for Linux collector? My customer is very interested in the plugin but we only have Linux collector.

        Thank you for your help

        Regards

        Stephanie.

        1. Anonymous (login to see details)

          This is not that easy because the way the windows performance monitor plugin works relies on being executed on a windows collector

  7. Anonymous (login to see details)

    Is there any update on Curtis Hasting's question with the install error under 5.6

    I am attempting to use it as well and am getting the same error..  "An error occurred while trying to install the Plugin."

    Thanks

    Grant

    1. Anonymous (login to see details)

      Sorry for the late reply on this. I rebuilt the plugin and uploaded the .jar file that you can use with 5.6.

      1. Anonymous (login to see details)

  8. Anonymous (login to see details)

    The instructions say to unarchive the .jar file and then install from folder. However this does not work with the 5.6 version (only one I have tried). You will get an installation error, as the plugin installation process tries to unjar the file, and once unarchived there is no file to unjar, etc.

    I found it worked to just do "Install Plugin" and point directly to the JAR file. 

  9. Anonymous (login to see details)

    Packaging for 5.6+ is a jar file ... are there any updates available for the Dashboard also ?

    1. Anonymous (login to see details)

      Hi. Thanks for pointing out the problem with the installation instructions. I modified the description.

      As for updated dashboards: I haven't updated any of the dashboards. If you have better dashboards that you use for your SQL Server Monitoring let me know and I am happy to upload them to this page

  10. Anonymous (login to see details)

    Hi,

    I got this message when executing Sql Server Performance Monitor. Now I am using version 5.6.0.0. I am not sure if method _Total is valid or not. It seems that all measures involved in this method _Total are unable to get value. Could anyone help on this issue? Thanks.

    SQLServer: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)
    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)
    SQLServer: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: The returned data is valid.
    (System error code: 0x0)
    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: The returned data is valid.
    (System error code: 0x0)
    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)
    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)

     

    Following are the results. It seems that the results are not so reasonable, 0.0 or null. Last run result shows incomplete.

    Access: Full Scans/sec: 0.0
    Access: Page Splits/sec: 0.0
    Buffer: Cache hit ration: 0.0
    Buffer: Checkpoint pages/sec: 0.0
    Buffer: Lazy writes/sec: 0.0
    Buffer: Page life expectancy: 0.0
    Buffer: Page reads/sec: 0.0
    Buffer: Page writes/sec: 0.0
    Committed Bytes In Use: 83.0
    Current Disk Queue Length: 0.0
    Database: Log Cache Hit Ration: null
    Database: Log Flushes/sec: null
    Disk Reads/sec: 0.0
    Disk Writes/sec: 6.0
    Errors: Errors/sec: null
    Free Diskspace: 54940.0
    Free Memory: 938768.0
    Idle Time: 97.547
    Locks: Average Wait Time (ms): null
    Locks: Number of Deadlocks/sec: null
    Locks: Requests/sec: null
    LogicalDisk Free Percentage: 67.06700000000001
    Pages Input: 0.0
    Pages Output: 0.0
    Pages/Sec: 0.0
    PhysicalDisk Read: 546.0
    PhysicalDisk Write: 53518.0

    Transactions: 0.0
    Stats: User Connections: 0.0
    User Time: 1.6440000000000001

    1. Anonymous (login to see details)

      I got the same error message

      doses anyone know why is the error, thanks 

      1. Anonymous (login to see details)

        Hi. This means that these perf counters are not available on this machine. If you install the SQL Server Monitor Plugin all it really does is providing some new default Windows MEtrics for the Windows Performance Monitor plugin. If you setup a new Windows Monitor Plugin these new SQL Server specific MEtrics will automatically show up in the list of metrics you want this monitor to collect. I created this plugin a while ago on a SQL Server Instance that provided these Metrics. It could be that your version of SQL Server doesnt provide these metrics -> maybe they got renamed? -> maybe they are no longer there. What I always do is open the Windows Tool Performance Monitor and do a quick check on the metrics that are available on the SQL Server Machine. If certain metrics have been renamed or are no longer there I just update my dynatrace Windows Performance Monitor and make sure that the names are correctd or that metrics that are no longer available are removed -> you can do this on the MEasure Tab when you edit your Monitor Instance in your System PRofile

        HOpe this helps

  11. Anonymous (login to see details)

    I get the same error as Peter

  12. Anonymous (login to see details)

    We are also seeing the same error as Peter and we are on DT 5.5 connecting to MS SQL 2008 SP1 Express with Advanced Services. We have tried the latest version of the plugin as well, same error. We have verified that the _Total measure can be see in Windows Permon. Running Windows 7. Any thoughts/help would be appreciated. Thanks!

  13. Anonymous (login to see details)

    Does anyone have the dashboard? When i downloaded the file, the dashboard is not included?

    1. Anonymous (login to see details)

      your are right. When I uploaded the 5.x version of the Plugin I only uploaded the plugin but not the dashboard. I will fix this. In the meantime you can download the zip file from one of the previous versions. the zip file includes the dashboard.xml file that you can use

      1. Anonymous (login to see details)

        Awesome, Thanks Andreas!!

  14. Anonymous (login to see details)

    I found the time to repackage the zip file. it now also contains the dashboard. Simply download the zip - extract it. them import the .jar file and then open the dashboard

  15. Anonymous (login to see details)

    Hello, 

    Has anyone deployed the plugin with SQL Server 2012 ? Thanks

    1. Anonymous (login to see details)

      Hi Stephanie,

      Were you able get any information if the plugin works with SQL Server 2012?

      Thanks,

      Kodai

      1. Anonymous (login to see details)

        Hello Kodai,

        Nothing so far

  16. Anonymous (login to see details)

    Hi,

    I am testing the plugin in SQL Server 2012 and it doesn't work. Is there anyone able to make it work?

    Regards.

     

     

    1. Anonymous (login to see details)

      Once the Plug-in is in-place then when you setup the windows performance monitor and you may have to modify the performance object in the measure.  This is also true when monitoring MS SQL instances since the plug-in is using the standard performance objects.

  17. Anonymous (login to see details)

    Would it be technically feasible to make this dynamic on SQL Server instances rather than requiring us to know them ahead of time?  What if there's more than one instance on a server or across the organization?  Each measure in each monitor has to be individually edited to map to that?  There has to be some way to wildcard this right?

    Rick B

    1. Anonymous (login to see details)

      Hi Everyone,

      I went ahead and made a standalone version of this plugin.  When a customer has more than one or two instance names, the method of going in and changing all the metric properties for all the measures of a specific instance of a monitor becomes unmanageable and not worth the effort.  The plugin I've made wraps the Perf Mon plugin and takes the instance name of the SQL Server as a monitor property.  If you would like to help me test this plugin please email me at richard.boyd@dynatrace.com

      Thanks,

      Rick B

  18. Anonymous (login to see details)

    Hello,

    I am getting the below error on running the monitor:

     

    I an on a windows collector and I am able to ping to the Public IP of the target host. Remote registry access is also setup on the collector. Since I am unable to see any system metrics, I am assuming the collector is unable to contact the target host. Can you help me fix it?

  19. Anonymous (login to see details)

    I am experiencing a similar issue  to what Keerti is experiencing.  My team has verifed that we can access the counters on the remote machine using typeperf.  Our collector and the target SQL Server machines are not in a domain (meaning not assigned to a domain), but on the same network.  The collector runs under the same local account as the remote SQL Server, but we are unable to retrieve the metrics.  Does anyone know how to resolve the matter?

  20. Anonymous (login to see details)

    Hi Richard,

    We are also facing the similar issue like keerthi posted. Even we tried to uncheck few measures in the table also. Still we are not getting the values nor the execution

    Could you please help us to resolve this.

    Thanks,

    Aravindhan