Performance & Tuning using MDA Tables

Product type
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

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…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Data Warehouse, Oracle 10G, Oracle, Business Intelligence (BI), and Microsoft SQL Server.

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

There are no reviews 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.