Measuring Database Performance by Using Microsoft® SQL Server„¢ 2005(4370)


Description:

In this 2-hour workshop, you will learn about how to monitor performance in your Microsoft® SQL Server™ 2005 Database solutions. Topics include performance monitoring, tools for monitoring performance, and causes of locking and blocking.

In the lab, you will analyze tables and SQL scripts, as well as use SQL scripts to simulate user activity for capturing baseline and concurrency performance. You will also prioritize discovered bottlenecks and improvements to the database. As a workshop, most of the learning will be done within the lab itself.

Having this experience will enable you to address performance issues that arise within deployed database solutions.

This course will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005.

 

Objectives:

  • Benchmark and identify key performance measures
  • Use Performance Monitor and SQL Server Profiler
  • Identify Locking and Blocking

 




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-MDP-UMS
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend