Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Database Performance Analyzer (DPA) > Database Performance Analyzer Getting Started Guide > Investigate performance issues > Add an annotation to document a change to the database

Add an annotation to document a change to the database

Table of contents
No headers
Created by Melanie Boyd, last modified by Melanie Boyd on Sep 29, 2016

Views: 26 Votes: 0 Revisions: 4
DPA_GS_Home.png
video-icon.png
Check out this video (1:19) on using annotations.
 

When you make a change that could affect performance (such as adding an index, tuning a query, or adding resources), you can add an annotation in DPA to show when that change was made. The annotations are displayed on all trend and timeslice charts. By comparing performance data before and after the change, you can see what effect the change had.

  1. From the DPA homepage, click the name of the database instance affected by the change.
  2. Click Annotate in the upper-right corner of the trend chart.
  3. Name the annotation, specify when it was added, and provide details about what change was made and why.

    If your DPA server is in a different time zone, enter the DPA server time.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/060/050/gs-add-annotation.png

  4. Click Save.

    The annotation is displayed as a flag on the chart. Hover over the flag to see a summary, or click it to see details.

Last modified
17:07, 29 Sep 2016

Tags

Classifications

Public