Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    7

    Unanswered: Script to compare two diff. database size on ASE

    Can anybody help me any script or way to compare the size of two databases , this is helpful in replication server to check whether data is moving from prim. to the source side ...

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Quote Originally Posted by gaurav1980us
    Can anybody help me any script or way to compare the size of two databases , this is helpful in replication server to check whether data is moving from prim. to the source side ...
    For a Replication Server, to check if data is in sync, you need more than checking a database size.

    Some options are.
    1) Table Counts
    2) Test table, which can show latency. Insert into primary with a timestamp and see when it gets into standby.
    3) Application level checks

    Check www.sypron.nl It has some useful tips.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •