Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Dec 1, 2004

Checking Latency on SQL Server 2000

By Muthusamy Anantha Kumar aka The MAK



Latency in a replication environment is the time it takes for a transaction to be transmitted from a publisher to the distributor and from the distributor to a subscriber. In this article, I am going to discuss how to find and monitor the latency frequency in a transactional replication environment.



Pre-requisite


  1. Both Publisher and Subscriber are on SQL Server 2000 with latest service packs
  2. At least one object is being replicated from the Publisher to the Subscriber
  3. System clock on both publisher and the subscriber are in synch


Let's consider that we have a database named "Employee" on the publisher and subscriber as shown in the script, (Refer to Fig. 1.4), and the articles "Employee" and "Department" are already being replicated (transactional replication) to the subscriber. Here the publishing server is "EBONY" and the distributor/subscriber is "MAK." (Refer Fig 1.0, 1.1, 1.2, 1.3)



Publisher



[Fig 1.0]


[Fig 1.1]

Subscriber


[Fig 1.2]

Distributor


[Fig 1.3]

Publishing Database [Fig 1.4]

use master
go
create database Employee
go
use Employee
go
create table department (deptid int constraint department_pk primary key, 
  departmentname varchar(250), Location varchar(100))
go
create table emp(empid int constraint emp_pk primary key, Empname varchar(100), 
Dept int constraint emp_dept_FK foreign key references department(deptid))
go


MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM