This video is 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)

Video: Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports

  • ·Skill level: 400 (Intermediate - Advanced)
  • ·Run Time: 8:45
  • ·Instructor: Scott Whigham

Description:

This fifth video of a five video section about the newest features in Service Pack 2 (SP2) trains us on how to properly download and install the performance dashboard. Scott Whigham unleashes his years of knowledge and training skills when he teaches about the performance dashboard and what it can and will do for us in our SQL endeavors. You can expect to learn about the following in this astounding video:
  • Searching for the performance dashboard correctly
  • highlights on installation location
  • Step by step installation
  • Feature update on SQL Server SP2
  • Basic explanation of the SETUP.SQL file for the performance dashboard
  • Proper shortcut creation
  • Common frustratingn real world error preventing the performance dashboard reports from running properly
  • Proper troubleshooting of a very common and frustrating error
    • There is no resolution to this error provided in the video however the resolution to the error is to run the performance_dashboard_main.rdl before you run any of the other RDL files.
This video takes you step by step through the download and installation of the performance dashboards. This video does have an error within it and will teach you the proper troubleshooting techniques in an attempt to rectify that error. You will learn everything you need to know about downloading, installing, and using the performance dashboard from this video. This will help and train the beginner, intermediate or any user that wishes to learn more about the performance dashboard in general.

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)


NOTE: This video is part of our SQL Server 2005 Database Administration course.
This video is from Chapter 2: Installing, Deploying, and Upgrading SQL Server

Browse this course's videos now