9. Troubleshooting SQL Server 2012

Beschreibung

70-462 SQL Server 2012 Mindmap am 9. Troubleshooting SQL Server 2012, erstellt von Michael Mahfouz am 16/12/2015.
Michael Mahfouz
Mindmap von Michael Mahfouz, aktualisiert more than 1 year ago
Michael Mahfouz
Erstellt von Michael Mahfouz vor mehr als 8 Jahre
105
3

Zusammenfassung der Ressource

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
                                                      Zusammenfassung anzeigen Zusammenfassung ausblenden

                                                      ähnlicher Inhalt

                                                      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