User profile for Adam W

Hi, Apologies for the delay, we are intending to release v7.1.3 this week, which will include the fix. We'll update this post as soon as it's available. Regards, Adam / comments

Hi, Apologies for the delay, we are intending to release v7.1.3 this week, which will include the fix. We'll update this post as soon as it's available. Regards, Adam

0 votes

Thanks for prompting us again on this. We do agree this is something we should improve and we'll try to bring this work forward. I can't say just yet when we might commit to this, but I will post an update soon when we've had the relevant discussions. Thanks for your patience. Adam / comments

Thanks for prompting us again on this. We do agree this is something we should improve and we'll try to bring this work forward. I can't say just yet when we might commit to this, but I will post a...

0 votes

Hi Karl, The individual server overviews show the top 10 queries, and these can be sorted by different criteria such as Execution count, CPU Time, Logical reads etc. A new table is generated according to the selected option, so different queries are likely to be displayed. To look at the worst performing queries across an estate, the reports are used, and these currently only show the top 5. However, this is something we're looking into. I'm interested to know a bit more about how you would use this: - how many queries would you typically want to see across your estate (for example, are there cases where the 50th worst query is something you would take a look at, or is it more likely fewer) - what do you do with the 'Top x queries' list? Do you have a process of working through them? Is it for troubleshooting, or to head off problems? Any further detail you have on this would be really useful as we consider where to focus our efforts. Thanks Adam / comments

Hi Karl, The individual server overviews show the top 10 queries, and these can be sorted by different criteria such as Execution count, CPU Time, Logical reads etc. A new table is generated accord...

0 votes

Hi, We are considering adding the ability to enter regular expressions to match jobs you might want to ignore. Would this meet your requirements? Thanks, Adam / comments

Hi, We are considering adding the ability to enter regular expressions to match jobs you might want to ignore. Would this meet your requirements? Thanks, Adam

0 votes

Hi, You can add additional custom metrics, as detailed here: http://documentation.red-gate.com/display/SM4/Creating+custom+metrics+and+alerts So for example, you can create or download custom network metrics, such as this one that gives an indication of how much time is spent waiting to send information over a network http://sqlmonitormetrics.red-gate.com/os-wait-time-async_network_io/ I'm interested to know what metrics specifically would you find most useful to add? Thanks, Adam / comments

Hi, You can add additional custom metrics, as detailed here:http://documentation.red-gate.com/display/SM4/Creating+custom+metrics+and+alerts So for example, you can create or download custom networ...

0 votes

Hi Stollie, This report is not currently available, but we intend to add more canned reports so it would be useful to understand a bit more about what you would use this report for? If you already have a T-SQL query that provides you with this data, you can add it as a Custom Metric - this would then allow you to add it as a metric to your reports: http://documentation.red-gate.com/display/SM4/Working+with+custom+metrics+and+alerts Adam / comments

Hi Stollie, This report is not currently available, but we intend to add more canned reports so it would be useful to understand a bit more about what you would use this report for? If you already ...

0 votes

Hi, It is not currently possible, but this is something we are considering implementing, so it would be useful to know how you expected this to behave: - What details would you need the export to contain? - What would the application owner use the list for? - What format(s) would you expect to be able to export the alert? Thanks Adam / comments

Hi, It is not currently possible, but this is something we are considering implementing, so it would be useful to know how you expected this to behave: - What details would you need the export to c...

0 votes

Could you check what version you installed? Version 7.0.8 fixed some high CPU issues. The latest version is now 7.0.9 Thanks Adam / comments

Could you check what version you installed? Version 7.0.8 fixed some high CPU issues. The latest version is now 7.0.9 Thanks Adam

0 votes

Hi, Currently you can schedule the reports to be emailed daily/weekly: https://documentation.red-gate.com/display/SM7/Scheduling+emailed+reports We are continuing to make improvements to the reporting, including making the scheduling more configurable. Thanks Adam / comments

Hi, Currently you can schedule the reports to be emailed daily/weekly:https://documentation.red-gate.com/display/SM7/Scheduling+emailed+reports We are continuing to make improvements to the reporti...

0 votes

We're hoping to release an initial version of it within the next couple of weeks (possibly in version 7.0.11) I'll update you when it does get released / comments

We're hoping to release an initial version of it within the next couple of weeks (possibly in version 7.0.11) I'll update you when it does get released

0 votes

How can we help you today?

Adam W

Comments