A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2289) Deploying Business Desktops with Microsoft Windows XP and Microsoft Office 2003 - Microsoft Training Courses in London and South West
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Course:(2030) Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2071) Querying Microsoft SQL Server 2000 with Transact-SQL. - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(2074) Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2014) Customizing Microsoft Office SharePoint Portal Server 2003 - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(6438) Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2554) Designing, Planning, and Managing a Windows SharePoint Services and SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2013) Optimizing Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(1140) Microsoft SQL Server 7.0 Overview - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(2264) Exam Preparation for the MCDST Certification - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates



Exclusive
SQL Server

Optimizing Microsoft SQL Server 7.0
(Microsoft Training Course: 2013) - 3 days - £1700 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course provides students with the knowledge and skills necessary to optimize the Microsoft SQL Server version 7.0 environment, write efficient queries, and design enterprise client applications. It is intended for those who have considerable experience with SQL Server and want to optimize the product for the enterprise environment.
> Course outline
  1. Overview of Enterprise Performance Issues
  2. SQL Server Architecture and Monitoring
  3. Physical Database Structures
  4. Designing a SQL Server Environment
  5. Introduction to Optimizing Queries
  6. Index Strategies
  7. Analyzing Queries
  8. Integrating SQL Server in an Enterprise Solution

Supplementary Information This course has now retired and is no longer available. We suggest you look at Course 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005.
Module 1: Overview of Enterprise Performance Issues
  • Performance Monitoring and Tuning Methodology
  • Strategies for Tuning Performance
  • Developing a Performance Tuning Methodology
  • Establishing a Performance Baseline
  • Detecting Performance Problems
  • Performance Monitoring Tools
  • Load Simulation Tools
Skills
  • Identify performance goals.
  • Identify factors that affect performance.
  • Develop a performance monitoring and tuning methodology.
  • Describe the tools available for monitoring performance.
  • Describe the tools available for simulating loads.
top
Module 2: SQL Server Architecture and Monitoring
  • Client-Server Components
  • Client-Server Communication Process
  • Relational Engine Components
  • Storage Engine Components
  • Introduction to Thread Architecture
  • How SQL Server Uses Threads and Processors
  • Modifying Default Values That Affect Threads and Processors
  • Monitoring Thread and Processor Use
  • Memory Architecture and Monitoring
  • How SQL Server Uses Virtual Memory
  • Modifying Default Values That Affect Memory
  • Monitoring Memory Use
  • Hard Disk Input/Output (I/O) Architecture and Monitoring
  • How the Buffer Manager Uses the Buffer Cache
  • Modifying Default Values That Affect Hard Disk I/O
  • Optimizing the Network for SQL Server
  • Lab: Monitoring SQL Server Performance
Skills
  • Describe the components of SQL Server that are involved in client-server communication.
  • Describe the client-server communication process involved in submitting and processing a query.
  • Describe the relational engine of SQL Server and how it enhances server performance and self-tuning.
  • Describe the storage engine of SQL Server and how it enhances server performance and self-tuning.
  • Describe the thread architecture that SQL Server uses and be able to modify and monitor processor use.
  • Describe the memory architecture that SQL Server uses and be able to modify and monitor memory use.
  • Describe the hard disk input/output (I/O) architecture that SQL Server uses and be able to modify and monitor hard disk I/O use.
  • Describe how to optimize the network for SQL Server.
top
Module 3: Physical Database Structures
  • Introduction to Data Structures
  • Using Allocation Pages
  • IAM Pages Track Object Placement
  • Introduction to Data Page Components
  • How SQL Server Organizes text, ntext, and image Data
  • How SQL Server Retrieves Stored Data
  • How SQL Server Uses the sysindexes Table
  • Finding Rows
  • Choosing the Appropriate Clustered Index
  • Modifying Data
  • Updating Data
  • Lab: Estimating the Size of Tables and Indexes
Skills
  • Describe the physical database structures created with SQL Server.
  • Explain how data is organized on pages in SQL Server.
  • Describe how SQL Server retrieves stored data and uses indexes.
  • Describe how adding, updating, and deleting data physically affects SQL Server tables.
top
Module 4: Designing a SQL Server Environment
  • Growing Data and Log Files Automatically
  • Designing a Disk System by Using RAID
  • Introduction to RAID
  • Comparing RAID Levels
  • Hardware Versus Software Solutions
  • Factors That Influence I/O Performance
  • Estimating Disk Subsystem Performance
  • Monitoring Disk Activity
  • Designing a Disk System by Using Filegroups
  • Introduction to Filegroups
  • Using Filegroups for Performance
  • Using Filegroups for Maintenance
  • Guidelines for Creating Filegroups
  • Distributing Data Across Disks by Using Filegroups
  • Separating Tables and Indexes for Performance
  • Combining Filegroups with Hardware RAID
  • Preparing for System Failure by Using SQL Server Failover Clustering
  • Introduction to Clustering
  • Benefits of Windows Clustering
  • Active/Passive Failover Clustering Configuration
  • Active/Active Failover Clustering Configuration
  • Preventing Data Loss by Using a Standby Server
  • Setting Up and Maintaining a Standby Server Manually
  • How Log Shipping Works
  • Setting Up a Standby Server to Use Log Shipping
  • Replacing the Primary Server
  • Restoring the Primary Server
  • Lab: Automating the Maintenance of a Standby Server.
