Post reply

SQL Log Shipping issue

  • March 21, 2016 at 9:04 am

    #312239

    Hi All,

    We have configured log shipping in SQL 2012. after configuring all the Databases. Now client is reporting slow performance while opening any application or file on the primary server. This is happening every 10 mins... it works fine for 5 mins then get Not Responding message....

    while configuring log shipping we kept 15 mins interval for backup , copy and restore.

    for time being i have disabled the LS_Primary server_database job for all the databases.

    is there any issue if i keep it disable for some days...

    and What is the root cause for this issue?

    Please advice....

    Thanks

  • March 21, 2016 at 3:02 pm

    #1866628

    If you leave your databases in full recovery without transaction log backups, you will eventually have problems as the transaction log will grow continuously.

    How many databases did you setup log shipping for?

  • March 22, 2016 at 3:31 am

    #1866690

    There are 6 Databases which i configured for Log shipping.

    I just disable LS_Primary server_database. for all the DBs

    backup and copy jobs are enable,

  • March 22, 2016 at 10:28 am

    #1866857

    OK, back to the Log Shipping performance issue.

    The connectivity issues are on the primary side?

    How big are the log files?

    Are you saving the backups to a dedicated drive?

    What are the duration's for the the backup job executions?

    What are the duration's for the the copy job executions?

    What are the duration's for the the restore job executions?

  • March 23, 2016 at 5:09 am

    #1867028

    Never disable your backup jobs to try to fix a performance issue!

  • March 23, 2016 at 5:18 am

    #1867033

    Yes the Connectivity issues are on the primary server.

    The log files are in KBs.... total folder size is 5.90 GB on both primary(folder name: Repldata) and secondary server( Folder name: Repllogs)

    Yes we have 2 partitions in the primary server we are saving the backups is D:

    The Duration of Backup job, Copy job and Restore job execution is 15 mins.

  • March 23, 2016 at 5:20 am

    #1867034

    Yes Backup jobs are enabled... we didn't disable... only Copy and restore jobs on secondary server disabled

  • March 23, 2016 at 9:12 am

    #1867121

    So the process takes 15 minutes, but you're running it every 10 minutes?

  • March 23, 2016 at 9:49 am

    #1867138

    Yes.

    Can we schedule the copy and restore time from every 15mins to every 1 hour or so.... ?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply