Pluralsight - Azure SQL Database- Diagnosing Performance Issues with DMVs by Glenn Berry
File List
| File | Size |
|---|---|
| 0. Course Overview/0. Course Overview.mp4 | 3.95 MB |
| 0. Course Overview/0. Course Overview.srt | 2.25 KB |
| 1. Introduction/0. Introduction and DMV Queries.mp4 | 2.55 MB |
| 1. Introduction/0. Introduction and DMV Queries.srt | 2.67 KB |
| 1. Introduction/1. Diagnosing Issues and Benefits of DMV Queries.mp4 | 3.24 MB |
| 1. Introduction/1. Diagnosing Issues and Benefits of DMV Queries.srt | 3.48 KB |
| 1. Introduction/2. Course Details and Module Summary.mp4 | 2.38 MB |
| 1. Introduction/2. Course Details and Module Summary.srt | 3.13 KB |
| 2. Diagnosing Database-level Configuration Issues/0. Introduction and Database Properties.mp4 | 3.64 MB |
| 2. Diagnosing Database-level Configuration Issues/0. Introduction and Database Properties.srt | 4.48 KB |
| 2. Diagnosing Database-level Configuration Issues/1. Demo- Database Properties.mp4 | 5.22 MB |
| 2. Diagnosing Database-level Configuration Issues/1. Demo- Database Properties.srt | 2.59 KB |
| 2. Diagnosing Database-level Configuration Issues/10. Automatic Tuning Options.mp4 | 2.19 MB |
| 2. Diagnosing Database-level Configuration Issues/10. Automatic Tuning Options.srt | 3.09 KB |
| 2. Diagnosing Database-level Configuration Issues/11. Demo- Automatic Tuning Options.mp4 | 3.29 MB |
| 2. Diagnosing Database-level Configuration Issues/11. Demo- Automatic Tuning Options.srt | 2.08 KB |
| 2. Diagnosing Database-level Configuration Issues/12. Module Summary.mp4 | 671.25 KB |
| 2. Diagnosing Database-level Configuration Issues/12. Module Summary.srt | 890 B |
| 2. Diagnosing Database-level Configuration Issues/2. File Sizes and Space.mp4 | 1.5 MB |
| 2. Diagnosing Database-level Configuration Issues/2. File Sizes and Space.srt | 1.7 KB |
| 2. Diagnosing Database-level Configuration Issues/3. Demo- File Sizes and Space.mp4 | 2.55 MB |
| 2. Diagnosing Database-level Configuration Issues/3. Demo- File Sizes and Space.srt | 1.38 KB |
| 2. Diagnosing Database-level Configuration Issues/4. Database-scoped Configurations.mp4 | 2.3 MB |
| 2. Diagnosing Database-level Configuration Issues/4. Database-scoped Configurations.srt | 2.6 KB |
| 2. Diagnosing Database-level Configuration Issues/5. Demo- Database-scoped Configurations.mp4 | 3.2 MB |
| 2. Diagnosing Database-level Configuration Issues/5. Demo- Database-scoped Configurations.srt | 1.83 KB |
| 2. Diagnosing Database-level Configuration Issues/6. Table Properties.mp4 | 1.22 MB |
| 2. Diagnosing Database-level Configuration Issues/6. Table Properties.srt | 1.36 KB |
| 2. Diagnosing Database-level Configuration Issues/7. Demo- Table Properties.mp4 | 5.36 MB |
| 2. Diagnosing Database-level Configuration Issues/7. Demo- Table Properties.srt | 1.32 KB |
| 2. Diagnosing Database-level Configuration Issues/8. Query Store Options.mp4 | 2.09 MB |
| 2. Diagnosing Database-level Configuration Issues/8. Query Store Options.srt | 2.77 KB |
| 2. Diagnosing Database-level Configuration Issues/9. Demo- Query Store Options.mp4 | 2.42 MB |
| 2. Diagnosing Database-level Configuration Issues/9. Demo- Query Store Options.srt | 1.82 KB |
| 3. Diagnosing CPU-related Issues/0. Introduction and CPU Utilization by Database.mp4 | 2.97 MB |
| 3. Diagnosing CPU-related Issues/0. Introduction and CPU Utilization by Database.srt | 3.53 KB |
| 3. Diagnosing CPU-related Issues/1. Demo- CPU Utilization by Database.mp4 | 1.35 MB |
| 3. Diagnosing CPU-related Issues/1. Demo- CPU Utilization by Database.srt | 1.03 KB |
| 3. Diagnosing CPU-related Issues/2. Top Worker Time Queries.mp4 | 2.43 MB |
| 3. Diagnosing CPU-related Issues/2. Top Worker Time Queries.srt | 2.86 KB |
| 3. Diagnosing CPU-related Issues/3. Demo- Top Worker Time Queries.mp4 | 9.2 MB |
| 3. Diagnosing CPU-related Issues/3. Demo- Top Worker Time Queries.srt | 2.87 KB |
| 3. Diagnosing CPU-related Issues/4. SP Worker Time.mp4 | 2.69 MB |
| 3. Diagnosing CPU-related Issues/4. SP Worker Time.srt | 3.14 KB |
| 3. Diagnosing CPU-related Issues/5. Demo- SP Worker Time.mp4 | 7.64 MB |
| 3. Diagnosing CPU-related Issues/5. Demo- SP Worker Time.srt | 2.35 KB |
| 3. Diagnosing CPU-related Issues/6. High Aggregate CPU Queries.mp4 | 2.98 MB |
| 3. Diagnosing CPU-related Issues/6. High Aggregate CPU Queries.srt | 3.36 KB |
| 3. Diagnosing CPU-related Issues/7. Demo- High Aggregate CPU Queries.mp4 | 6.35 MB |
| 3. Diagnosing CPU-related Issues/7. Demo- High Aggregate CPU Queries.srt | 2.06 KB |
| 3. Diagnosing CPU-related Issues/8. Module Summary.mp4 | 688.49 KB |
| 3. Diagnosing CPU-related Issues/8. Module Summary.srt | 955 B |
| 4. Diagnosing Activity-related Issues/0. Introduction and Lock Waits.mp4 | 3.87 MB |
| 4. Diagnosing Activity-related Issues/0. Introduction and Lock Waits.srt | 4.45 KB |
| 4. Diagnosing Activity-related Issues/1. Demo- Lock Waits.mp4 | 2.88 MB |
| 4. Diagnosing Activity-related Issues/1. Demo- Lock Waits.srt | 1.76 KB |
| 4. Diagnosing Activity-related Issues/10. SP Average Elapsed Time.mp4 | 3.4 MB |
| 4. Diagnosing Activity-related Issues/10. SP Average Elapsed Time.srt | 4.12 KB |
| 4. Diagnosing Activity-related Issues/11. Demo- SP Average Elapsed Time.mp4 | 6.64 MB |
| 4. Diagnosing Activity-related Issues/11. Demo- SP Average Elapsed Time.srt | 2.31 KB |
| 4. Diagnosing Activity-related Issues/12. Bad Nonclustered Indexes.mp4 | 2.51 MB |
| 4. Diagnosing Activity-related Issues/12. Bad Nonclustered Indexes.srt | 2.75 KB |
| 4. Diagnosing Activity-related Issues/13. Demo- Bad Nonclustered Indexes.mp4 | 3.16 MB |
| 4. Diagnosing Activity-related Issues/13. Demo- Bad Nonclustered Indexes.srt | 2.16 KB |
| 4. Diagnosing Activity-related Issues/14. Missing Indexes.mp4 | 3.47 MB |
| 4. Diagnosing Activity-related Issues/14. Missing Indexes.srt | 4.47 KB |
| 4. Diagnosing Activity-related Issues/15. Demo- Missing Indexes.mp4 | 7.08 MB |
| 4. Diagnosing Activity-related Issues/15. Demo- Missing Indexes.srt | 5.16 KB |
| 4. Diagnosing Activity-related Issues/16. Missing Index Warnings.mp4 | 2.88 MB |
| 4. Diagnosing Activity-related Issues/16. Missing Index Warnings.srt | 3.25 KB |
| 4. Diagnosing Activity-related Issues/17. Demo- Missing Index Warnings.mp4 | 2.55 MB |
| 4. Diagnosing Activity-related Issues/17. Demo- Missing Index Warnings.srt | 1.62 KB |
| 4. Diagnosing Activity-related Issues/18. Overall Index Usage - Reads.mp4 | 2.47 MB |
| 4. Diagnosing Activity-related Issues/18. Overall Index Usage - Reads.srt | 2.97 KB |
| 4. Diagnosing Activity-related Issues/19. Demo- Overall Index Usage - Reads.mp4 | 6.97 MB |
| 4. Diagnosing Activity-related Issues/19. Demo- Overall Index Usage - Reads.srt | 1.66 KB |
| 4. Diagnosing Activity-related Issues/2. Scalar UDF Statistics.mp4 | 2.29 MB |
| 4. Diagnosing Activity-related Issues/2. Scalar UDF Statistics.srt | 2.7 KB |
| 4. Diagnosing Activity-related Issues/20. Overall Index Usage - Writes.mp4 | 2.32 MB |
| 4. Diagnosing Activity-related Issues/20. Overall Index Usage - Writes.srt | 2.64 KB |
| 4. Diagnosing Activity-related Issues/21. Demo- Overall Index Usage - Writes.mp4 | 5.54 MB |
| 4. Diagnosing Activity-related Issues/21. Demo- Overall Index Usage - Writes.srt | 1.46 KB |
| 4. Diagnosing Activity-related Issues/22. Volatile Indexes.mp4 | 2.19 MB |
| 4. Diagnosing Activity-related Issues/22. Volatile Indexes.srt | 2.48 KB |
| 4. Diagnosing Activity-related Issues/23. Demo- Volatile Indexes.mp4 | 3.25 MB |
| 4. Diagnosing Activity-related Issues/23. Demo- Volatile Indexes.srt | 1.53 KB |
| 4. Diagnosing Activity-related Issues/24. Recent Resource Usage.mp4 | 2.63 MB |
| 4. Diagnosing Activity-related Issues/24. Recent Resource Usage.srt | 2.77 KB |
| 4. Diagnosing Activity-related Issues/25. Demo- Recent Resource Usage.mp4 | 5.05 MB |
| 4. Diagnosing Activity-related Issues/25. Demo- Recent Resource Usage.srt | 1.42 KB |
| 4. Diagnosing Activity-related Issues/26. Module Summary.mp4 | 695.16 KB |
| 4. Diagnosing Activity-related Issues/26. Module Summary.srt | 902 B |
| 4. Diagnosing Activity-related Issues/3. Demo- Scalar UDF Statistics.mp4 | 2.63 MB |
| 4. Diagnosing Activity-related Issues/3. Demo- Scalar UDF Statistics.srt | 2.14 KB |
| 4. Diagnosing Activity-related Issues/4. Input Buffer.mp4 | 2.03 MB |
| 4. Diagnosing Activity-related Issues/4. Input Buffer.srt | 2.36 KB |
| 4. Diagnosing Activity-related Issues/5. Demo- Input Buffer.mp4 | 2.58 MB |
| 4. Diagnosing Activity-related Issues/5. Demo- Input Buffer.srt | 1.51 KB |
| 4. Diagnosing Activity-related Issues/6. Query Execution Counts.mp4 | 2.57 MB |
| 4. Diagnosing Activity-related Issues/6. Query Execution Counts.srt | 3.48 KB |
Trackers
No trackers found.