solarwinds Smart Start Self-Led Project Plan for Database Performance Analyzer Instruction Manual

**solarwinds Smart Start Self-Led Project Plan for Database Performance Analyzer Instruction Manual

**

Smart Start Self-Led Project Plan for Database Performance Analyze

INSTALLATION

Confirming installation for DPA
Documentation

INTRODUCTIONS AND APP CONFIGURATION

Requirements/configuration
Ensure system requirements/configuration matches for monitored spec.

• Documentation
• Documentation
• Documentation

Licensing
Documentation

Configure email/LDAP/SSL (optional)
Please review how to configure email/LDAP/SSL.

Documentation

Create user accounts for DPA web console usage/administration
Teach how to create user accounts for DPA web console usage/administration.

• Documentation
• Documentation

NAVIGATING DPA

Features of DPA
Demonstrate how to use features of DPA to identify and troubleshoot performance issues.

• Discuss wait time analysis:
  Documentation

• Main dashboard/home page:

• Drilling into an “hour” to see more dimensions:

• Looking at correlation tabs like blocking:
  Documentation

• Resources tab:
  Documentation

• Storage IO tab:

• Query advisor:
  Documentation

• Table tuning:
  Documentation

• Current view:

• Virtualization tab:
  Documentation

• Renaming hash:
  Documentation

• Removing hash from trends view

• Query analysis page (QPA):
  Documentation

• Options:
  Documentation

REPORTS AND ALERTS

Configure wait time alert
Review how to create a wait time alert example.
Documentation

Configure resource alerts
Review how to configure resource alerts.
Documentation

Configure administrative alerts
How to configure administrative alerts.
Documentation

Configure custom SQL alert
How to configure a custom SQL alert.
Documentation

DPA reports
Discuss DPA reports.
Documentation

DPA custom metrics

INTEGRATE WITH THE ORION®

PLATFORM

Orion Platform environment
Documentation
Documentation

Performance analysis reports
Create performance analysis reports.
Documentation

Read User Manual Online (PDF format)

Read User Manual Online (PDF format)  >>

Download This Manual (PDF format)

Download this manual  >>