Comments
Sort by recent activity
Hi,
We think this sounds like it would be a useful improvement. If you add it as a suggestion on Uservoice and it gets additional support, this would certainly help us prioritise looking further into it.
Were you thinking of something along the lines of how we show this in the Deadlock visualisation below? [image]
Thanks,
Adam / comments
Hi,
We think this sounds like it would be a useful improvement. If you add it as a suggestion on Uservoice and it gets additional support, this would certainly help us prioritise looking further in...
Thanks - I've added your suggestion to that Uservoice item so we can make sure we consider it. / comments
Thanks - I've added your suggestion to that Uservoice item so we can make sure we consider it.
Thanks for the additional detail - we'll get back to you with more information... / comments
Thanks for the additional detail - we'll get back to you with more information...
Ah okay, in that case, you can view and edit the defaults for the different collections by using the Configuration File editor.
First, locate the configuration file on the machine where the SQL Monitor Base Monitor service is hosted. Location: C:\ProgramData\Red Gate\SQL Monitor
File Name: RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config
Make a copy of this file and name it something useful like RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config_backup
This will act as a backup of the configuration file so that your changes can be reversed.
Next, run the SQL Monitor Configuration Editor as an administrator (right click > Run As):
C:\Program Files\Red Gate\SQL Monitor\BaseMonitor\Tools\ConfigurationFileEditor.exe
You will be prompted to "Load a configuration file". Find the .config file detailed in step 1.
You will be presented with a list of all the configuration options available. These relate to each item in the polling schedule. Any check box which is un-checked automatically uses the default - to check what the default is you can check the box, but not make any changes and the value shown will be the default value.
If you make any changes, once complete, click "Save Changes" and restart the SQL Monitor Base Monitor service. If you have any unexpected results then please delete your edited configuration file and rename the copy (then also restart the service). If you are not making changes, just close without saving.
Does that help?
Thanks,
Adam / comments
Ah okay, in that case, you can view and edit the defaults for the different collections by using the Configuration File editor.
First, locate the configuration file on the machine where the SQL Mon...
Hi,
You can see how many times an alert has been raised (depending on purge settings) in Configuration > Alert settings in the Occurrences column. [image]
You can see the most frequent alerts per server using the Alert Summary Report. [image]
Is this the kind of thing you're looking for? Could you give a bit more detail about what you mean regarding "ones more likely to have larger responses"?
Thanks,
Adam / comments
Hi,
You can see how many times an alert has been raised (depending on purge settings) in Configuration > Alert settings in the Occurrences column.
You can see the most frequent alerts per server us...
This feature was released in version 7.1.11. If you click on a query in the Top 10 Queries table, you will be able to see how that query has performed over time, and identify when plan changes have occurred - clicking on one will show the query plan. [image] [image]
The feature is still in beta, so we will continue to make improvements. Please let us know how you think it could be improved so we can consider any suggestions as we continue development.
Thanks / comments
This feature was released in version 7.1.11. If you click on a query in the Top 10 Queries table, you will be able to see how that query has performed over time, and identify when plan changes have...
Thanks Don, the team are really happy to know you're finding it useful [image]
We're still working on improving it, so if you think of anything that would make it more useful or usable for you, drop us a line - we'd really like to provide the most value out of this feature.
Cheers! / comments
Thanks Don, the team are really happy to know you're finding it useful
We're still working on improving it, so if you think of anything that would make it more useful or usable for you, drop us a...
Hi Tobin,
Getting better at showing real-time activity is something the development team is looking into right now. We'd like to understand a bit more about some of the points you raise - if you'd be willing to have a short call with us, we'd appreciate your input.
Thanks,
Adam / comments
Hi Tobin,
Getting better at showing real-time activity is something the development team is looking into right now. We'd like to understand a bit more about some of the points you raise - if you'd ...
We've just added a link to the About page in SQL Monitor, so you will be able to go there and get the latest frequent release. Hopefully this will prove useful if you've dismissed the reminder etc.
This should be in the next release... / comments
We've just added a link to the About page in SQL Monitor, so you will be able to go there and get the latest frequent release. Hopefully this will prove useful if you've dismissed the reminder etc....