SQL Server 2008 Database Monitoring and Performance
Professionals typically pursuing a career as a Database Administrator; individuals who don’t work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
One to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server
To keep SQL Server 2008 databases running as efficiently as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to analyze a database’s performance. They can also use the Windows System Monitor to monitor SQL Server 2008 using counters, which monitor specific aspects of the server for performance issues. SQL Server 2008 includes the Activity Monitor, which provides an overview of the system’s performance in real-time. And the Database Engine Tuning Advisor enables administrators to analyze a database’s workload and then implement recommendations to provide better performance for the database. SQL Server 2008 provides a Resource Monitor, which allocates specific resources, and a data collector, which collects specific data and stores it in a management data warehouse. In SQL Server 2008, concurrency issues may arise that require the administrator to intervene by detecting the locking issue and possibly terminating a process that could be blocking a session from performing its task. Concurrency issues can arise when multiple users are trying to access the same data in a database. This course demonstrates how to use SQL Server Profiler, the Database Engine Tuning Advisor, Resource Monitor, and the data collector to monitor and tune the performance of the database. It also addresses how to use the Windows System Monitor, Activity Monitor, and how to detect and resolve locks. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
SQL Server 2008 Profiler and Database Tuning
Using Resource Governor and Performance Studio
Monitoring Performance and Resolving Locks