Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed
Roger Cornejo
224 pages, parution le 06/12/2018
Résumé
This book briefly reviews past and present practices, along with available tools, to help you recognize areas where improvements can be made. The book then guides you through a step-by-step method that can be used to take advantage of all available metrics to identify problem areas and work toward improving them. The method presented simplifies the tuning process and solves the problem of metric overload.
You will learn how to: collect and normalize data, generate deltas that are useful in performing statistical analysis, create and use a taxonomy to enhance your understanding of problem performance areas in your database and its applications, and create a root cause analysis report that enables understanding of a specific performance problem and its likely solutions.
What You'll Learn
- Collect and prepare metrics for analysis from a wide array of sources
- Apply statistical techniques to select relevant metrics
- Create a taxonomy to provide additional insight into problem areas
- Provide a metrics-based root cause analysis regarding the performance issue
- Generate an actionable tuning plan prioritized according to problem areas
- Monitor performance using database-specific normal ranges
Who This Book Is For
Professional tuners: responsible for maintaining the efficient operation of large-scale databases who wish to focus on analysis, who want to expand their repertoire to include a big data methodology and use metrics without being overwhelmed, who desire to provide accurate root cause analysis and avoid the cyclical fix-test cycles that are inevitable when speculation is used
Part II. Dynamic Performance Analytics 2. Gathering Problem Information3. Data Preparation4. Statistical Analysis5. Feature Selection6. Taxonomy7. Reporting and Running the Code
Part III. Case Studies 8. TBD9. TBD10. TBD
Part IV. Case Studies and Further Applications 11. Monitoring12. Further Enhancements and Uses
Part V. Appendixes A. SQL Query Toolbox
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Apress |
| Auteur(s) | Roger Cornejo |
| Parution | 06/12/2018 |
| Nb. de pages | 224 |
| EAN13 | 9781484241363 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
