Red Gate forums :: View topic - comments and suggestions
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation

Log Shipping Monitor forum

comments and suggestions

Search in Log Shipping Monitor forum
Post new topic   Reply to topic
Jump to:  
Author Message
grambowk



Joined: 10 Jul 2007
Posts: 5

PostPosted: Wed Jul 11, 2007 9:47 am    Post subject: comments and suggestions Reply with quote

Just thought I'd add a couple of comments and suggestions for possible future releases.

1. With the "Backup Size" and "Backup Duration Charts" would it be possible to add an "Hour of Day" x-axis to the charts as you already have done for the "Average Backup Size" charts?

2. With respect to these charts it would be useful if you could add colour-coded lines to represent the different types of backups. For example, keep the current orange colour for full backups and use blue for log backups (and some other colour for diff backups). This would just make it that little bit easier to quickly spot the different types of backups.

3. It would be great if you could include a chart that showed the backup
sizes over time. For example, take the largest backup of each day and add that to a chart that will then show how the size of the backup (and indirectly, the size of the database) varies over time. This would be useful for trend analysis and identifying when more hard disk space or greater compression needs to be applied.

Not sure how possible it is to do 3 because you'd need to worry about retaining this information somewhere but it's a wish list so I included it here. Smile

Thanks,

Karl
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Wed Jul 11, 2007 10:22 am    Post subject: Reply with quote

Thank you for your feedback.

Re 1:
It would be possible to display an x-axis for the mentioned charts, at least for the 24-hour period. For the 7-day period, the x-axis would be overly cramped. The aim of these charts (without the x-axis) was to give a quick idea of where the size/duration trend was heading. The plan was to be able to expand on these charts, so that a larger chart, with more details, could be displayed, together with the underlying data.

Re 2:
The charts only ever show data for transaction log backups. There should not be any data for other types of backups shown.

Re 3:
This would require data for full backups to be retrieved and stored. LSM only retrieve details of the last full database backup.

Perhaps we could consider implementing some of your suggestions in SQL Backup, as it collects a lot more historical backup data.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
grambowk



Joined: 10 Jul 2007
Posts: 5

PostPosted: Wed Jul 11, 2007 10:34 am    Post subject: Reply with quote

Thanks for the quick response Peter.

Re 1: That sounds great. The 7-day period chart is fine as it stands. And the plan to expand on the charts and drill down into further details sounds great too.

Re 2: My mistake, I was looking at the previous 24 hour chart and there was an exceedingly large log backup file, which I had assumed was a full backup file. The charts prove there worth instantly. I'll have to investigate that. Smile

Re 3: If that could be possibly implemented in SQL Backup that would be nice.

Regards,

Karl
Back to top
View user's profile Send private message
jkz999



Joined: 25 Jan 2007
Posts: 8

PostPosted: Fri Jul 13, 2007 1:13 pm    Post subject: Restore History Reply with quote

1. I cannot see any restore history, the chart says No data to display. Is this because my monitor server is not on my production server?

2. An option to display the backup sizes in something other that bytes (user selectable) would be useful, I have logs over night that display as 9308685824, which is hard to equate by eye to 8.7 Gb

When I closed down last night while the app was minimised to the tray, it (the app) crashed! Confused

HTH

Dave
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Sat Jul 14, 2007 8:04 am    Post subject: Reply with quote

Thanks for the feedback.

Re 1:
You need to link a SQL Server agent job and job step to the standby server. This is because SQL Server does not store the duration of restores in the backup history tables. Hence the information needs to come from the SQL Server Agent job step.

We'll try to fit in this information so that users are aware of this.

Re 2:
Yes, it is not user friendly to display everything in bytes. LSM will display both bytes and a user friendly size (rounded to nearest Kb, MB, GB) in a future version.

Re the crash:
Do you have a stack trace when the crash occurred?

Thanks.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
crespowu



Joined: 19 Nov 2007
Posts: 1

PostPosted: Mon Nov 19, 2007 9:47 am    Post subject: Reply with quote

Your answers are all very good.Thanks a lot.They are really helpful.
Back to top
View user's profile Send private message
j.salmon



