Loading demo links...
What to study for each DATABASE-MANAGEMENT domain
Available Monitoring Tools from SolarWinds
Introduces the SolarWinds database monitoring portfolio in scope for this exam: Database Performance Analyzer (DPA), SQL Sentry, and Database Observability (DBO). It covers what each tool is for and how to choose the right tool for wait-based analysis, SQL Server monitoring, or cloud-delivered observability.
Key skills
Identifying DPA, SQL Sentry, and Database Observability, describing each tool's purpose, and matching a monitoring need to the appropriate SolarWinds tool.
Architecture, Installation, and Licensing
Covers the architecture and components of DPA, SQL Sentry, and Database Observability, including servers, monitoring services, clients, and repository databases. It also covers installation requirements and planning, instance registration, and how DPA licence types compare with the SQL Sentry licensing structure.
Key skills
Explaining DPA, SQL Sentry, and DBO components and data flow, planning an installation against system requirements, registering monitored instances, and comparing DPA and SQL Sentry licensing.
Navigating the Monitoring Tools
Covers working in the interfaces and utilities of DPA, Database Observability, and SQL Sentry to access monitoring features. It includes DPA trends and Top SQL, the SQL Sentry Navigator, Data Grid, and Performance Analysis views, and finding and opening query detail in Database Observability.
Key skills
Navigating the DPA web client, SQL Sentry client, and DBO interface, using trends, Top SQL, and the Data Grid, and drilling from summaries into query-level detail.
Alerts and Reports
Covers alert categories and types across the database monitoring tools and how to configure alerts so the right people are notified when a condition occurs. It also covers configuring and running reports from SQL Sentry and DPA, including scheduling recurring performance summaries.
Key skills
Configuring alert conditions, categories, and notification actions, tuning thresholds to avoid alert noise, and configuring, running, and scheduling reports in DPA and SQL Sentry.
Users and Groups Overview
Covers creating and organising users in the DPA web client and the SQL Sentry client, including contacts and groups used for notifications. It also covers custom privileges so users receive only the access appropriate to their role.
Key skills
Creating and organising users and groups in DPA and SQL Sentry, managing notification contacts, and assigning custom, least-privilege access.
Using SolarWinds Database Monitoring Tools and Troubleshooting Methodologies
Covers applying the tools to real problems: troubleshooting troublesome queries, historical and real-time investigation, and reviewing health status and alerts. It includes Find SQL filters in DPA, Data Grid filtering and Top SQL in SQL Sentry, and query investigation in Database Observability, following a wait-based troubleshooting methodology.
Key skills
Investigating slow and blocking queries with wait analysis, using Find SQL and Data Grid filters, working Top SQL, and performing query investigation in Database Observability.