• home
  • ¦
  • training courses
    • By Audience>>
      • Database Professionals
      • System Administrators
      • Developers
      • Knowledge Workers
    • By Software>>
      • SQL Server
      • Windows Server
      • SharePoint
      • Exchange
      • Visual Studio .NET
      • ISA Server
      • All Courses
    • Packages>>
      • SQL 2005 DBA
      • Windows System Admin (2008)
      • Windows System Admin (2003)
      • Visual Studio 2005 Developer
      • All Packages
    • What is Included?
    • How it Works
    • Free Videos
    • Pricing
  • ¦
  • why choose us?
    • 8 Reasons to Choose LIF>>
      • 1. Instant Access
      • 2. Affordable Training
      • 3. Extensive Video Library
      • 4. Best Video Quality
      • 5. Expert Instructors
      • 6. Vendor Independent
      • 7. Anytime, Anywhere Access
      • 8. iPhone Compatible
    • Customer Success Stories
    • Money-Back Guarantee
    • Our Clients
  • ¦
  • solutions
    • Multi-User Licensing
    • Training Vouchers
    • Custom Training Plans
    • Vouchers or Custom plan?
    • Volume discounts
    • Get a quote
  • ¦
  • support
    • FAQs
    • Contact Us
    • Troubleshooting
    • Lost Password
    • Knowledge Base
  • ¦
  • company
    • About Us
    • Our Clients
    • Our Instructors
    • Our Partners
    • Our Philosophy
    • Contact Us
¦
¦
login

Login

Email *

     

Password *

   

Lost password?     Standard form | Secure form
¦
sign up
¦
This chapter comes from our "SQL Server 2005 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Chapter 11: Monitoring and Performance Tuning SQL Server

This SQL Server chapter is all about performance tuning your SQL Server and queries. The more you know about how SQL Server does what it does, the better prepared you are to make smart design decisions. Watch these videos for a solid foundation of the "how and why" things work the way they do in SQL Server.

Videos in Chapter 11

1Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands Download
2SET Commands for Performance Tuning and Query Execution Statistics Download
3Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens Download
4Pt. 2 - Determining Which Events and Data Columns to Use in Your Trace Download
5Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces Download
6Pt. 4 - Managing, Viewing and Interpreting SQL Server Traces Download
7Pt. 5 - Templates and Working Within the Profiler UI Download
8Part1 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions Download
9Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions Download
10Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions Download
11Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions Download
Download this chapter

Browse this course's videos now

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.

About Us
  • About Us
  • Become an Author
  • Privacy Policy
  • Contact Us
Courses
  • Course List
  • Packages & Bundles
  • Terms of Service
  • System Requirements
Support
  • Video Playback
  • Codecs & Players
  • Lost Password
  • Site Map