dell training services ms 2790: troubleshooting and ... 2790: troubleshooting and optimizing...
TRANSCRIPT
You Will Learn:
•BuildamonitoringsolutionforSQLServerperformanceissues.
Usingprofilerandsysmon:
•Troubleshootdatabaseandserverperformanceissues
•Optimizethequeryperformanceenvironment
•TroubleshootSQLServerconnectivityissues
•TroubleshootSQLServerdataissues
•TroubleshootSQLServerconcurrencyissues
Who Should Attend:
•ITProfessionals,inexperiencedDBA(databaseadministrator)roleswiththree(3)ormoreyears’experiencewithSQLServer
Dell Training Services
MS 2790: Troubleshooting and Optimizing Database Servers
Using SQL Server 2005
MS2790:TroubleshootingandOptimizingDatabaseServersUsingSQLServer2005isatwo-daycoursethatwillteachdatabaseadministratorsworkinginenterpriseenvironmentshowtodetermineandtroubleshootperformanceissuesusingMicrosoftSQLServer2005.Theprimaryfocusofthiswork-shopistoteachtheoverallprocessoftroubleshooting.Itincludesestablishingmonitoringstandardsandbaselines,determiningperformancethresholds,andfocusingtheinvestigationonspecificissues.
courSe detAiLS:
Get More out oF Your technoLoGY inveStMent. Get More out oF noW.
visit www.Learndell.com for more information.
Module 1: Building a Monitoring Solution for SQL Server Performance issues•NarrowingDownaPerformanceIssuetoanEnvironmentArea•GuidelinesforMonitoringDatabaseServersandInstancesbyUsingProfilerandSysmon•GuidelinesforAuditingandComparingTestResults
Lab 1: Building a Monitoring Solution for SQL Server Performance issues•DeterminingWhichIndicatorstoMonitor•ImplementingaMonitoringSolution•AuditingMonitoringResultstoIdentifyProblemAreas
Module 2: troubleshooting database and database Server Performance issues•NarrowingDownaPerformanceIssuetoaDatabaseObject•HowProfilerCanHelpNarrowaSearchtoaSpecificIssue•HowtheSQLdiagToolCanBeUsedtoAnalyzeOutputs
Lab 2: troubleshooting database and database Server Performance issues•AnalyzingSysmonandProfilerTraces•AnalyzingaProfilerTracebyUsingSQLServerQueries•DeterminingDatabaseServerIssuesbyUsingSQLdiag.exe
Module 3: optimizing the Query Performance environment•TheMethodologyofOptimizingaQueryEnvironment•TheQueryPerformanceTroubleshootingProcess
Lab 3: optimizing the Query Performance environment•ReviewinganExecutionPlanforCluestoPoorPerformance•PerformingIndexAnalysisbyUsingtheDatabaseTuningAdvisor(DTA)
Module 4: troubleshooting SQL Server connectivity issues•TheMethodologyofTroubleshootingSQLServerConnectivityIssues.•AreastoTroubleshootforCommonConnectivityIssues.•WhatAreSQLServer2005Endpoints?
Lab 4: troubleshooting SQL Server connectivity issues•TroubleshootingServer-Not-FoundIssues.•TroubleshootinganAuthenticationErrorMessage.•TroubleshootingEndpointIssues.
GET MORE OUT OF YOUR TECHNOLOGY INVESTMENT. GET MORE OUT OF NOW.
Pricing, specifications, availability, and terms of offers may change without notice. Taxes, fees, shipping, handling and any applicable restocking charges are extra, and vary. Training Services new purchases only. Dell cannot be responsible for pricing or other errors,and reserves the right to cancel orders arising from such errors. Dell, and the Dell logo are trademarks of Dell Inc. Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products. Delldisclaims proprietary interest in the marks and names of others. Printed in U.S.A. © Copyright 2006 Dell Inc. All rights reserved. Reproduction in any manner whatsoever without the express written permission of Dell Inc. is strictly forbidden.
Course Length:
• Two days
Recommended Prerequisites:
• Working knowledge of SQL Server 2005 architectureincluding indexing, SQL execution plans, and SQLServer basic configuration
• Basic monitoring and troubleshooting skills
• Working knowledge of the operating system andplatform
• Basic understanding of server architecture such asCPU and memory utilization and disk input/output (I/O)
• Basic knowledge of application architecture
• Understanding of Transact-SQL syntax andprogramming logic
• Basic knowledge of Microsoft Windows networking
• Familiarity with SQL Server 2005 features, tools, andtechnologies
The following classes fulfill many of the prerequisiteslisted above, and it is strongly recommended thatstudents have completed them:
• Transact-SQL for Microsoft SQL Server 2005 Course2779, Implementing a Microsoft SQL Server 2005Database
• Course 2780, Maintaining a Microsoft SQL Server2005 Database
PRICING:
Delivery Method SKU PriceInstructor-led at customer location 986-1899 $10,313.00
To learn more about Dell Training & Certification, contact your Dell Account Executive or any of the following:Website: www.LearnDell.comEmail: [email protected]: 1-866-360-3506 (US & Canada only)
COURSE DETAILS:
Module 5: Troubleshooting SQL Server Data Issues• The Methodology of Troubleshooting SQL Server Data Issues• The Process of Troubleshooting Data Integrity Issues• How Torn Pages Can be Resolved Using a Single- Page Restore
Lab 5: Troubleshooting SQL Server DataIssues• Troubleshooting and Repairing Torn Pages• Troubleshooting a Data Issue
Module 6: Troubleshooting SQL Server Data Concurrency Issues• The Methodology of Troubleshooting Concurrency Issues• What Are SQL Server Latches?• Activity: Choosing a Blocking Monitoring Solution
Lab 6: Troubleshooting SQL Server DataConcurrency Issues•Identifying the Objects Involved in a Deadlock•Identifying the Objects Involved in a Blocking Issue•Determining Concurrency Issues by Using Latch Wait Types
Instructor-Led Training Includes:
Microsoft Official Course (MOC) courseware, including:
• A workbook with all the lecture and lab materials
• A CD containing additional reading, answers to labs, and lab setup files