10. Indexes & Concurrency

Michael Mahfouz
Mind Map by Michael Mahfouz, updated more than 1 year ago More Less
Michael Mahfouz
Created by Michael Mahfouz almost 4 years ago
31
1
0

Description

70-462 SQL Server 2012 Mind Map on 10. Indexes & Concurrency, created by Michael Mahfouz on 12/16/2015.
Tags

Resource summary

10. Indexes & Concurrency
1 Implementing & Maintaining Indexes
1.1 Understanding the Anatomy of a Balanced Tree (B-Tree)
1.2 Understanding Index Types & Structures
1.2.1 Clustered Indexes
1.2.2 Non-Clustered Indexes
1.2.3 Covering Indexes
1.2.4 Filtered Indexes
1.2.5 Primary XML & Secondary XML Indexes
1.2.6 Spatial Indexes
1.2.7 Full-Text Indexes
1.2.8 Columnstore Indexes
1.3 Designing Indexes for Efficient Retrieval
1.3.1 Clustered Indexes
1.3.2 Non-Clustered Indexes
1.3.3 Covering Indexes
1.3.4 Filtered Indexes
1.3.5 Primary XML & Secondary XML Indexes
1.3.6 Full-Text Indexes & Semantic Searches
1.3.7 Columnstore Indexes
1.4 Understanding Statistics
1.4.1 Using Index Internals
1.4.2 Moving Row-Overflow Data
1.5 Creating & Modifying Indexes
1.5.1 Choosing Fill Factors
1.5.2 Determining Fragmentation
1.5.3 Removing Index Fragmentation
1.5.4 Updating Statistics
1.6 Tracking Missing Indexes
1.7 Reviewing Unused Indexes
2 Identifying & Resolving Concurrency Problems
2.1 Defining Transactions & Transaction Scope
2.2 Understanding SQL Server Lock Management
2.2.1 Lock Modes
2.2.2 Explaining Lock Compatibility
2.2.3 Understanding Dynamic Lock Management
2.2.4 Understanding Transaction Isolation Levels
2.2.5 Choosing the Read Committed Snapshot Isolation Database Option
2.2.6 Lock Duration Based on Transaction Isolation Levels
2.2.7 Monitoring Locks
2.2.8 Identifying Blocking
2.2.9 Avoiding Blocking
2.3 Using AlwaysOn Replicas to Improve Concurrency
2.4 Detecting & Correcting Deadlocks
2.4.1 Capturing Deadlock Information
2.5 Using Activity Monitor
2.6 Diagnosing Bottlenecks
2.7 Using Reports for Performance Analysis
2.7.1 Using Standard Reports
2.7.2 Using Custom Reports
2.7.3 Executing the KILL Process
Show full summary Hide full summary

Similar

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