How to check the Replication Latency manually?
For the checking latency between Primary and Replicated DBs , we have several methods.
Here, I am posting the manual method for checking the replication latency. If you have any more thoughts, please comment it out.
Rite Now I am travelling to Delhi, my train got late, so I am spending my time with my fav, with new posting in blog.
For calculating the latency, we can make two tables in PDB and RDB with column as defaut datetime, and setup replication between these two tables.
Before excuting the batch of your’s queries, insert the id (only for reference for the point, where we executed the insert statement) and it will update the primary_datetime by default current system date.
After the completing the batch, insert the the next id, automaticaly it will get the finish date in default column.
Now go to RDS and check the diff between primary_datetime and replicate_datetime.
1. IN PDS/PDB Create one table as
create table timer_table(id int, primary_datetime datetime default getdate())
2. In RDS/RDB create same table with one extra coloum
create table timer_table(id int,primary_datetime datetime,replicate_datetime default getdate())
3. Setup the replication between both.
4. Before executing the batch insert the value in table as
insert into timer_table (id) values(100)
5. Execute your batch for queries.
6. After completion, execute the insert statement as
insert into timer_table (id) values(101)
7. Now go in the replicated dataserver(RDS/RDB) and check the diff between primary_datetime and replicate_datetime.
select datediff(ss,min(primary_datetime),max(replicate_datetime)) from timer_table
With the help of id you can check the latency upto that point. Even,You can customize this method for checking the latency.
Source : www & sybooks.
Same Thread @ : http://www.sybaseteam.com/how-to-test-latency-t-692.html