SQL: Don't warn about longrunning BACKUP queries

[Martin Stevnhoved]

Hi MMSOFT,

 

Would you please prioritize in the near feature to exclude "BACKUP" and "RESTORE" statements from the "Send a notification when a SQL Query is executing for more than ..." notification. 

It is a bit annoying to get notifications on backup of large databases every day.

 

Thank you very much for a very good and flexible program.

 

Best Regards,

Martin Stevnhoved

[Martin Stevnhoved]

This is of cource a feature request, not a demand

I can see that the tone of my initial post is a bit to formal.

 

// Martin.

[Chris]

Hi Martin,

 

Thank you for your feedback. We plan on excluding the following statements from the long running queries notification: "RESTORE, BACKUP, ALTER INDEX, DBCC".

 

Regards,

Chris

Pulseway Support

[Martin Stevnhoved]

Thank you, very much.

Do you know when the update will be deployed?

 

// Martin.

[Chris]

Hi Martin,

 

Unfortunately we cannot provide any ETA at this stage however we plan on adding this fix for the next windows agent release or the one that follows.

 

Regards,

Chris

Pulseway Support

[Chris]

Hi Martin,

 

We've implemented this feature. It will be included in the next Pulseway windows agent release.

 

Regards,

Chris

Pulseway Support

[Martin Stevnhoved]

Great!!! We will look forward for this update.

Do we have a countdown to the release? :-)

[Chris]

Hi Martin,

 

5 ... 4 ... 3 ... 2 ... No ETA is available at this moment but it's going to be at the beginning of June.

 

Regards,

Chris

Pulseway Support

[Martin Stevnhoved]

:-)

[Martin Stevnhoved]

Hi.

 

We are still gettings notifications for BACKUP statements.

I have verified that the Pulseway version is 4.7.5

 

Any ideas?

 

Br, Martin.

 

---

 

A query was found to be in execution for more than 30 minutes in SQL Server on the computer XXX in group Xxx.

Query: BACKUP DATABASE [XXX] TO  DISK = N'X:\Backup\XXX_backup_2015_05_28_120002.bak' WITH NOFORMAT, NOINIT,  NAME = N'XXX_backup_2015_05_28_120002', SKIP, REWIND, NOUNLOAD,  STATS = 10

Query Status: Suspended
Start Time: 28. maj 2015 12:00:05
User Id: 1
Session Id: 74

Note: Another notification for this session will be sent only after this notification is deleted.

[Chris]

Hi Martin,

 

Thanks for your report. We will attempt to reproduce this and come back to you.

 

Regards,

Chris

Pulseway Support

[Martin Stevnhoved]

Have you found the bug?

We are still getting 30-minutes alerts for BACKUP queries.

 

Br, Martin