Red Gate forums :: View topic - 7.3.0.383 Issue: Refreshing Connection for 20m & counting
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

7.3.0.383 Issue: Refreshing Connection for 20m & counting

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Go to page Previous  1, 2
Author Message
PDinCA



Joined: 25 Jul 2005
Posts: 499
Location: Costa Mesa, CA, USA

PostPosted: Tue Apr 02, 2013 11:53 pm    Post subject: Reply with quote

After TWO HOURS the cluster's Activity History is finally back!

It also incurred a SQL "Long Running Query" Alert from SQL Monitor - the query ran for 8718.0400001 seconds!!!
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 499
Location: Costa Mesa, CA, USA

PostPosted: Wed Apr 03, 2013 12:54 am    Post subject: Reply with quote

It also turns out that the server has Activity dating back to 9 Oct 2012. The sqbdata process is responsible for the long running query, hence the 6 full months of activity may be the underlying issue, not the client or server dat or sdf files...

Maintenance plan for History Cleanup is now configured, executed, and we're down to 30-days.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1120
Location: My desk.

PostPosted: Wed Apr 03, 2013 6:02 pm    Post subject: Reply with quote

I'd already left for the night when you posted that last message- unlikely it's going to be busy with lots of data then...
Did you manage to remove the file in the end?
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 499
Location: Costa Mesa, CA, USA

PostPosted: Wed Apr 03, 2013 6:14 pm    Post subject: Reply with quote

No need to remove the file after I whacked the extraneous backup history. All clients now refresh the activity history just fine.

I deployed the server bits to three more production servers that have only 30-day history retention and had no issues at all. Their backup schedules are very similar to the 6-month-retention machine, BTW.

The fact that SQL Monitor kicked out a Long Running Query Alert for sqbdata as the underlying process tells me that the issue lies in THAT process and that the volume of data gave it a two hour twenty five minute headache!
Back to top
View user's profile Send private message
mglenn



Joined: 13 Sep 2006
Posts: 16

PostPosted: Fri May 17, 2013 2:51 pm    Post subject: Reply with quote

Has Red-Gate looked into performance tuning sqbdata? Activity History still takes forever to populate--GT 5 minutes for us on a server that contains 1 year of history.

Customers should not be forced to delete important backup history as a workaround for a poorly performing SQL Backup process.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page Previous  1, 2
Page 2 of 2

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group