6.2. Dashboards

Dashboards are grouping metrics into panels like trendcharts and tables to make the KPI visible. Interconnections between those dashboards makes it easier to navigate and to find the root cause of a problem.

SpeedgainforDatabasesDashboardDb2Latchwait
Figure 12. Speedgain for Databases Dashboard Db2 Latchwait

Speedgain for Databases has the following build-in not changeable dashboards that can be extended via custom dashboards (not all dashboards are visible via menu and can only be accessed through links or the manage dashboard area):

6.2.1. Db2

  • Db2 - Overview

  • Application Details for Handle

  • Application Group List

  • Application List

  • Application Throughput

  • Bufferpools

  • CF Memory Usage (PureScale)

  • CF System Resources (PureScale)

  • Cluster Live (PureScale/DPF)

  • Cluster SQL Statement Analysis (PureScale/DPF)

  • Cluster SQL Statement Single Detail (PureScale/DPF)

  • Cluster Workload (PureScale/DPF)

  • DPF Overview (DPF)

  • HADR

  • Indexes

  • Index Detail

  • Instance Info

  • IO

  • Latchwait

  • Live

  • Lock Events

  • Lock Events - Event Detail

  • Lockwait Inflight

  • Lockwait Inflight - Event Detail

  • Member FCM Throughput (PureScale/DPF)

  • Member IO (PureScale/DPF)

  • Member Page Access (PureScale)

  • Member SQL Statement Analyse (PureScale/DPF)

  • Member Throughput (PureScale/DPF)

  • Member Time Distribution (PureScale/DPF)

  • Memory Pools

  • PureScale Overview (PureScale)

  • Routine Single Detail

  • Routines

  • Size Distribution

  • Sort

  • SQL Statement Analysis

  • SQL Statement ID (aka STMT ID)

  • SQL Statement Single Detail

  • SQL Statements Inflight (aka Inflight SQL Statements)

  • SQL Statements Inflight Single Detail

  • SQL Statements Package Cache (aka SQL Statements)

  • SQL Throughput (aka SQL)

  • System Resources

  • Tables

  • Tables Detail

  • Tablespaces

  • Temp Usage

  • Transaction Log

  • Utilities

  • WLM CPU Velocity

  • WLM Workload

  • Workload

6.2.2. PostgreSQL

  • PG - Overview

  • Application List

  • Application Single Detail

  • Configuration

  • Lockwait

  • SQL Statements

  • SQL Statements Single Detail

  • Tablespaces

  • Workload

  • Write Ahead Log - WAL

6.2.3. SQL Server

  • SQL Server - Overview

  • Activity

  • Backup

  • Blocking Details

  • Blocking Overview

  • Configurations

  • DB - Size|Growth

  • DB - Used Space

  • Index - Missing

  • Index - Missing - Details

  • Index - Unused

  • Index - Usage - Details

  • IO Stats/Database

  • IO Stats/Volume

  • Live

  • Memory

  • Performance Counter Details

  • Query - Details

  • Query - Usage Analysis

  • TempDB

  • Volume Stats

  • Waits

  • Workload Group Statistics

6.2.4. Azure SQL Database

  • Azure SQL Database - Overview

  • Activity

  • Blocking Details

  • Blocking Overview

  • Configuration

  • Consumption

  • Database Size

  • Index Details

  • Index Missing Details

  • Index Missing/Unused

  • Live

  • Memory

  • Performance Counter Details

  • Query Details

  • Query Usage Analysis

  • Waits

6.2.5. Oracle

  • Oracle - Overview

  • Locks

  • OS-Stats

  • Performance Detail

  • Performance Overview

  • Session

  • Session List

  • SGA and PGA Usage

  • SQL Statistics

  • System Time Model Statistics

  • System Waitclasses

  • Tablespace and Datafile Usage

6.2.6. Linux

  • OS - Overview

  • CPU

  • CPU Distribution

  • Disk Throughput

  • Filesystem Usage

  • RAM

  • Workload

6.2.7. Self Monitoring

  • S4DBs Overview

  • S4DBs Alerts

  • S4DBs Collector Status

  • S4DBs Hypertables

← Previous: Collectors | ↑ Up: Collectors and Dashboards | ⌂ Home: Speedgain for Databases | Next: Appendix →