Performance and Tuning Adaptive Server Enterprise 16.0 Query Optimization EDB634

18 STUDENTS ENROLLED

    Performance and Tuning Adaptive Server Enterprise 16.0 Query Optimization EDB634

    Course Overview

    In this course, you will learn how to measure the performance of T-SQL queries and tune your query development for the specific requirements of your business. Take advantage of the monitoring and evaluation ASE tools, and interpret their diagnoses into specific plans of action.

    This course is based on software release SAP ASE 16.0. SP 3

    Advertisements

    Who Needs To Attend

    • Developers
    • Developer consultants

    Course Details

    Topics Include

    • Optimization tools and their use
    • Steps involved in executing code from input to return of result set
    • Use code to pass hints to the Optimizer
    • Perform tasks to evaluate the behavior of the optimizer
    • Implement the most efficient data-change and data-retrieval T-SQL code in your queries and stored procedures
    • Force optimization steps on the Optimizer

    Course Curriculum

    Principles of Performance Tuning
    SAP-QP 1 Defining Performance and Tuning Terms Details 00:45:00
    In this lesson, you will learn about performance measurement, and tuning methodology.
    SAP-QP Lab 1. Examine Key Environment Variables in an SAP Adaptive Server Enterprise 10, 00:00
    Query Performance and Execution
    SAP-QP 2. Query Processing and Execution Details 01:00:00
    You will learn about the flow of information from the client to the server, the adaptive server memory, and using the server. You will also learn about query scheduling, engines, time slices, and basic SAP Adaptive Server Enterprise (SAP ASE) multitasking
    TheTuningToolbox
    SAP-QP 3.1. Using Diagnostic Tools for Tuning Details 00:00:00
    Using Diagnostic Tools for Tuning
    SAP-QP 3.2. UsingNon-SessionToolsforTuning Details 00:00:00
    SAP-QP 3.3. Using Syntax Commands for Tuning Details 00:00:00
    Table Structures
    SAP-QP 4.1. Identifying Table Structures Details 00:00:00
    In this lesson, you will learn about table structure. You will also learn how the execution engine accesses tables
    SAP-QP 4.2. Partitioning Tables Details 00:00:00
    In this lesson, you will learn how to identify types of table partitioning and how the execution engine accesses partitioned tables. You will also learn how to define partitioned tables.
    TAKE THIS COURSE

    Recent Posts

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