Scaling Applications and Resolving Performance Issues

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
recognize how to scale out applications to enterprise level and troubleshoot and identify performance issues that result

Target Audience
Developers who use Microsoft Office SQL Server 2005 and consultants providing consulting services for SQL Server 2005. individuals looking to pass the 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 certification exam and those individuals targeting toward the Microsoft certification: Microsoft Certified IT Professional (MCITP): Database Developer certification path

Prerequisites
Three or more years database programming experience including expertise in troubleshooting triggers, queries, stored procedures, user-defined functions, and user-defined types writing Transact-SQL queries, performing database performance optimization, designing and troubleshooting the data access layer of the application, designing databases, implementing databases at the physical level, and gathering business requirements

Expected Duration (hours)
1.9

Lesson Objectives

Scaling Applications and Resolving Performance Issues

recognize the various scale-out techniques and be able to create partitions, filegroups, and use linked servers.

recognize how to implement the scalable shared database and the peer-to-peer replication techniques.

recognize how to implement distributed partitioned views, data dependent routing, and system-oriented data architecture.

recognize how to use the various templates provided by the SQL Server Profiler and the default counters provided by the system monitor.

recognize how to create a performance baseline to identify performance issues related to the server.

design and implement database scaling techniques such as partitioning, file groups and linked servers.

Course Number:
256999_eng