Performance and Tuning: Configuring Adaptive Server Enterprise 15.7 – EDB553

26 STUDENTS ENROLLED

    Performance and Tuning Configuring Adaptive Server Enterprise 15.7

    (EDB553)

    Goals

    • Discuss tradeoffs involved in performance tuning
    • Use sp_sysmon and other utilities to tune the server for performance gains
    • Properly configure memory for optimal performance
    • Manage multiple engines
    • Configure, tune, and size data, procedure, and partitioned caches
    • Identify and correct problems in database physical design, including table partitions
    • Use statistics to manage space on DOL tables and indexes
    • Choose the appropriate table locking scheme for a given application
    • Reconfigure Adaptive Server dynamically
    • Improve performance of tempdb by sizing, placement, and solving locking

    Audience

    • Database Administrators
    • Open Interface Developers

    Prerequisites

    • Fast Track to Adaptive Server Enterprise 15.0/16.0
    • System and Database Administration: Adaptive Server Enterprise or equivalent work experience to Fast Track and System and Database Administration.

    Course Curriculum

    No curriculum found !
    TAKE THIS COURSE

    Recent Posts

    Designed by  © Alliance Softech Pvt Ltd. All rights reserved.
    WhatsApp chat
    X