Advanced Performance: Monitoring Tables Facility

Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Available server monitoring tools typically generate reports that are server wide: you can’t easily focus on a particular database, process, or table; and monitoring tools can be expensive. You can build performance enhancement tools for your Adaptive Server Enterprise 12.5.3 and later servers, that allow you to focus on the specifics of your particular environment - database, process, object. You’ll be able to to pinpoint factors adversely affecting performance, such as: obsolete indexes, "expensive" queries, trace unexpected error conditions in stored procedures, and document cache specific "Hit Ratios".

Learn to quickly design a low cost, effective, self-monitoring facility based on the newly available Monitoring Tables. This course also discusses a number of "procs" used to generate useful performance and productivity reports from utilization data recorded in the Monitoring Tables. Sample monitoring stored procedures are included.

Existing server monitoring tools, such as Adaptive Server Enterprise Monitor typically require significant resources to develop, support/administer, and depend on a skill set that is very different to the traditional DBA/T-SQL expertise. Alternative Monitoring Systems, based on the new Monitoring Tables functionality, provide a high performance, extensible application infrastructure, with a low overhead. Importantly, the level of information delivered is comparable to that of Monitor Server. However, there are no extra servers or components to administer - and the Monitoring facility is always available. At the same time, Monitoring Facility development is easily accomplished, using the familiar DBA/T-SQL skill set. This results in shorter learning time; while the monitoring data itself is easier to collect, store and query than with other environments.


Who Should Attend
DataBase Administrators
Developers
Performance and Tuning Specialists
System Architects


Topics
Understanding Monitoring Tables
Installing the Monitoring Tables
Configuring ASE to enable the Acquisition of Monitoring Data
Administering the Monitoring Environment
Using the New "mon_role" for Access to the Monitoring Tables
Implementing Native RPC and CIS Proxy Tables
Where to Start
Useful Stored Procedures
Do’s and Don’ts of Using Monitoring Tables
Troubleshooting the Monitoring Environment



Prerequisites
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise 12.5
Performance and Tuning: Configuring Adaptive Server Enterprise



...''

Phone:1-800-8-SYBASE (800-879-2273)

School Address:

14800 Quorum
Suite 505
Dallas, Texas 75240
United States

8755 West Higgins Road
Suite 1100
Chicago, IL 60631

The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036

Rock Spring Plaza
6550 Rock Spring Drive, Suite 700
Bethesda, Maryland

561 Virginia Rd.
Concord, MA 01742
(978) 287-1500

3820 Mansell Road
Suite 100
Alpharetta , GA 30022

19900 MacArthur Boulevard
Suite 510
Irvine, CA 92612

Jobs & Resumes: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Houses & Roommates: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.

Powering Up with Adaptive Server Enterprise 12.5
Powering Up with ASE 12.5.2
Managing and Tuning tempdb
Using Abstract Query Plans
Dynamic Reconfiguration for Managing Memory Nonstop Optimal Performance
Interpreting the Major ASE System Tables
Implementing ASE Replicator
Unix to Linux Migration for Adaptive Server Enterprise
Administering Sybase IQ for the Data Warehouse
Interpreting SP_SYSMON
Fooling, Cheating, Lying and Understanding the Optimizer
Open Client Programming Using Client-Library
Open Server Programming
Understanding Indexes
Harness the Power with Configurable Parameters
Using SybMigrate
Powering Up to ASE Interim Releases
Introduction to SQL Expert
Behind the Scenes with DBCC Commands

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.