Monitoring Database Performance

Summary of Video

This demonstrates (using the Music Database) the execution plan and SQL Profiler to help you determine performance bottlenecks in a database and perform optimization.

Prerequisites

Should be relatively proficient with SQL and queries
Use of Microsoft SQL Server

Video Link

Support Materials

This video uses the Case Study – Music Database created Spring 2013 for COP4709