Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Storage Resource Monitor (SRM) > Storage Resource Monitor (SRM) Getting Started Guide > PerfStack integration > Use the Performance Analysis dashboard to investigate a performance issue

Use the Performance Analysis dashboard to investigate a performance issue

Table of contents
No headers
Created by Nigel, last modified by Nigel on Mar 14, 2017

Views: 70 Votes: 0 Revisions: 3

In this example you investigate an issue in an environment with SRM and SAM, where an SQL server occasionally goes into critical status.

Use the following metrics from SRM and SAM:

  • Availability: to see when the SQL server goes into a critical state.
  • Average CPU Load and Average Percent Memory Used: to see if system-wide resources are becoming overloaded and causing this issue.
  • I/O Latency Total: to see if high latency on the storage device impacted the SQL server.

File:Success_Center/Reusable_content_-_InfoDev/SRM_6_3/SRM_GSG/SRM-GSG-with-MT-scripts/010/020/srm-gsg-perfstat-0_191x100.png

  1. Click My Dashboard > Home > Performance Availability.
  2. On the Metric Palette, click Add Entities.
  3. Select Type to filter the available entities and select Application.
  4. From the list of applications, select an application. This example selects SQL Server 2012 Reporting Services.

    File:Success_Center/Reusable_content_-_InfoDev/SRM_6_3/SRM_GSG/SRM-GSG-with-MT-scripts/010/020/srm-gsg-perfstat-1_615x236.png

  5. Click Add Selected Items.
  6. The Metric Palette now contains an Application group. Expand this and click the File:Success_Center/Reusable_content_-_InfoDev/SRM_6_3/SRM_GSG/SRM-GSG-with-MT-scripts/010/020/srm-gsg-perfstat-icon.pngicon after the application name. This adds all related entities.

    File:Success_Center/Reusable_content_-_InfoDev/SRM_6_3/SRM_GSG/SRM-GSG-with-MT-scripts/010/020/srm-gsg-perfstat-2_157x196.png

  7. Expand the Node and LUN entities.
  8. Click the application name. The metric groups associated with this entity are shown in the next column.

    File:Success_Center/Reusable_content_-_InfoDev/SRM_6_3/SRM_GSG/SRM-GSG-with-MT-scripts/010/020/srm-gsg-perfstat-4_366x267.png

  9. Expand the metric groups to display the metrics.
  10. Drag the Availability metric into the right side of the view. A chart showing Availability for the last 12 hours is displayed.

    File:Success_Center/Reusable_content_-_InfoDev/SRM_6_3/SRM_GSG/SRM-GSG-with-MT-scripts/010/020/srm-gsg-perfstat-5_566x279.png

  11. Repeat steps 8 to 10 to add the node and LUN metrics.
  12. You can drop node metrics into the same chart to save space.

    You now have a dashboard that shows specific SRM and SAM data for the last 12 hours.

    You can easily see that while Average CPU Load and Average Percentage Memory Used remained stable, the LUN showed high latency at the moment the SQL server became unavailable. This suggests that you should move the database from this LUN to a faster LUN.

    File:Success_Center/Reusable_content_-_InfoDev/SRM_6_3/SRM_GSG/SRM-GSG-with-MT-scripts/010/020/srm-gsg-perfstat-6_651x260.png

    Click Save to save this dashboard. Any dashboard can be shared by its creator. It can then be used as-is or form the basis for future investigation.

 
Last modified

Tags

Classifications

Public