Skills
  • Manage database and log file growth.
  • Use RAID to improve SQL Server 7.0 performance and availability.
  • Use filegroups to improve performance.
  • Describe the benefits of using SQL Server Failover Clustering.
  • Use a standby server solution to prevent data loss.
top
Module 5: Introduction to Optimizing Queries
  • Introduction to the Query Optimizer
  • How the Query Optimizer Uses Cost-Based Optimization
  • How the Query Optimizer Works
  • Query Optimization Phases
  • Caching Query Plan
  • Setting a Cost Limit
  • Obtaining Query Plan Information
  • Querying the sysindexes Table
  • Viewing STATISTICS Statements Output
  • Viewing SHOWPLAN_ALL and SHOWPLAN_TEXT Output
  • Viewing Graphical Showplan
  • Elements of Graphical Showplan
  • Reading Graphical Query Plan Output
  • Indexing Fundamentals
  • Understanding the Data
  • Limiting a Search
  • Determining Selectivity
  • Determining Density
  • Determining Distribution of Data
  • Introduction to Statistics
  • Updating Statistics
  • Viewing Statistics
  • Lab: Obtaining Index Information
  • Lab: Viewing Index Statistics
Skills
  • Explain the role of the query optimizer and how it works to ensure that queries are optimized.
  • Use various methods for obtaining query plan information so that they can determine how the query optimizer processed a query and validate that the most efficient query plan was generated.
  • Implement indexing strategies to reduce page reads and design indexes that can benefit from how the query optimizer processes queries.
  • Understand how statistics are created, stored, maintained, and used by the query optimizer to optimize queries.
top
Module 6: Index Strategies
  • Accessing Data
  • Table Scans and Indexes
  • Index Architecture and Navigation
  • Using Row Identifiers to Access Data
  • Using an Index to Cover a Query
  • Introduction to Indexes That Cover a Query
  • Locating Data by Using Indexes That Cover a Query
  • Example of Single Page Navigation
  • Example of Partial Scan Navigation
  • Example of Full Scan Navigation
  • Identifying Whether an Index Can Be Used to Cover a Query
  • Determining Whether an Index Is Used to Cover a Query
  • Guidelines to Creating Indexes That Can Cover a Query
  • Using Index Tuning Tools to Improve Query Performance
  • Indexing Strategies
  • Evaluating I/O for Queries That Access a Range of Data
  • Indexing for Multiple Queries
  • Guidelines for Creating Indexes
  • Lab: Analyzing How Queries Are Covered by Different Types of Indexes
Skills
  • Explain the various ways that SQL Server can access data.
  • Create indexes that cover queries.
  • Use indexing tools to create useful indexes and to analyze a given query or batch.
  • Identify indexing strategies that reduce page reads.
top
Module 7: Analyzing Queries
  • Queries That Use the AND Operator
  • Queries That Use the OR Operator
  • Queries That Use Join Operations
  • Selectivity and Density of a Join Clause
  • How Joins Are Processed
  • How Nested Loop Joins Are Processed
  • Multimedia: How Merge Joins Are Processed
  • Considerations When Merge Join Is Used
  • How Hash Joins Are Processed
  • Evaluating Query Performance
  • Determining When to Override the Query Optimizer
  • Overriding the Query Optimizer
  • Testing and Reevaluating Query Performance
  • Lab: Analyzing Queries That Use the AND and OR Operators
  • Lab: Analyzing Queries That Use Different Join Strategies
Skills
  • Analyze the performance gain of writing efficient queries and creating useful indexes for queries that contain the AND logical operator.
  • Analyze the performance gain of writing efficient queries and creating useful indexes for queries that contain the OR logical operator.
  • Evaluate how the query optimizer uses different join strategies for query optimization.
  • Evaluate when to override the query optimizer.
top
Module 8: Integrating SQL Server in an Enterprise Solution
  • Designing Enterprise Application Architecture
  • Identifying Logical Layers
  • Designing Physical Tiers
  • Accessing Data
  • Managing Distributed Components and Transactions
  • Introduction to COM+ Services
  • Managing Distributed Transactions
  • Using Message Queuing
  • Managing Connections
  • Selecting a Connection Strategy
  • Using Pooling
  • Enabling MDAC Resource Pooling
  • Controlling MDAC Resource Pooling
  • Controlling the Number of Connections
  • Lab: Managing Clients and Connections
  • Lab: Adding Transaction Support to a Multi-Tier Application
Skills
  • Describe enterprise application architecture, including logical layers, physical models, and clients.
  • Manage distributed components and transactions.
  • Manage connections from components and clients to a database.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Course 832, System Administration of Microsoft SQL Server 7.0, or equivalent experience.
  • Course 833, Implementing a Database Design on Microsoft SQL Server 7.0, or equivalent experience.
> Purpose
After completing this course, students will be able to identify performance goals and factors that affect SQL Server performance; describe the architecture of SQL Server and how it enhances server performance and self-tuning; describe the physical database structures within SQL Server; design a SQL Server environment that maximizes system and data availability and server performance; obtain and evaluate query plan information and statistics; identify and create indexing strategies that can reduce page reads; write efficient queries and determine whether to override the query optimizer; and design and manage enterprise application architecture.
> Supplementary Information
This course has now retired and is no longer available. We suggest you look at Course 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005.
> EXAMS
There are no exams directly associated with this course