Pluralsight com SQL Server Common Performance Issue Patterns | 233D01A05D1026EE83420304012160B8E6001C10

Pluralsight com SQL Server Common Performance Issue Patterns

Name	[pluralsight.com] SQL Server - Common Performance Issue Patterns	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	365.9 MB
Total Files	77
Hash	233D01A05D1026EE83420304012160B8E6001C10

/1. Course Introduction/
1. Course Introduction.wmv	1.8 MB
2. Course Structure.wmv	3.2 MB
/2. High-Level Issue Patterns/
1. Module Introduction.wmv	1.5 MB
10. Ignoring Capacity Considerations (3).wmv	1.9 MB
11. Failure to Enforce Standards.wmv	1.9 MB
12. Missing Change Control.wmv	2.4 MB
2. Vendor Bias (1).wmv	1.6 MB
3. Vendor Bias (2).wmv	3.0 MB
4. Expertise Traps.wmv	1.8 MB
5. Missing Data.wmv	1.4 MB
6. Incomplete Data.wmv	1.6 MB
7. Lack of Troubleshooting Methodology.wmv	1.6 MB
8. Troubleshooting Downstream Issues.wmv	1.4 MB
9. Ignoring Capacity Considerations (1-2).wmv	2.4 MB
/3. IO Patterns/
1. Module Introduction.wmv	1.0 MB
2. Inadequate IO Paths (1).wmv	1.7 MB
3. Inadequate IO Paths (2).wmv	2.8 MB
4. Demo - Inadequate IO Paths.wmv	23.1 MB
5. IO-Intensive Execution Plans (1).wmv	1.3 MB
6. IO-Intensive Execution Plans (2).wmv	1.7 MB
7. Demo - IO-Intensive Execution Plans.wmv	25.2 MB
8. Aggressive Checkpoint Activity.wmv	2.1 MB
9. Collocation with Bad Neighbors.wmv	1.8 MB
/4. Concurrency Patterns/
1. Module Introduction.wmv	1.2 MB
2. Long-Term Blocking.wmv	3.8 MB
3. Demo - Long-Term Blocking.wmv	17.7 MB
4. Lock Escalation.wmv	3.0 MB
5. Accessing Objects Inconsistently.wmv	1.2 MB
6. Demo - Accessing Objects Inconsistently.wmv	6.0 MB
7. Forgotten Side-effects.wmv	1.3 MB
8. Demo - Forgotten Side-effects.wmv	14.1 MB
9. Hint Misuses and Restrictive Isolation Levels.wmv	1.6 MB
/5. Memory Patterns/
1. Module Introduction.wmv	792.8 KB
2. Memory Pressure (1).wmv	1.6 MB
3. Memory Pressure (2).wmv	2.9 MB
4. Memory Pressure (3).wmv	2.2 MB
5. Demo - Memory Pressure.wmv	28.0 MB
6. Query Execution Memory Issues (1).wmv	1.6 MB
7. Query Execution Memory Issues (2).wmv	2.6 MB
8. Demo - Query Execution Memory Issues.wmv	23.5 MB
/6. Tempdb Patterns/
1. Module Introduction.wmv	861.9 KB
2. Allocation Page Contention (1).wmv	1.2 MB
3. Allocation Page Contention (2).wmv	2.0 MB
4. Demo - Allocation Page Contention.wmv	13.8 MB
5. Row Versioning Overhead.wmv	1.3 MB
6. Demo - Row Versioning Overhead.wmv	9.4 MB
7. Collocation with High IO Databases.wmv	1.7 MB
8. Query Workspace Overhead.wmv	1.3 MB
/7. CPU Patterns/
1. Module Introduction.wmv	898.0 KB
10. Excessive Compilation and Recompilation (2).wmv	3.1 MB
11. Demo - Excessive Compilation and Recompilation.wmv	7.5 MB
12. Observer Overhead.wmv	3.8 MB
13. Demo - Observer Overhead.wmv	6.0 MB
14. Uninvited Parallelism.wmv	3.6 MB
15. Demo - Uninvited Parallelism.wmv	8.5 MB
2. External CPU Pressure.wmv	1.8 MB
3. High Privileged Time.wmv	2.9 MB
4. User-Time SQL Server CPU Time (1).wmv	2.3 MB
5. User-Time SQL Server CPU Time (2).wmv	1.7 MB
6. Demo - User-Time SQL Server CPU Time.wmv	19.8 MB
7. IO Correlated High CPU.wmv	1.3 MB
8. Demo - IO Correlated High CPU.wmv	8.1 MB
9. Excessive Compilation and Recompilation (1).wmv	1.2 MB
/8. Application Design Patterns/
1. Module Introduction.wmv	907.0 KB
2. Slow Fetches.wmv	3.2 MB
3. Demo - Slow Fetches.wmv	7.0 MB
4. Needless Queries.wmv	3.1 MB
5. Over and Under-Architecture (1).wmv	2.4 MB
6. Over and Under-Architecture (2).wmv	2.0 MB
7. Boil-the-Ocean Modules (1).wmv	1.9 MB
8. Boil-the-Ocean Modules (2).wmv	2.3 MB
/9. Plan Quality Patterns/
1. Module Introduction.wmv	913.0 KB
2. Cardinality Estimate Issues.wmv	2.6 MB
3. Demo - Cardinality Estimate Issues.wmv	17.8 MB
4. Opaque Operations and Hidden Costs.wmv	1.9 MB
5. Demo - Opaque Operations and Hidden Costs.wmv	13.0 MB
6. Course Summary.wmv	940.0 KB
Total files 77