Microsoft Training - April-September 2009 - (Page 42) SQL Server 2005 Tuning, Optimization, and Troubleshooting Course 6151 Optimize your database to improve query response times. Authorized Course Official Microsoft Learning Product Redeem your SATVs on this course at www.globalknowledge.com/satv. Lab 1: Measuring Database Performance • Reviewing Tables and Scripts • Determining Performance Baselines • Prioritizing Identified Problems Lab 2: Optimizing Schemas • Optimizing Memberships • Optimizing Events • Normalizing Event Sponsorships • Denormalizing Membership Visits • Cleaning Up Schema • Adapting the Solution to the New Database Schema • Determining Performance Lab 3: Optimizing Queries • Optimizing and Rewriting Slow Performing Stored Procedures • Optimizing and Rewriting Slow Performing Views • Optimizing and Rewriting Slow Performing NonCursor Aggregate Queries • Determining Performance Lab 4: Refactoring Cursors into Queries • Refactoring the pMembershipCategory Cursor • Refactoring the pCommunityImpact Cursor • Refactoring the pMemberInvitation Cursor • Determining Performance Lab 5: Optimizing an Indexing Strategy • Identifying Tables to Optimize • Designing Indexes • Determining Performance Lab 6: Reducing Blocking • Identifying Code with Locking and Blocking Issues • Reducing Concurrency Issues • Determining Final Performance Hands-On Labs Lab 7: Building a Monitoring Solution for SQL Server Performance Issues • Determining Which Indicators to Monitor • Implementing a Monitoring Solution • Auditing Monitoring Results to Identify Problem Areas Lab 8: Troubleshooting Database and Database Server Performance Issues • Analyzing Sysmon and Profiler Traces • Analyzing a Profiler Trace by Using SQL Server Queries • Determining Database Server Issues by Using SQLdiag.exe Lab 9: Optimizing the Query Performance Environment • Reviewing an Execution Plan for Clues to Poor Performance • Performing Index Analysis by Using the Database Tuning Advisor (DTA) Lab 10: Troubleshooting SQL Server Connectivity Issues • Troubleshooting Server-Not-Found Issues. • Troubleshooting an Authentication Error Message. • Troubleshooting Endpoint Issues. Lab 11: Troubleshooting SQL Server Data Issues • Troubleshooting and Repairing Torn Pages • Troubleshooting a Data Issue Lab 12: Troubleshooting SQL Server Data Concurrency Issues • Identifying the Objects Involved in a Deadlock • Identifying the Objects Involved in a Blocking Issue • Determining Concurrency Issues by Using Latch Wait Types Course Description In this intensive instructor-led workshop, database developers who work in enterprise environments and use Microsoft SQL Server 2005 will gain the knowledge and skills to evaluate and improve queries and query response times as well as to understand the overall process of troubleshooting. In the workshop, students will focus on systematic identification and optimization of database factors that impact query performance, establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues. This course incorporates material from the following Official Microsoft Learning Products: • 2784: Implementing a Microsoft SQL Server 2005 Database • 790: Troubleshooting and Optimizing Database Servers Using Micro2 soft SQL Server 2005 For SATV redemption: If you are planning to redeem your SATVs for this course, please note that two SATV voucher numbers are required. One voucher number should reflect three days of training, and the second should reflect two days of training. Prerequisites • Familiar with SQL Server 2005 features, tools, and technologies • icrosoft Certified Technology Specialist: Microsoft SQL Server 2005 M credential or equivalent experience • Course 6052: Maintaining a Microsoft SQL Server 2005 Database • orking knowledge of data storage, specifically, knowledge about row W layout, fixed-length field placement, & varying-length field placement. • amiliarity with index structures & index utilization, specifically, an F understanding of interaction between non-clustered indexes, clustered indexes, and heaps & why a covering index can improve performance • t least three years of experience as a full-time database developer in A an enterprise environment • amiliar with locking model, including an understanding of lock modes, F lock objects, & isolation levels & familiarity with process blocking • nderstand Transact-SQL syntax and programming logic, specifically, U be completely fluent in advanced queries, aggregate queries, subqueries, user-defined functions, cursors, control of flow statements, CASE expressions, and all types of joins • bility to design a database to third normal form (3NF) and know the A trade offs when backing out of the fully normalized design (denormalization) and designing for performance and business requirements in addition to being familiar with design models, such as Star and Snowflake schemas • trong monitoring and troubleshooting skills, including using monitorS ing tools • asic knowledge of the operating system and platform, that is, how B the operating system integrates with the database, what the platform or operating system can do, and how interaction between the operating system and the database works Note: There are additional prerequisites associated with this course. Please see our web site for a complete list. Course Content 1. Measuring Database Performance 2. Optimizing Physical Database Design 3. Optimizing Queries for Performance 4. Refactoring Cursors into Queries 5. Optimizing an Indexing Strategy 6. Managing Concurrency 7. Building a Monitoring Solution for SQL Server Performance Issues 8. Troubleshooting Database and Database Server Performance Issues 9. Optimizing the Query Performance Environment 10. Troubleshooting SQL Server Connectivity Issues 11. Troubleshooting SQL Server Data Issues 12. Troubleshooting SQL Server Data Concurrency Issues Classroom Learning 5 days $2,995 Classroom Learning CA San Jose May 11-15 CA San Jose Sep 21-25 DC Washington DC Washington GA Atlanta On-Site Learning Call for info. Apr 20-24 Jul 27-31 Jun 22-26 IL Chicago NC Raleigh NJ Morristown Jun 15-19 Aug 10-14 Mar 30-Apr 3 NJ Morristown NY New York TX Dallas Sep 28-Oct 2 Apr 27-May 1 Jul 20-24 42 REGISTER NOW 1-800-COURSES www.globalknowledge.com/microsoft http://www.globalknowledge.com/satv http://www.globalknowledge.com/training/olm/go.asp?find=MIC6151&country=United+States http://www.globalknowledge.com/microsoft
For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.