Pluralsight training net SQL Server Collecting and Analyzing Trace Data

Pluralsight training net SQL Server Collecting and Analyzing Trace Data

Name	[pluralsight-training.net] SQL Server - Collecting and Analyzing Trace Data	DOWNLOAD Copy Link
Total Size	447.8 MB
Total Files	95
Hash	62FFD74C20692984464FD81EEC1F3CF4A1A07324

/1. Introduction/
1. Introduction.wmv	3.0 MB
2. Collecting Trace Information.wmv	1.7 MB
3. Workload Analysis.wmv	1.3 MB
4. Course Structure.wmv	1.7 MB
/2. SQL Trace Architecture/
1. Introduction.wmv	1.8 MB
10. Summary.wmv	1.5 MB
2. What is SQL Trace.wmv	1.3 MB
3. What are Events.wmv	1.9 MB
4. The Trace Controller.wmv	1.4 MB
5. Event Producers.wmv	922.0 KB
6. Traces.wmv	798.8 KB
7. IO Providers.wmv	1.4 MB
8. When to use SQL Trace.wmv	1.6 MB
9. Security Considerations.wmv	2.4 MB
/3. Using SQL Server Profiler/
1. Introduction.wmv	3.3 MB
10. Trace Templates - TSQL and TSQL_Duration.wmv	1.5 MB
11. Demo - TSQL_Duration Template.wmv	5.6 MB
12. Trace Templates - TSQL_Grouped and TSQL_Locks.wmv	1.7 MB
13. Trace Templates - TSQL_Replay and TSQL_SPs.wmv	3.2 MB
14. Trace Templates - Tuning.wmv	1.4 MB
15. Demo - Trace Templates.wmv	9.4 MB
16. Saving Captured Data.wmv	2.1 MB
17. Demo - Saving Captured Data.wmv	18.6 MB
18. Tips for Tracing with Profiler.wmv	3.2 MB
19. Summary.wmv	3.3 MB
2. What is Profiler.wmv	2.4 MB
3. Creating New Traces.wmv	2.5 MB
4. Demo - Creating a New Trace from Scratch.wmv	7.1 MB
5. Demo - Creating a New Trace from a Template.wmv	6.0 MB
6. Demo - Creating a New Trace from a Trace File.wmv	4.5 MB
7. Filtering Trace Events.wmv	3.8 MB
8. Trace Templates - Introduction.wmv	2.2 MB
9. Trace Templates - SP_Counts and Standard.wmv	1.6 MB
/4. Server-Side Trace/
1. Introduction.wmv	3.3 MB
10. Demo - Programatically Creating Traces.wmv	13.1 MB
11. Generating Trace Scripts with Profiler.wmv	2.3 MB
12. Demo - Scripting Trace from Profiler.wmv	7.2 MB
13. Summary.wmv	1.7 MB
2. Performance Comparison.wmv	3.6 MB
3. The SQL Trace DMVs.wmv	1.6 MB
4. Demo - Trace DMVs.wmv	6.5 MB
5. Programmatically Creating Traces.wmv	2.9 MB
6. sp_trace_create.wmv	3.9 MB
7. sp_trace_setevent.wmv	1.6 MB
8. sp_trace_setfilter.wmv	2.7 MB
9. sp_trace_setstatus.wmv	1.9 MB
/5. Tracing Scenarios/
1. Introduction.wmv	1.9 MB
10. Demo - Identifying Deadlock Issues.wmv	9.9 MB
11. Identifying Recompile Issues.wmv	2.0 MB
12. Demo - Identifying Recompile Issues.wmv	10.3 MB
13. Security and Compliance Auditing.wmv	1.9 MB
14. Demo - Security and Compliance Auditing.wmv	20.0 MB
15. Capturing a Tuning Workload.wmv	2.6 MB
16. Demo - Capturing a Tuning Workload.wmv	10.6 MB
17. Capturing a Replay Workload.wmv	1.8 MB
18. Demo - Capturing a Replay Workload.wmv	5.7 MB
19. Common Trace Mistakes.wmv	4.5 MB
2. Default Trace in SQL Server.wmv	3.6 MB
20. Summary.wmv	1.8 MB
3. Events Captured by the Default Trace.wmv	2.3 MB
4. Common Questions about the Default Trace.wmv	3.1 MB
5. Scenarios to use the Default Trace.wmv	2.5 MB
6. Demo - Default Trace.wmv	16.1 MB
7. Identifying Blocking Issues.wmv	2.9 MB
8. Demo - Identifying Blocking Issues.wmv	10.8 MB
9. Identifying Deadlock Issues.wmv	2.4 MB
/6. Analzying Trace Data/
1. Introduction.wmv	2.8 MB
10. Demo - sp_get_query_template.wmv	13.0 MB
11. Demo - ReadTrace from RML Utilities.wmv	10.8 MB
12. Demo - ClearTrace.wmv	5.7 MB
13. Database Tuning Advisor Workload Analysis.wmv	3.5 MB
14. Demo - DTA Workload Analysis.wmv	10.4 MB
15. Summary.wmv	1.6 MB
2. Analyzing Trace Data with Transact-SQL.wmv	3.1 MB
3. Demo - Analyzing Trace Data with Transact-SQL.wmv	7.0 MB
4. Analyzing Data in Profiler.wmv	3.1 MB
5. Demo - Analyzing Data in Profiler.wmv	13.0 MB
6. Demo - Merging PerfMon Data in Profiler.wmv	11.4 MB
7. Extracting Trace Events.wmv	2.9 MB
8. Demo - Extracting Trace Events.wmv	9.2 MB
9. Normalizing Trace Data.wmv	3.2 MB
/7. Replaying Trace Workloads/
1. Introduction.wmv	2.6 MB
10. Demo - Distributed Replay.wmv	14.7 MB
11. Replay Tool Limitiations.wmv	3.6 MB
12. Replay Tool Benefits.wmv	3.9 MB
13. Which Tool to Use.wmv	2.0 MB
14. Summary.wmv	1.8 MB
2. Profiler Replay.wmv	3.2 MB
3. Profiler Replay Requirements.wmv	3.2 MB
4. Demo - Profiler Replay.wmv	10.9 MB
5. RML Utilities OStress Replay.wmv	3.6 MB
6. RML OStress Replay Requirements.wmv	3.5 MB
7. Demo - RML Ostress.wmv	13.0 MB
8. SQL Server 2012 Distributed Replay.wmv	3.6 MB
9. Distributed Replay Requirements.wmv	2.7 MB
Total files 95