Banner Banner Banner Banner Banner Banner Banner Banner Banner

SQL Server Performance & Tuning Course

Performance & Tuning

  • Sizing & Planning
  • Monitoring Performance
  • Analyzing Performance Data
  • Tuning & Optimising Performance

    SQL Server Internals

  • Windows & SQL Server Architecture
  • Process & Thread management
  • Memory Use & Management
  • I/O Management
  • Networking

    SQL Server Architecture

  • Data Storage
  • Transaction Logging
  • Locking
  • Indexing
  • OLTP databases
  • Data Warehouses

    Planning A SQL Server Database Application

  • Capacity Planning
  • Sizing Databases
  • Sizing Servers

    System Performance & Tuning

  • Hardware Resource Tuning
  • I/O Performance
  • Database Layout
  • SQL Server Configuration Options

    Monitoring Tools

  • Performance Monitor
  • SQL Profiler
  • DBCC

    Optimal Database Design

  • Database Design
  • Table Design
  • Indexes
  • OLTP databases
  • Data Warehouses

    Index Optimisation

  • Index Types
  • Covering Indexes
  • Index Strategies

    Locking

  • Lock Types
  • Locking & Granularity
  • Blocking
  • Locking & Transactions
  • Transaction Isolation Levels
  • Transaction Design
  • Analysing Locks

    Query Optimisation

  • Query Optimiser
  • Recompilation
  • Query Cache
  • Query Types
  • Range
  • Ordering
  • Grouping
  • Table joins & Join Algorithms

    Analyzing Queries

  • Query Analyser & Execution Plans
  • SHOWPLAN
  • Graphical
  • Index Statistics
  • Index Tuning Wizard

    Tuning SQL Statements

  • Comparing Queries
  • Avoiding Subqueries
  • Table Hints

    Database Application Tuning

  • Using Stored Procedures & User Defined Functions
  • Views
  • Partitioning Data
  • Derived Data
  • Minimising Redundant Data With Triggers
  • Optimising Transactions
  • Optimising Cursors

    Tuning SQL Server Services & Tasks

  • Replication Services
  • DTS Packages
  • Backup & Recovery