Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Training > Free SolarWinds Training Videos - DPA > How to use annotations in DPA - Video

How to use annotations in DPA - Video

Updated 8-11-2016


This video demonstrates how to use annotations, a feature of Database Performance Analyzer.




  • Database Performance Analyzer

Video Transcription

Annotations are useful to document important events inside your dynamic database environment. SolarWinds® Database Performance Analyzer (DPA for short) has an easy-to-use annotation feature that can be used to mark when changes to a database were made, such as tuning queries, or adding indexes.


These annotations will show on charts and can be helpful in tracking their effects on a database system.
To annotate an event, all you have to do is click the Annotate button on the right side of the DPA interface.
This opens a dialog box. You can name the annotation, its occurrence, date and time, details, and who created the annotation. Click Save.
DPA will display the event on any trend or time slice view as a flag. You can hover over the flag to see the basis for the annotation, or click on it to see more details or edit the annotation.
From the details screen, you can also delete an annotation.
Now you have a way to share information about events in your environment. After all, if performance profiles change, the first thing everyone will ask is, “Well, what changed?”
For more information about how to get the most out of Database Performance Analyzer, visit


Last modified