| Notas Contenido: |
- SQL query performance tuning
- Memory performance analysis
- Disk performance analysis
- CPU performance analysis
- Creating a baseline
- Query performance metrics
- Analyzing query performance
- Index architecture and behavior
- Index analysis
- Database engine tuning advisor
- Key lookups and solutions
- Statistics, data distribution, and cardinality
- Index fragmentation
- Execution plan generation
- Execution plan cache behavior
- Parameter sniffing
- Query recompilation - Query design analysis
- Reduce query resource use
- Blocking and blocked processes
- Causes and solutions for deadlocks
- Row-by-row processing
- Memory-optimized OLTP tables and procedures
- Database performance testing
- Database workload optimization
- SQL serve optimization checklist.
|
