Jump to content

SQL: Don't warn about longrunning BACKUP queries


Recommended Posts

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

Link to comment
Share on other sites

  • Staff

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

Link to comment
Share on other sites

  • Staff

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

Link to comment
Share on other sites

  • 1 month later...
  • 2 weeks later...

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.

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...