Performance & Tuning Development Training Publications Seminars Company
 
Performance and Tuning for Sybase
Length: 5 Days
Prerequisites: Introduction To SQL, Introduction To Adaptive Server
Key Benefits:
  • Learn How To Analyze and Solve Subtle Performance Problems
  • Leave Ready to Work with a Performance Team
  • Sybase Internals Examined
    • Other Features:
    • A Comprehensive Course Notebook
  • How-To? And What-If? Sessions
  • A Hands-On Instructor Experienced In Adaptive Server Performance and Tuning

    •  
    Description:

    To get the best performance from a high-performance vehicle, you’ll likely need to tune the engine and application. Before you can begin tuning a high-performance engine, you need to understand its internals and how they work, what to tune and when to tune it. This course teaches students how Adaptive Server, a high-performance engine, works. Topics cover when and what to tune to achieve the best database performance. Our instructors are also consultants, They understand the business issues of maintaining and maximizing performance for a mission critical database system.

     
    Topics Covered:
     
    • Introduction to Tuning
      Defining Performance, RDBMS, Setting Expectations, Concurrency, Defining and Tracking Down Bottlenecks, Tuning
  • Physical Issues
    Normalization, Performance and Tuning Issues in Converting a Logical Design to a Physical Design, Tuning Through Denormalization, Design Tradeoffs, Views
  • Physical Storage Structures
     Allocation Pages and Object Allocation Map, Data Pages, Text and Image Pages, Indexes and the B-Tree Structure, Updates and Performance, Using Segments, Table Partitioning, VLDB Design Issues: Performance, Recovery, Physical Resource Dissemination
     
  • Physical Design
    Storage Structures, Space Allocation,
    Page Utilization, Determining Table Size, Page Splitting, Object Placement and Segments,
    Heap Table Partitioning
     
  • Designing Indexes for Performance
     Why Use Indexes? Indexes and Performance, Index Selection, Clustered, Non-clustered, Evaluating Index Usefulness, Index Design Guidelines
     
  • Techniques For Determining Query Paths
    Basic Analysis And Optimization, Showplan,
    Statistics IO And Time, Analyzing Query Optimization, Analyzing 301/310 Ouput
  • tempdb Performance
    Alternative Storage Devices, Named Cache For Tempdb, Locking And Tempdb, Cursor Performance, Replacing Cursors
  • Index Selection
    Clustered, Nonclustered Index, Indexing for Multiple Queries, Ors. Index Covering, Index Statistics, Understanding the Distribution Page, Index Design Guidelines
     
  • Optdiag Programming
    What optdiag does, tables That Store Statistics, Viewing Statistics, Histogram Displays, Changing Statistics, Editing Histogrmas, Simulated Statistics, Effects of SQL Statements on Statistics
     
  • Cache Strategies
    Named Caches, Buffer Pools, User Log Cache, Log I/O size, Fetch Strategies, Metadata Cache, Guidelines for Cache Configuration, Metadata Cache
  • Understanding the Query Optimizer
    Optimization Steps, Reading Query Plans, Overriding the Optimizer, Review Optimization Methods, DBCC trace flag Usage, Understanding DBCC Output
  • Parallel Query Processing
     What is Parallel Query Processing? Configuring Parallel Query Processing, Impacts of Parallel Query Processing, Parallel Query Optimization, Parallel Sorting
  • Locking
    Consistency Levels, Lock Isolation Levels, Lock Granularity, Types of Page Locks, Data Locking Mechanisms: Allpages, Datapages, Datarows, max_row_per_page
  • Deadlock Detection and Avoidance
    Understanding Deadlocks, Gathering Deadlock Information, Learn How to Analyze Data, Deadlock Avoidance, Deadlock Phases, Deadlock Output
    • Configuration Issues
       Tuning Memory and Data Cache, Sizing Procedure Cache, Network Packet Size, Speeding Up Index Creation, SMP Architecture
    • Performance Metrics
      What Needs to be Measured,. Set Of Performance Metrics for a Specific Platform, Performance Monitoring Tools
    • Configuration
      Tuning Memory and Data Cache, Sizing Procedure Cache, Network Packet Size, Speeding up Index Creation, SMP Architecture
    • Tuning Auditing System
    • Abstract Query, BCP, Execution Priority, DBCC
       
    • What Abstract Plans Are
       Relationship between query text and query plans, Full vs. Partial plans, How abstract plans are associated with queries, Managing abstract plans

    Join us at These Events

    SQL Saturday Logo
    When: Oct 25, 2008
    Where: Orlando FL

    Peoplesoft Tuning Guide

    Dynamic Scripting

    Search for Talent.

    Presentations

    Seminars 
     
     
    ©Soaring Eagle 2006