Troubleshooting Issues and Measuring Performance
Goals
- Troubleshoot issues due to data structure changes.
- Use common techniques for query optimization.
- Monitor database performance.
- Explain access and permissions.
- Describe database backups.
Managing Changes to Data, Databases, and Software
- Developing a Change Management Process
- Designing for Data Integrity
- Data Validation
- Troubleshooting Filtered Data
- Common Database Issues
- Addressing Database Issues Through Testing
- Data Health Checks
- Data Refresh Cycles and Archiving
Use Common Techniques for Query Optimization
- Query Optimization
- Filtering with Parameters
- Indexing Data
- Temporary Tables
- Subquerying and Subsets of Information
Monitor Database Performance
- Resolving Table Locks
- Data Corruption
- Database Slowdowns and Refresh Issues
- first thing to do is report the slowdown (submit ticket)
- check the refresh logs
- check monitoring logs
- Database Performance Tuning
- Enable Database Logging and Monitoring Alerts