This course covers troubleshooting and performance tuning tools and processes you can use with SQL Server 2008 implementations.
Objectives:
This course covers troubleshooting and performance tuning tools and processes you can use with SQL Server 2008 implementations.
Capture trace data
Manage locks, blocking, and deadlocks
View SQL Server internals with Dynamic Management Functions
Partition tables
Collect performance data in the Management Data Warehouse
Manage resource allocation with the Resource Governor
Topics:
Performance Tuning
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
