9. Troubleshooting SQL Server 2012

Description

70-462 SQL Server 2012 Mind Map on 9. Troubleshooting SQL Server 2012, created by Michael Mahfouz on 16/12/2015.
Michael Mahfouz
Mind Map by Michael Mahfouz, updated more than 1 year ago
Michael Mahfouz
Created by Michael Mahfouz over 8 years ago
104
3

Resource summary

9. Troubleshooting SQL Server 2012
  1. Working with Performance Monitor
    1. Getting Started with Performance Monitor
      1. Capturing Performance Monitor Data
        1. Creating Data Collector Sets
        2. Working with SQL Server Profiler
          1. Capturing Activity with SQL Server Profiler
            1. Tracing Output Options
              1. Trace Events
                1. Trace Columns
                  1. Filtering Traces
                    1. Trace Templates
                    2. Understanding SQL Trace
                      1. Reviewing Trace Output
                        1. Capturing Activity with Extended Events Profiler
                        2. Monitoring SQL Server
                          1. Monitoring Activity
                            1. Querying Dynamic Management Views
                              1. Dynamic Management Views & Functions
                              2. Working with Activity Monitor
                              3. Using the Data Collector Tool
                                1. Capturing & Managing Performance Data
                                  1. Using the Data Collector
                                    1. Defining Data Collection Sets
                                      1. Designing a Data Collector Topology
                                        1. Configuring the Data Collector
                                          1. Monitoring the Data Collector
                                          2. Analysing Collected Performance Data
                                            1. Server Activity Report
                                              1. Disk Usage Report
                                                1. Query Statistics Report
                                              2. Identifying Bottlenecks
                                                1. Monitoring Disk Usage
                                                  1. Monitoring Disk I/O & Detecting Excess Paging
                                                    1. Isolating Disk Activity Created by SQL Server
                                                    2. Monitoring Memory Usage
                                                      1. Isolating Memory Used by SQL Server
                                                      2. Monitoring CPU Usage
                                                      Show full summary Hide full summary

                                                      Similar

                                                      Computing Hardware - CPU and Memory
                                                      ollietablet123
                                                      SFDC App Builder 2
                                                      Parker Webb-Mitchell
                                                      Data Types
                                                      Jacob Sedore
                                                      Intake7 BIM L1
                                                      Stanley Chia
                                                      Software Processes
                                                      Nurul Aiman Abdu
                                                      Design Patterns
                                                      Erica Solum
                                                      CCNA Answers – CCNA Exam
                                                      Abdul Demir
                                                      Abstraction
                                                      Shannon Anderson-Rush
                                                      Spyware
                                                      Sam2
                                                      HTTPS explained with Carrier Pigeons
                                                      Shannon Anderson-Rush
                                                      Data Analytics
                                                      anelvr