Veeam SQL Transaction log failure Alerting

Real-time performance monitoring and troubleshooting

Veeam SQL Transaction log failure Alerting

Veeam Logoby sraj » Mon 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
sraj
Influencer
 
Posts: 14
Liked: never
Joined: Mon Oct 30, 2017 6:55 am
Full Name: Rajesh Samidurai

Re: Veeam SQL Transaction log failure Alerting

Veeam Logoby Vitaliy S. » Wed 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!
Vitaliy S.
Veeam Software
 
Posts: 21162
Liked: 1259 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam SQL Transaction log failure Alerting

Veeam Logoby sraj » Wed 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. .
sraj
Influencer
 
Posts: 14
Liked: never
Joined: Mon Oct 30, 2017 6:55 am
Full Name: Rajesh Samidurai

Re: Veeam SQL Transaction log failure Alerting

Veeam Logoby Vitaliy S. » Wed May 30, 2018 8:02 pm

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.
Veeam Software
 
Posts: 21162
Liked: 1259 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam SQL Transaction log failure Alerting

Veeam Logoby Vitaliy S. » Thu 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.
Vitaliy S.
Veeam Software
 
Posts: 21162
Liked: 1259 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 2 guests