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

    About The SkillPedia

    The Skill Pedia is a platform for online training. It offers great learning experience for learners by offering features such as Interactive Videos, Interaction with Trainer, Assignments, Rich Audio Visuals and Handouts.

    The Course Completion Certificate generated automatically based on your performance after the course is complete is an edge.

    For Trainers, it is a platform for sharing your Skills which may be in the form of videos, slides, handouts, e-books or even consulting and get up to 85% of the fee you decide for the course.

    The Skill Pedia - Learn or Teach a Skill

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