Please enable JavaScript.
Coggle requires JavaScript to display documents.
DBA - Expertise (Performance (Database Design (To Index or Not to Index,…
DBA - Expertise
Performance
Database Design
To Index or Not to Index
Normalise or Not to Normalise
Profiling
UI - SQL Profiler
Console - Audit Logs
Query Execution
Execution Plans
Setup and Configuration
Types of Setup
HA
Non-HA
Configuration
Location of Log / Data Files
Location of Error Logs
Security and Audit
CPU and Memory Settings
Allocation of Memory
Operation and Maintenance
Operation
Backup
Full
Differential
Log
Recovery
Full
Point in Time
SURPRISE TRIAL RECOVERY
Monitoring
System Resources
CPU
Memory
Slow Queries
Locks
Maintenance
Database Integity Checks (DBCC)
Index Management