Joined: 08 Aug 2007
Posts: 32

PostPosted: Thu Feb 21, 2008 3:21 pm    Post subject: Re: Reply with quote

petey wrote:
Thanks for the feedback.
Re 2:
Yes, it is not user friendly to display everything in bytes. LSM will display both bytes and a user friendly size (rounded to nearest Kb, MB, GB) in a future version.


That would be nice.


If possible, could you fix this:
When creating a new group and are on the standby databases tab, the server and database fields are automatically enabled. You can enter values in them (and the DB combo actually populates), and hit save. But the standby server is not saved (because you didn't press ADD first). It makes the process a little deceiving at first.
Back to top
View user's profile Send private message
j.salmon



Joined: 08 Aug 2007
Posts: 32

PostPosted: Thu Feb 21, 2008 3:57 pm    Post subject: Re: Restore History Reply with quote

I'm having a couple problems.

1.
jkz999 wrote:
1. I cannot see any restore history, the chart says No data to display. Is this because my monitor server is not on my production server?

petey wrote:

Re 1:
You need to link a SQL Server agent job and job step to the standby server. This is because SQL Server does not store the duration of restores in the backup history tables. Hence the information needs to come from the SQL Server Agent job step.


I'm having problems with this as well. I'm not quite following your suggestion. Our setup does not include a monitoring server.

Per the documentation on the wiki, I'm supposed to select a job for the standby database so that the restore duration data can be filled in. When I select the ... button, I can see the jobs on the server, but I am unable to select any (or is the job field ever enabled)?

The backup duration is displayed properly.


2. I cannot get the freespace alerts to work on either server. I purposely specified 1 gig so that both would immediately get triggered. The commands were accepted and saved correctly, but they don't appear to work - meaning no alerts are triggered?

3. Since I'm at it......... I'll add something else for future enhancements.
When your adding alerts, it would be nice to not keep up with all the keywords. Granted, they aren't hard or anything, but it would be nice to eliminate the need to know them (esp. if more are added in future updates). So I propose, you add functionality that would add the alerts for the user when he/she right clicks in the alerts area or clicks an Add/Delete button.

In the case if you right click, you would have a menu such as:
Free space
Last backup
Last restore, etc (format how you want).

So, the user right clicks and selects free space - the app should bring up a small dialog with a text box for the drive letter and a text box for the size.
Press ok or enter button and the command properly formatted is added for the user.

Pressing a different menu option would show different options required for setting up that alert. Pressing ok/enter - automatically puts the alert in the alerts box formatted correctly.


4. One more thing.................honest.....
Would it be possible to get data on the copy job? As duration, success/failures? I'm assuming you could use the log_shipping_monitor_history_detail table for this info?

Not sure if there's room on the summary page for it, or maybe add something (another tab, button) for viewing extended data.

5. Petty change request: Add an X to close the groups tab. Add a view menu or File menu option to view the tab again. In our case, we only have 1 group for log shipping. It would be nice to get the extra screen space. You guys did a nice job of the UI on the right side, so it's still easy to navigate the servers without need the tree view on the left (in this type of setup).
Back to top
View user's profile Send private message
j.salmon



Joined: 08 Aug 2007
Posts: 32

PostPosted: Mon Mar 03, 2008 6:58 pm    Post subject: more change requests Reply with quote

Make it possible to launch any of the log shipping jobs from the monitor. I know it's monitor, but it'd be nice that if you see in the monitor that a job failed, that you can force it to run.

If you have time and if its "doable", it be a nice touch.
Back to top
View user's profile Send private message
mariaparacha20



Joined: 25 Apr 2011
Posts: 2
Location: albama

PostPosted: Mon Apr 25, 2011 12:33 pm    Post subject: Reply with quote

An option to display the backup sizes in something other that bytes (user selectable) would be useful, I have logs over night that display as 9308685824, which is hard to equate by eye to 8.7 Gb

When I closed down last night while the app was minimised to the tray, it (the app) crashed! Confused
Back to top
View user's profile Send private message Yahoo Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
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