Course 10157: Monitoring and Controlling Resources in Microsoft SQL Server 2008
Description
Introduction This two-hour course provides you with the skills and knowledge required to monitor and control resources in SQL Server 2008. You will learn about various tools, such as Activity monitor, System monitor and Profiler, which can be used to monitor SQL Server 2008. You will also learn how to control resources by using Policy-Based Management and Resource Governor.Topics covered in this course include:
- Introduction to Monitoring
- Using Windows Reliability and Performance Monitor
- Using SQL Server Profiler
- Using SQL Server Data Collector
- Using Resource Governor
- Using Policy-Based Management
Student prerequisites:
To benefit from this course, the learner must be familiar with usi…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Topics covered in this course include:
- Introduction to Monitoring
- Using Windows Reliability and Performance Monitor
- Using SQL Server Profiler
- Using SQL Server Data Collector
- Using Resource Governor
- Using Policy-Based Management
Student prerequisites:
To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.
Objectives At the end of the course, students will be able to:
- Describe monitoring.
- Use Windows Reliability and Performance Monitor.
- Use SQL Server Profiler.
- Use SQL Server Data Collector.
- Control resources by using the Resource Governor.
- Control SQL Server by using Policy-Based Management.
- A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
- Microsoft® Windows® 2000 or higher
- Microsoft Internet Explorer 6.0 or higher
- Adobe Flash 7.0 or higher (1MB disk space needed to install)
- Microsoft Silverlight 4.0 or higher
- Microsoft Windows Media Player 7.0 or higher
- Microsoft XML Core Services 3.0 or higher
- A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
- A sound card, and either speakers or headphones (for multi-media audio).
- Internet bandwidth of 56K or faster. Broadband internet access is recommended.
- Microsoft Virtual Server ActiveX control (1MB disk space needed to install)
- Microsoft Internet Explorer 6.0 or higher
- Window-Eyes from GW Micro
- JAWS from Freedom Scientific
- MSAA enabled
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.