MCTS - Microsoft SQL Server 2008, Database Development - 70-433 - Objective List Part 7 (Gathering Performance Information)

• Capture execution plans
  
  • Displaying Graphical Execution Plans (SQL Server Management Studio)
  • Displaying Execution Plans by Using SQL Server Profiler Event Classes
  • XML Showplans
  • SET SHOWPLAN_XML (Transact-SQL)
  • SET SHOWPLAN_ALL (Transact-SQL)
  • SET SHOWPLAN_TEXT (Transact-SQL)
  • SET STATISTICS XML (Transact-SQL)
  • SET STATISTICS PROFILE (Transact-SQL)
  • SET STATISTICS TIME (Transact-SQL)
  • SET STATISTICS IO (Transact-SQL)
  • Transact-SQL Statements That Produce Showplans
  • SHOWPLAN Permission and Transact-SQL Batches
• Gather trace information by using the SQL Server Profiler
  
  • Introducing SQL Server Profiler
  • SQL Server Profiler Terminology
  • Using SQL Server Profiler
  • SQL Server Profiler Templates
  • Permissions Required to Run SQL Server Profiler
  • Saving Traces and Trace Templates
  • Modifying Trace Templates
  • Starting, Pausing, and Stopping Traces
  • Correlating a Trace with Windows Performance Log Data
  • Viewing and Analyzing Traces with SQL Server Profiler
  • Analyzing Deadlocks with SQL Server Profiler
  • Analyzing Queries with SHOWPLAN Results in SQL Server Profiler
  • Filtering Traces with SQL Server Profiler
  • Replaying Traces
  • Scenarios for Using SQL Server Profiler
  • SQL Server Profiler Reference
  • Starting SQL Server Profiler
• Collect output from the Database Engine Tuning Advisor
  
  • Database Engine Tuning Advisor Features
  • Differences Between Database Engine Tuning Advisor and Index Tuning Wizard
  • Using Database Engine Tuning Advisor
  • Initializing Database Engine Tuning Advisor
  • Starting Database Engine Tuning Advisor
  • Determining Whether Events Can Be Tuned
  • Tuning a Database
  • Available Tuning Options
  • Choosing a Database Engine Tuning Advisor Report
  • Reducing the Production Server Tuning Load
  • Tuning Multiple Databases
  • Using an XML Input File for Tuning
  • Tuning Mode Precedence: When the dta Utility Overrides XML Tuning Input
  • Using Session Monitor to Evaluate Tuning Recommendations
  • How to: Create Workloads
  • How to: Tune a Database
  • How to: View Tuning Output
  • How to: Perform Exploratory Analysis
  • How to: Implement Tuning Recommendations
• Collect information from system metadata
  
  • Dynamic Management Views and Functions
  • Change Data Capture Related Dynamic Management Views
  • Common Language Runtime Related Dynamic Management Views
  • Database Mirroring Related Dynamic Management Views
  • Database Related Dynamic Management Views
  • Execution Related Dynamic Management Views and Functions
  • Full-Text Search Related Dynamic Management Views
  • Index Related Dynamic Management Views and Functions
  • I/O Related Dynamic Management Views and Functions
  • Object Related Dynamic Management Views and Functions
  • Query Notifications Related Dynamic Management Views
  • Replication Related Dynamic Management Views
  • Resource Governor Dynamic Management Views
  • Service Broker Related Dynamic Management Views
  • SQL Server Extended Events Dynamic Management Views
  • SQL Server Operating System Related Dynamic Management Views
  • Transaction Related Dynamic Management Views and Functions
  • Security Related Dynamic Management Views