Comments
Sort by recent activity
Hi Sharon,
The next version of SQL Response currently being developed is version 2.0, a major new release with a complete re-design and a range of new features.
There is already a feature request in place for SQL Response to be able to set the frequency of alert email notifications, which will be addressed at v2.0. For reference, this feature request is: SSR-1377.
Announcements about v2.0 will appear on the forums when a public release is available; this won't be for a few months at least.
Redgs,
Brian / comments
Hi Sharon,
The next version of SQL Response currently being developed is version 2.0, a major new release with a complete re-design and a range of new features.
There is already a feature request ...
Hi Sharon,
Yes, that is correct; if an alert is not cleared, no further emails are sent. Only when the alert is cleared, and then re-raised, is a subsequent email triggered. There isn't a way to configure this behaviour in SQL Response at the moment.
As some types of alerts can be raised numerous times, this was a deliberate design decision to stop users being spammed with hundreds of emails relating to multiple occurrences of the same type of problem.
We'll definitely look again at this issue for future versions of SQL Response.
Best regards,
Brian Harris / comments
Hi Sharon,
Yes, that is correct; if an alert is not cleared, no further emails are sent. Only when the alert is cleared, and then re-raised, is a subsequent email triggered. There isn't a way to co...
Hi Dave,
There's a knowledge base article in our support centre that addresses this topic: http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=knowledgebase\SQL_Response\KB200811000321.htm
I hope this resolves your issue. If you have any difficulties or further questions, please post them back in this thread.
Regds,
Brian Harris / comments
Hi Dave,
There's a knowledge base article in our support centre that addresses this topic:http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=knowledgebase\SQL_Response\KB20081100...
Hi R J,
Sorry to hear you've been having problems getting email to work in SQL Response.
There is a support page specifically about setting up email. You need to apply the email recipients you want to a configuration template before emails will be sent. You can then tweak individual alerts on Servers to be sent to different email recipients, if required. http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=SQL_Response/help/1.1/SR_Emails.htm&toc=SQL_Response/help/1.1/toc553021.htm
Please can you let me know if this page answers your question. If not, please post again, and we will try to diagnose your specific issue:
Kind regards,
Brian Harris / comments
Hi R J,
Sorry to hear you've been having problems getting email to work in SQL Response.
There is a support page specifically about setting up email. You need to apply the email recipients you want...
Hi Mike,
Thanks for your posting, and for your positive feedback so far on SQL Response.
It's a great idea to encourage comments and feedback from users of SQL Response to incorporate into the information we deliver about the recommendations. Definitely something we'll look into.
In the meantime, if you have any comments on any of the text we've provided, then please post them here, or message me privately.
The idea is that we will continue to develop these resources for DBAs over time, so all suggestions and comments are very welcome. What you're looking at right now is just our first basic attempt to deliver something that may point the DBA in the right direction ...
Best regards, and thanks again for the feedback,
Brian Harris
Technical Author
SQL Response Team
Red Gate Software / comments
Hi Mike,
Thanks for your posting, and for your positive feedback so far on SQL Response.
It's a great idea to encourage comments and feedback from users of SQL Response to incorporate into the info...
Hi.
Thanks for your feedback.
Page 3 of the Getting Started PDF lists all the incident types that SQL Response beta can raise: http://www.red-gate.com/products/SQL_Response/GettingStartedwithSQLResponse.pdf
(Page 9 lists all recommendations.) At beta, we haven't described the thresholds for incidents or recommendations, as we're interested to see how well they meet typical requirements out of the box with no configuration.
In the released version, we'll very likely include embedded assistance somewhere in the Incidents pane to list all available incident types.
Regds,
Brian Harris
Technical Documentation
Red Gate Software / comments
Hi.
Thanks for your feedback.
Page 3 of the Getting Started PDF lists all the incident types that SQL Response beta can raise:http://www.red-gate.com/products/SQL_Response/GettingStartedwithSQLResp...
Hi PDinCA,
Thank you for bringing this to our attention. We're looking into it at the moment. This is not the intended behaviour. The naming format should apply only to new jobs or jobs whose default names you have not previously edited. I can see how the behaviour you're experiencing is very annoying.
Apologies, and we'll do our best to fix this. / comments
Hi PDinCA,
Thank you for bringing this to our attention. We're looking into it at the moment. This is not the intended behaviour. The naming format should apply only to new jobs or jobs whose defau...
Hi,
Thanks for the question. We think that you should be able to just install SQL Monitor v2 on the machine you describe without having to configure any particular roles.
Detailed installation instructions can be found here: http://www.red-gate.com/supportcenter/C ... 134037.htm
Note that this topic also contains various links to other troubleshooting information that may help you set up SQL Monitor.
If you do encounter any issues when attempting the installation, or have further questions, please let us know and we'll address them here.
Regards, / comments
Hi,
Thanks for the question. We think that you should be able to just install SQL Monitor v2 on the machine you describe without having to configure any particular roles.
Detailed installation inst...
Hi Dave,
What you've described is the intended behavior.
Once you have customized an alert at a particular level, changing the alert at a level above in the hierarchy does not overwrite the customized setting. So, in your case, when you have customized the alert for a particular production instance, changing the alert at either the group level, or the All Servers level won't affect that instance.
This is deliberate, as it allows you to set up various exceptions to your basic alert settings - and keep those exceptions even when you tinker with the basic settings.
I think your confusion may arise from the fact that when you customize your instance, the excluded commands are not actually propagated from the higher levels - the "BACKUP" and "DBCC" commands appear in the box as a default starting point for you to adjust the alert. As soon as you set "Customize at this level" though, the connection to any level higher up the hierarchy is broken. So, when you edit the All Servers level, this has NO EFFECT at all on any lower customized levels .
My suggestion is perhaps to do the following:
1. Change the setting for your customized instance to "Inherit settings" and inherit from all servers.
2. Edit the All servers level with your set of exclusions.
3. Go back to your customized instance and set it back to "Customize settings for this level"
4. By default, the same set of exclusions is offered. Add any extra you want. Save the alert.
If you like, we can also raise a feature request for a "Remove all customizations" option at the All Servers level, which will propagate the changes at the top level downwards, and overwrite any customizations?
Hope this makes sense.
Also, maintenance windows are coming very shortly, in version 2.2.
Regds, / comments
Hi Dave,
What you've described is the intended behavior.
Once you have customized an alert at a particular level, changing the alert at a level above in the hierarchy does not overwrite the customi...
Hi,
Regarding the visible length of your database names, you could try the following:
In the Monitored servers list on the left, drill down to the SQL Server instance. Beneath the instances you should now see a list of all the databases on that instance.
You can now click the small plus icon (it's a plus in a small circle opposite the Global Filters list) to increase the width of the Monitored servers list.
This should now allow you to see the names of all your databases. Those with unread alerts are shown in bold and the number of unread alerts in brackets after the name.
It's not quite what you're after, but I hope it may help until we address the issue.
Regds,
Brian Harris
Technical author, SQL Monitor / comments
Hi,
Regarding the visible length of your database names, you could try the following:
In the Monitored servers list on the left, drill down to the SQL Server instance. Beneath the instances you sho...