Posted March 25, 201510 yr 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
March 25, 201510 yr Author 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.
March 26, 201510 yr 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
March 26, 201510 yr Author Thank you, very much. Do you know when the update will be deployed? // Martin.
March 26, 201510 yr 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
May 11, 201510 yr Staff Hi Martin, We've implemented this feature. It will be included in the next Pulseway windows agent release. Regards, Chris Pulseway Support
May 19, 201510 yr Author Great!!! We will look forward for this update. Do we have a countdown to the release? :-)
May 19, 201510 yr Staff 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
May 28, 201510 yr Author 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.
May 28, 201510 yr Staff Hi Martin, Thanks for your report. We will attempt to reproduce this and come back to you. Regards, Chris Pulseway Support
June 29, 20159 yr Author Have you found the bug? We are still getting 30-minutes alerts for BACKUP queries. Br, Martin
Create an account or sign in to comment