Red Gate forums :: View topic - Monitoring Log Shipping
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Monitoring Log Shipping

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dw001



Joined: 01 May 2012
Posts: 2

PostPosted: Tue May 01, 2012 4:08 pm    Post subject: Monitoring Log Shipping Reply with quote

We have a few 2008R2 servers that are log shipping. At the surface we want to make sure the process is staying current. Does anyone have an example SQL query to setup a custom metric for this?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Tue May 01, 2012 4:16 pm    Post subject: Reply with quote

SQL Monitor comes with the Log backup overdue alert. You can configure the alert thresholds so that it will fire an alert when appropriate for your needs. For example, if you have a log backup running each 1/2 hour and normally takes 10 minutes to complete, then a threshold of 45 minutes would be reasonable.

Or are you looking for different information than this?
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
dw001



Joined: 01 May 2012
Posts: 2

PostPosted: Tue May 01, 2012 6:31 pm    Post subject: Reply with quote

That will address part of the need and I've implemented the specific alert.

The other half of this is when the logs are being shipped but not restored to the standby database. We had this situation occur where the log files got out of sequence and thus log shipping ceased. The primary server was still shipping but the secondary server was not restoring them.

We did see event log entries on the secondary server as follows:

System: Sql2
Name: Application
Type: Error
Source: MSSQLSERVER
EventID:
Details: The log shipping secondary database Sql2.MyDatabase has restore threshold of 45 minutes and is out of sync. No restore was performed for 1628 minutes. Restored latency is 2137 minutes. Check agent log and logshipping monitor information.


We can monitor these events using our other monitoring system but it would be really cool if we could see them in the SQL Monitor Overview/Alert pages.
Back to top
View user's profile Send private message
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