Zusammenfassung der Ressource
9. Troubleshooting SQL
Server 2012
- Working with Performance Monitor
- Getting Started with Performance Monitor
- Capturing Performance Monitor Data
- Creating Data Collector Sets
- 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
- Monitoring SQL Server
- Monitoring Activity
- Querying Dynamic Management Views
- Dynamic Management Views & Functions
- Working with Activity Monitor
- 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
- 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