solarwinds Smart Start Self-Led Project Plan for Database Performance Analyzer Instruction Manual
- June 12, 2024
- solarwinds
Table of Contents
**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