Performance & Tuning using MDA Tables
Description
Goals
- Configure MDA Tables
- Explain the purpose of each MDA table
- Setup a Repository environment for monitoring
- Use MDA Tables to monitor & analyze your ASE environment
- Dignose and troubleshoot your ASE environment
Audience
- Database Administrators, Database Designers, System Administrators
Prerequisites
Essential- Fast Track to Adaptive Server Enterprise (EDB115) or
- Powering Up with ASE 15.0 (EDB366)
- Adaptive Server Enterprise (EDB356)
- Configuring Adaptive Server Enterprise (EDB553)
- ASE Query Optimization (EDB634)
Content
- Introduction to MDA Tables
- Characteristics of MDA Tables
- MDA Tables - Definitions & Usage
- Configuring MDA Tables
- Capturing Data to the MDA Repository
- Monitoring Serv…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Goals
- Configure MDA Tables
- Explain the purpose of each MDA table
- Setup a Repository environment for monitoring
- Use MDA Tables to monitor & analyze your ASE environment
- Dignose and troubleshoot your ASE environment
Audience
- Database Administrators, Database Designers, System Administrators
Prerequisites
Essential- Fast Track to Adaptive Server Enterprise (EDB115) or
- Powering Up with ASE 15.0 (EDB366)
- Adaptive Server Enterprise (EDB356)
- Configuring Adaptive Server Enterprise (EDB553)
- ASE Query Optimization (EDB634)
Content
- Introduction to MDA Tables
- Characteristics of MDA Tables
- MDA Tables - Definitions & Usage
- Configuring MDA Tables
- Capturing Data to the MDA Repository
- Monitoring Server Resources
- Monitoring Application Resources
- Process Level / Fault Isolation Monitoring
Notes
- Learn how to use MDA Tables to monitor and analyze your ASE environment by querying Adaptive Server's MDA tables for statistical & diagnostic information. You will configure MDA Tables and gain hands-on labs experience that will lead you through common scenarios of database performance and tuning, analysis and troubleshooting.
- At the conclusion of this course, you will take away scripts, procedures and ideas to execute newly acquired performance tuning techniques and analysis in your own environment
Popular tags
No tags submitted for this course yet
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.