March 21, 2016 at 9:04 am
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
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
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
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
Never disable your backup jobs to try to fix a performance issue!
March 23, 2016 at 5:18 am
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
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
So the process takes 15 minutes, but you're running it every 10 minutes?
March 23, 2016 at 9:49 am
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