2013
Pluralsight
Joe Sack
1h 52m
English
Learn how to configure, monitor, and troubleshoot SQL Server transactional replication, as well as the fundamentals of how it works and key performance considerations.
SQL Server replication remains a viable data distribution and availability feature that has inherent advantages that are not entirely covered by other out-of-the-box SQL Server features.
This course will briefly examine the various replication types before delving more deeply into transactional replication.
In addition to the fundamentals, this course will also review the key performance considerations, monitoring techniques and troubleshooting scenarios.
After viewing this course you should be ready to use transactional replication in the appropriate contexts, as well as deploy, support and troubleshoot issues accordingly.
This course is perfect for developers, DBAs, and anyone responsible for SQL Server replication, from complete beginners through to those with more experience.
The information in the course applies to all versions from SQL Server 2005 onwards.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Course Introduction 1.61 MB 0:01:04 128kbps 143.00 1024x768 15 frames/second 01.Course Introduction
02.Course Structure 853 KB 0:00:38 128kbps 50.00 1024x768 15 frames/second 01.Course Introduction
01.Module Introduction 1.21 MB 0:00:51 128kbps 110.00 1024x768 15 frames/second 02.Replication Types and Scenarios
02.Terminology - Publishing Industry Metaphor 1.62 MB 0:01:06 128kbps 146.00 1024x768 15 frames/second 02.Replication Types and Scenarios
03.Types of Replication (1) 1.80 MB 0:01:21 128kbps 87.00 1024x768 15 frames/second 02.Replication Types and Scenarios
04.Types of Replication (2) 1.53 MB 0:01:05 128kbps 121.00 1024x768 15 frames/second 02.Replication Types and Scenarios
05.Types of Replication (3) 2.54 MB 0:01:55 128kbps 106.00 1024x768 15 frames/second 02.Replication Types and Scenarios
06.Common Transactional Replication Topologies 1.29 MB 0:00:54 128kbps 137.00 1024x768 15 frames/second 02.Replication Types and Scenarios
01.Module Introduction 1.20 MB 0:00:50 128kbps 99.00 1024x768 15 frames/second 03.Setup and Configuration
02.Transactional Replication Components 1.47 MB 0:01:02 128kbps 127.00 1024x768 15 frames/second 03.Setup and Configuration
03.Transactional Replication Initial Dataset 1.08 MB 0:00:44 128kbps 115.00 1024x768 15 frames/second 03.Setup and Configuration
04.Transactional Replication Log Reader Agent 1.66 MB 0:01:13 128kbps 144.00 1024x768 15 frames/second 03.Setup and Configuration
05.Transactional Replication Distribution Agent 706 KB 0:00:30 128kbps 84.00 1024x768 15 frames/second 03.Setup and Configuration
06.Deployment - Wizard or Scripts 2.00 MB 0:01:24 128kbps 155.00 1024x768 15 frames/second 03.Setup and Configuration
07.Configuring the Distributor 926 KB 0:00:41 128kbps 67.00 1024x768 15 frames/second 03.Setup and Configuration
08.Demo - Configuring the Distributor via Wizard 12.7 MB 0:06:07 128kbps 1079.00 1024x768 15 frames/second 03.Setup and Configuration
09.Demo - Configuring the Distributor via T-SQL 8.48 MB 0:03:15 128kbps 1025.00 1024x768 15 frames/second 03.Setup and Configuration
10.Creating the Publication 1.25 MB 0:00:58 128kbps 73.00 1024x768 15 frames/second 03.Setup and Configuration
11.Demo - Creating the Publication via Wizard 8.96 MB 0:05:05 128kbps 252.00 1024x768 15 frames/second 03.Setup and Configuration
12.Demo - Creating the Publication via T-SQL 11.4 MB 0:03:20 128kbps 866.00 1024x768 15 frames/second 03.Setup and Configuration
13.Creating the Push Subscription 571 KB 0:00:24 128kbps 52.00 1024x768 15 frames/second 03.Setup and Configuration
14.Creating the Pull Subscription 818 KB 0:00:37 128kbps 45.00 1024x768 15 frames/second 03.Setup and Configuration
15.sp_addsubscription @sync_type 2.44 MB 0:01:42 128kbps 136.00 1024x768 15 frames/second 03.Setup and Configuration
16.Demo - Creating a Subscription via Wizard 9.80 MB 0:05:54 128kbps 247.00 1024x768 15 frames/second 03.Setup and Configuration
17.Demo - Testing a Transactional Replication Topology 3.57 MB 0:01:49 128kbps 451.00 1024x768 15 frames/second 03.Setup and Configuration
18.Demo - Creating a Subscription via T-SQL 8.56 MB 0:03:01 128kbps 711.00 1024x768 15 frames/second 03.Setup and Configuration
19.Deploying with Least Privilege (1) 1.58 MB 0:01:10 128kbps 97.00 1024x768 15 frames/second 03.Setup and Configuration
20.Deploying with Least Privilege (2) 1.21 MB 0:00:49 128kbps 151.00 1024x768 15 frames/second 03.Setup and Configuration
01.Module Introduction 1.28 MB 0:00:54 128kbps 96.00 1024x768 15 frames/second 04.Performance Considerations
02.Factors that Affect Replication Performance (1) 3.42 MB 0:02:32 128kbps 99.00 1024x768 15 frames/second 04.Performance Considerations
03.Factors that Affect Replication Performance (2) 2.12 MB 0:01:37 128kbps 84.00 1024x768 15 frames/second 04.Performance Considerations
04.Demo - Replication Multiplier Effect 16.2 MB 0:04:26 128kbps 2506.00 1024x768 15 frames/second 04.Performance Considerations
05.Distribution Database 1.85 MB 0:01:19 128kbps 129.00 1024x768 15 frames/second 04.Performance Considerations
06.sp_addpublication's immediate_sync 2.59 MB 0:01:41 128kbps 219.00 1024x768 15 frames/second 04.Performance Considerations
07.Demo - Checking Distribution Database Settings 4.03 MB 0:02:30 128kbps 323.00 1024x768 15 frames/second 04.Performance Considerations
08.Demo - Validating immediate_sync options 2.79 MB 0:01:04 128kbps 416.00 1024x768 15 frames/second 04.Performance Considerations
09.Log Reader and Transaction Log Activity 1.10 MB 0:00:46 128kbps 111.00 1024x768 15 frames/second 04.Performance Considerations
10.Hidden Costs of a Single Command 1.78 MB 0:01:02 128kbps 289.00 1024x768 15 frames/second 04.Performance Considerations
11.Demo - Measuring Agent Reader vs. Writer Time 16.3 MB 0:06:04 128kbps 1337.00 1024x768 15 frames/second 04.Performance Considerations
12.Demo - Wait Statistics by Agent 10.8 MB 0:04:34 128kbps 977.00 1024x768 15 frames/second 04.Performance Considerations
01.Module Introduction 1.14 MB 0:00:47 128kbps 104.00 1024x768 15 frames/second 05.Combining Replication with other Technologies
02.Transactional Replication and Database Mirroring 2.37 MB 0:01:35 128kbps 228.00 1024x768 15 frames/second 05.Combining Replication with other Technologies
03.Transactional Replication and Failover Clustering 850 KB 0:00:36 128kbps 78.00 1024x768 15 frames/second 05.Combining Replication with other Technologies
04.Transactional Replication and Availability Groups 2.11 MB 0:01:23 128kbps 224.00 1024x768 15 frames/second 05.Combining Replication with other Technologies
01.Module Introduction 888 KB 0:00:37 128kbps 80.00 1024x768 15 frames/second 06.Monitoring
02.Setting Warnings and Thresholds 1.10 MB 0:00:43 128kbps 132.00 1024x768 15 frames/second 06.Monitoring
03.Demo - Replication Monitor Warnings and Thresholds 5.11 MB 0:02:42 128kbps 405.00 1024x768 15 frames/second 06.Monitoring
04.Alerts (1) 759 KB 0:00:32 128kbps 75.00 1024x768 15 frames/second 06.Monitoring
05.Alerts (2) 1.20 MB 0:00:51 128kbps 112.00 1024x768 15 frames/second 06.Monitoring
06.Demo - Replication Alerts 10.9 MB 0:04:30 128kbps 970.00 1024x768 15 frames/second 06.Monitoring
07.Demo - Using Tracer Token Stored Procedures 2.71 MB 0:01:26 128kbps 414.00 1024x768 15 frames/second 06.Monitoring
08.Establishing Replication Baselines 1.26 MB 0:00:56 128kbps 106.00 1024x768 15 frames/second 06.Monitoring
01.Module Introduction 1.24 MB 0:00:53 128kbps 99.00 1024x768 15 frames/second 07.Troubleshooting
02.Tools and General Troubleshooting Steps (1) 2.65 MB 0:01:48 128kbps 207.00 1024x768 15 frames/second 07.Troubleshooting
03.Tools and General Troubleshooting Steps (2) 1.13 MB 0:00:44 128kbps 140.00 1024x768 15 frames/second 07.Troubleshooting
04.Data Not Being Delivered to Subscribers 1.55 MB 0:01:03 128kbps 161.00 1024x768 15 frames/second 07.Troubleshooting
05.Demo - Replication Validation 5.83 MB 0:02:24 128kbps 720.00 1024x768 15 frames/second 07.Troubleshooting
06.Publisher and Subscriber Data Does Not Match 1.31 MB 0:00:58 128kbps 72.00 1024x768 15 frames/second 07.Troubleshooting
07.Danger of -SkipErrors 1.31 MB 0:00:54 128kbps 137.00 1024x768 15 frames/second 07.Troubleshooting
08.Demo - Skipping a Failed Command 8.11 MB 0:03:53 128kbps 1044.00 1024x768 15 frames/second 07.Troubleshooting
09.Skipping Specific Commands 1.52 MB 0:01:05 128kbps 128.00 1024x768 15 frames/second 07.Troubleshooting
10.Process Could Not Execute sp_repldone-sp_replcounters 1.64 MB 0:01:05 128kbps 186.00 1024x768 15 frames/second 07.Troubleshooting
11.Impact of DBCC CHECKDB Repair 1.60 MB 0:01:05 128kbps 170.00 1024x768 15 frames/second 07.Troubleshooting
12.Error 2812 - Could not find stored procedure %.+ls 1.36 MB 0:00:58 128kbps 110.00 1024x768 15 frames/second 07.Troubleshooting
13.Course Summary 1.15 MB 0:00:54 128kbps 49.00 1024x768 15 frames/second 07.Troubleshooting
Download File Size:190.46 MB
|
