Options

Performance issues since upgrade to 5.2.3

Luke LLuke L Posts: 43 Bronze 3
edited August 11, 2016 3:06PM in SQL Monitor Previous Versions
We upgraded from 5.0 to 5.2.3 (5.2.3.3831) in June. Since then we've seen a dramatic performance drop with regards to the alerts and website performance. The Analysis graphs are also very slow and at times not functional at all... (at time it takes 30-60 seconds to load the list of instances when I click on one of my cluster nodes in order to drill into a specific disk, database etc.

I read through the release notes in the 5.2.4-5.2.6 release notes and I don't see any changes to correct these performance deficiencies...
Please let me know if you have any suggestions.
Thanks,
-Luke.


We are monitoring 26 servers. Number of alerts = 133810

Other posts about performance issues request some initial information about our environment... Here is the output of the Global Overview Performance Diagnostics..

Internal Diagnostics

PriorityCumulativeFires 156600
PriorityCumulativeMisfires 9
DataCollectionCumulativeFires 7358249
DataCollectionCumulativeMisfires 642


Watchdog

The URL /watchdog will return the text string 'OK' if at least one machine is being monitored successfully.

URL Diagnostics

URL Time (ms) No. Requests Average Min Max Total Success Error

/ 8.50 2 26 10 10 0
/GlobalOverview/GlobalData 5532.10 3112 8941 10 10 0
/AlertInbox/AlertsData 1041.20 770 1429 10 10 0
/Alerts/Inbox 109.20 25 547 10 10 0
/AlertInbox/ChannelsData 5617.00 4347 8235 10 10 0
/AlertInbox/ListFilterSettings 20.00 12 49 10 10 0
/ConfigureLicensing/GetData 42.90 29 146 10 10 0
/static/5.2.3.3831/Scripts/RedGate.Response.js 17.00 11 27 10 10 0
/Configuration 25.20 11 106 10 10 0
/Diagnostics/BaseMonitorNoOp 10.70 5 25 10 10 0
/Diagnostics/RepositoryNoOp 11.40 6 26 10 10 0
· Share on Twitter

Comments

  • Options
    Luke LLuke L Posts: 43 Bronze 3
    For those reading this, we upgraded to 5.2.7 and performance is significantly better.
    Thanks,
    -Luke.
    · Share on Twitter
  • Options
    Luke LLuke L Posts: 43 Bronze 3
    I reviewed our SQL monitor instance again and it seems like there was some improvements, however the analysis section is still slower than it was in 5.1.

    the metric selection prompts do not appear to be displaying properly. At times they are very sluggish and sometimes will not populate at all. this is with I.E. When using Chrome everythign is even slower and the metric selection boxes rarely populate correctly.

    This is particularly bad when reviewing Database metrics on a Clustered instance. for example, I perform the following...
    Click the Analysis tab, wait 2 seconds.
    Choose the Database|Total size metric.
    Choose a Cluster. Wait a second (or sometimes more).
    Select an instance name. wait 5 seconds and the database list loads. I am able to move around between various databases and performance is as expected.
    If I select another instance on the same cluster I wait 30+ seconds for the database list to load.

    The experience drawing the graphs etc seems to be faster but the prompts to get me there seem to not function as well as they used to.

    I did not have these kind of issues when using this product in the 5.0 or 5.1 versions.

    Does anyone have any ideas on places to look for configuration changes etc to make this product run faster?

    Here are the performance metrics from the diagnostics page since we upgraded to 5.2.7 - we are receiving errors from the /GlobalOverview/GlobalData check which we did not receive before.

    Internal Diagnostics
    PriorityCumulativeFires 4670
    PriorityCumulativeMisfires 3
    DataCollectionCumulativeFires 220078
    DataCollectionCumulativeMisfires 278

    URL Diagnostics

    URL Time (ms) No. Requests Average Min Max Total Success Error
    / 4.00 2 9 10 10 0
    /GlobalOverview/GlobalData 0.00 Infinity -Infinity 10 0 10
    /AlertInbox/AlertsData 338.70 283 405 10 10 0
    /Alerts/Inbox 31.10 24 57 10 10 0
    /AlertInbox/ChannelsData 3194.30 2654 3455 10 10 0
    /AlertInbox/ListFilterSettings 24.90 11 67 10 10 0
    /ConfigureLicensing/GetData 33.90 27 67 10 10 0
    /static/5.2.7.4854/Scripts/RedGate.Response.js 48.60 11 323 10 10 0
    /Configuration 15.70 10 42 10 10 0
    /Diagnostics/BaseMonitorNoOp 6.50 4 9 10 10 0
    /Diagnostics/RepositoryNoOp 7.50 5 12 10 10 0


    Thanks,
    -Luke.
    · Share on Twitter
Sign In or Register to comment.