Scaling Applications and Resolving Performance Issues

This course is included in our On-demand training solution.


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


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

115 min.

Course 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.