9. Troubleshooting SQL Server 2012

9. Troubleshooting SQL Server 2012

1. Working with Performance Monitor

   • Getting Started with Performance Monitor
   • Capturing Performance Monitor Data
   • Creating Data Collector Sets

2. Working with SQL Server Profiler

   • Capturing Activity with SQL Server Profiler
     • Tracing Output Options
     • Trace Events
     • Trace Columns
     • Filtering Traces
     • Trace Templates
   • Understanding SQL Trace
   • Reviewing Trace Output
   • Capturing Activity with Extended Events Profiler

3. Monitoring SQL Server

   • Monitoring Activity
     • Querying Dynamic Management Views
     • Dynamic Management Views & Functions
   • Working with Activity Monitor

4. Using the Data Collector Tool

   • Capturing & Managing Performance Data
     • Using the Data Collector
     • Defining Data Collection Sets
     • Designing a Data Collector Topology
     • Configuring the Data Collector
     • Monitoring the Data Collector
   • Analysing Collected Performance Data
     • Server Activity Report
     • Disk Usage Report
     • Query Statistics Report

5. Identifying Bottlenecks

   • Monitoring Disk Usage
     • Monitoring Disk I/O & Detecting Excess Paging
     • Isolating Disk Activity Created by SQL Server
   • Monitoring Memory Usage
     • Isolating Memory Used by SQL Server
   • Monitoring CPU Usage