Real-time performance monitoring and troubleshooting
Post Reply
sraj
Influencer
Posts: 21
Liked: 2 times
Joined: Oct 30, 2017 6:55 am
Full Name: Rajesh Samidurai
Contact:

Veeam SQL Transaction log failure Alerting

Post by sraj » May 28, 2018 8:41 pm

Hi

We have configured the the SQL Tlog application aware processing for an Physical SQL server. The job is configured to take the Tlog backup every 30 minutes and truncate the log

We are seeing few failures during the Tlog schedule which runs every 30 min. But this is not being alerted/shown in the failure job status console.

We were able to monitor the Parent job failure with veeam one alerting. Is it possible to configure the alerting for the Tlog failure also..

Your inputs are appreciated.

Regards
Raj

Vitaliy S.
Product Manager
Posts: 22025
Liked: 1354 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by Vitaliy S. » May 30, 2018 5:31 pm

Hi Raj,

There is no such alarm in the predefined list, but we have this predefined report that you can schedule to be run on daily basis to review your SQL job stats. Will this help in your situation?

Thanks!

sraj
Influencer
Posts: 21
Liked: 2 times
Joined: Oct 30, 2017 6:55 am
Full Name: Rajesh Samidurai
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by sraj » May 30, 2018 6:07 pm

We have so many SQL Servers and its tough verify each job status as success or failure.

would be great if we can integrate this tlog failure alerting in veeam one Monitoring. .

Vitaliy S.
Product Manager
Posts: 22025
Liked: 1354 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by Vitaliy S. » May 30, 2018 8:02 pm 1 person likes this post

I don't have access to the lab right now, but we might have an option to create these alarms. I just need to check if the corresponding event is triggered or not. I will post back tomorrow as soon as I get to the office.

Vitaliy S.
Product Manager
Posts: 22025
Liked: 1354 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by Vitaliy S. » May 31, 2018 3:34 pm

Ok, confirmed that there is no way to achieve that today. SQL Server jobs (Tlog) do not generate any event that can be used in the alarm creation. We will discuss it with the B&R team and will ask them to add this in our next releases.

sraj
Influencer
Posts: 21
Liked: 2 times
Joined: Oct 30, 2017 6:55 am
Full Name: Rajesh Samidurai
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by sraj » Feb 10, 2019 6:10 am

Hi Vitaliy S.

Could you confirm if this feature is added in Veeam One Update 4 version ?
Thanks

Vitaliy S.
Product Manager
Posts: 22025
Liked: 1354 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by Vitaliy S. » Feb 10, 2019 7:14 pm 1 person likes this post

These jobs now generate an event in the backup server Windows Event Log, but there is no predefined alarm for this yet. This FR is still logged for our next updates.

Vitaliy S.
Product Manager
Posts: 22025
Liked: 1354 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by Vitaliy S. » Feb 11, 2019 4:48 pm

Rajesh,

BTW, there is no need to wait for the next release to have alerting functionality on these types of jobs. After reviewing this closely with our QA team, you can try to create this alarm even today. Just specify the event name in the rule (event-based), assign it to the backup server and you should be all set.

Here is a screenshot of the proposed rule configuration: http://prntscr.com/mjnn2y

Hope this helps!

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests