SolarWinds DPA has many standard reports that include the most commonly used wait time statistics. You can customize the reports to see more detailed trends in your databases. Available reports include:
This report shows the top five SQL statements ranked by total wait time across a custom interval. You can change the report to display the top 10 or select specific SQL statements from the SQL Statements tab on the Report Properties dialog. The report will show a descriptive name for the SQL if it has been defined.
Top Waits for single SQL
This report identifies the top wait events (up to 50), ranked by wait time, for a specific SQL statement.
Top SQLs for single Wait
This report identifies the top SQL statements for a single database wait.
Typical Day of Wait
This report displays a bar graph showing the average hourly wait time for a database. It displays the distribution of average wait time versus time of day.
Typical Day of Wait for single SQL
This report displays a stacked graph showing average hourly wait time for the top waits contributing to the total wait time for an individual SQL statement. The top of the bar is the sum of all other waits. This report can identify the peak loads during your business hours based on long-term observation of the system.
This report charts waits for an entire database. SolarWinds DPA displays the waits with the highest accumulated wait time.
This report displays the total accumulated wait time for programs.
This report displays the busiest files ranked by total I/O wait time. SolarWinds DPA calculates the total wait time for all I/O operations on each file for selected intervals.