Tweeted twitter.com/StackDBAs/status/706637828957081600
2 formatting
source | link

I have a question, iI am managing 2 SQL servers 1 is Master Server (Publisher + Distributor) 2

  1. is Master Server (Publisher + Distributor)
  2. is Client Server (Subscriber)

The client is Client Server (Subscriber) client basically owned by a client who is buying data from us. Both

Both Servers are replicated with each other Replication type is using Transactional-replication.
onlyOnly selected Tables of a single DBdatabase are replicated from the Master-Server Server to Client Server. Now i am going to tell actual problem. 

Basically there are several problems i want to discusdiscuss.

Problem 1: 
When iI add or delete any data table and take snapshot of replication thanthen all db vanishesdatabases vanish from customer side and after that it rebuilds in 20-30 minutes (haveI only have limited access so don’t get logs)

Problem 2: 
When iI reinitialize subscription thanthen it takes lotsa lot of time to completing it and it is showing partially applied scripts of tables in monitoring.

Problem 3: 
Publisher to Distributor showing high commands and transactions count but actually on distributor to subscriber commands and transaction counts are more than 100’s of times lower as compare to publisher section.

Problem 4: 
Latency is Very high between Publisher-Distributor (around 5+ minutes)(Server-1) and jumps to 7 minutes then automatically less and stay on some seconds but average is really very high. Distributor-Subscriber latency seems fine.

Problem 5: 
Log Size of Master DB increases and occupying space around 3.5 GB (Normally 3 GB with 80-87% free space) whether Data File Size also increases and now it’s 4 GB+ (Normally 3.3 – 3.5 GB)

Really Appreciate Your Suggestions and Guidelines.

Thanks in advance, Hassan

I have a question, i am managing 2 SQL servers 1 is Master Server (Publisher + Distributor) 2 is Client Server (Subscriber) client basically owned by a client who is buying data from us. Both Servers are replicated with each other Replication type is Transactional-replication only selected Tables of a single DB are replicated from Master-Server to Client Server. Now i am going to tell actual problem. Basically there are several problems i want to discus

Problem 1: When i add or delete any data table and take snapshot of replication than all db vanishes from customer side and after that it rebuilds in 20-30 minutes (have limited access so don’t get logs)

Problem 2: When i reinitialize subscription than it takes lots of time to completing it and showing partially applied scripts of tables in monitoring.

Problem 3: Publisher to Distributor showing high commands and transactions count but actually on distributor to subscriber commands and transaction counts are more than 100’s of times lower as compare to publisher section.

Problem 4: Latency is Very high between Publisher-Distributor (around 5+ minutes)(Server-1) and jumps to 7 minutes then automatically less and stay on some seconds but average is really very high. Distributor-Subscriber latency seems fine.

Problem 5: Log Size of Master DB increases and occupying space around 3.5 GB (Normally 3 GB with 80-87% free space) whether Data File Size also increases and now it’s 4 GB+ (Normally 3.3 – 3.5 GB)

Really Appreciate Your Suggestions and Guidelines.

Thanks in advance, Hassan

I have a question, I am managing 2 SQL servers

  1. is Master Server (Publisher + Distributor)
  2. is Client Server (Subscriber)

The client is basically owned by a client who is buying data from us.

Both Servers are replicated with each other using Transactional-replication.
Only selected Tables of a single database are replicated from the Master Server to Client Server. 

Basically there are several problems i want to discuss.

Problem 1: 
When I add or delete any data table and take snapshot of replication then all databases vanish from customer side and after that it rebuilds in 20-30 minutes (I only have limited access so don’t get logs)

Problem 2: 
When I reinitialize subscription then it takes a lot of time to completing it and it is showing partially applied scripts of tables in monitoring.

Problem 3: 
Publisher to Distributor showing high commands and transactions count but actually on distributor to subscriber commands and transaction counts are more than 100’s of times lower as compare to publisher section.

Problem 4: 
Latency is Very high between Publisher-Distributor (around 5+ minutes)(Server-1) and jumps to 7 minutes then automatically less and stay on some seconds but average is really very high. Distributor-Subscriber latency seems fine.

Problem 5: 
Log Size of Master DB increases and occupying space around 3.5 GB (Normally 3 GB with 80-87% free space) whether Data File Size also increases and now it’s 4 GB+ (Normally 3.3 – 3.5 GB)

1
source | link

Transactional Replication issues

I have a question, i am managing 2 SQL servers 1 is Master Server (Publisher + Distributor) 2 is Client Server (Subscriber) client basically owned by a client who is buying data from us. Both Servers are replicated with each other Replication type is Transactional-replication only selected Tables of a single DB are replicated from Master-Server to Client Server. Now i am going to tell actual problem. Basically there are several problems i want to discus

Problem 1: When i add or delete any data table and take snapshot of replication than all db vanishes from customer side and after that it rebuilds in 20-30 minutes (have limited access so don’t get logs)

Problem 2: When i reinitialize subscription than it takes lots of time to completing it and showing partially applied scripts of tables in monitoring.

Problem 3: Publisher to Distributor showing high commands and transactions count but actually on distributor to subscriber commands and transaction counts are more than 100’s of times lower as compare to publisher section.

Problem 4: Latency is Very high between Publisher-Distributor (around 5+ minutes)(Server-1) and jumps to 7 minutes then automatically less and stay on some seconds but average is really very high. Distributor-Subscriber latency seems fine.

Problem 5: Log Size of Master DB increases and occupying space around 3.5 GB (Normally 3 GB with 80-87% free space) whether Data File Size also increases and now it’s 4 GB+ (Normally 3.3 – 3.5 GB)

Really Appreciate Your Suggestions and Guidelines.

Thanks in advance, Hassan