User profile for Adam W

Thanks Sijo, it's useful to have this kind of detail as we're considering how to make improvements to alerting. Adam / comments

Thanks Sijo, it's useful to have this kind of detail as we're considering how to make improvements to alerting. Adam

0 votes

Hi Kevan, That's correct - it will prevent all notifications, not just emails. Short term we should reword that, but it would also be really good to know what kind of use cases you had in mind so we can understand the kind of configurability that might be required (e.g. turning off email but allowing Slack notifications etc). Thanks Adam / comments

Hi Kevan, That's correct - it will prevent all notifications, not just emails. Short term we should reword that, but it would also be really good to know what kind of use cases you had in mind so...

0 votes

Hi, That's not currently possible with custom metrics. The T-SQL on which the custom metric is based must return a single, numeric scalar or NULL value. It can call a stored procedure, as long as the returned value meets the same criteria. It cannot collect multiple values, results containing alphabetic or special characters, or recordsets. https://documentation.red-gate.com/disp ... ine+metric Hope that helps. Thanks Adam / comments

Hi, That's not currently possible with custom metrics. The T-SQL on which the custom metric is based must return a single, numeric scalar or NULL value. It can call a stored procedure, as long as t...

0 votes

Hi, The Example report does show just 3 of the 5 summary tiles. To manually add further tiles: - Click 'Add tile' button - In the 'Tile type' dropdown, choose 'Summary tile' - Another dropdown will appear underneath. Select 'Alerts summary' and click the 'Add' button - Repeat with the 'Server waits by day' tile There is a video showing how to add different types of metrics to a report here: http://www.red-gate.com/products/dba/sq ... /whats-new I hope that helps. Adam / comments

Hi, The Example report does show just 3 of the 5 summary tiles. To manually add further tiles: - Click 'Add tile' button - In the 'Tile type' dropdown, choose 'Summary tile' - Another dropdown will...

0 votes

SQL Monitor 7.1.3 has been released. Enhancements: Added name of blocked database to top of Blocking process alert details Added the database name to the Longest running queries report Fixed the following issues: Clearing the bottom alert in the list of alerts made all other alerts appear cleared When clearing alerts that number less than total alert rows to be displayed, they did not disappear Incorrect requirement referred to in the installer Formatting in Job Failing alerts Job Duration alert not showing baseline Waits could show as zero on the top graph on server overviews 12 or 24 hour clock display setting was not persisted on Analysis page / comments

SQL Monitor 7.1.3 has been released. Enhancements: Added name of blocked database to top of Blocking process alert details Added the database name to the Longest running queries report Fixed the ...

0 votes

Version 7.0.13 has been released. It contains the following fixes: SRP-11228 Http 500 error when using 'Save as PDF' in Reports SRP-11239 Query execution plan viewer showing NaN for sizes SRP-11240 Unusually slow Top Queries retrieval in server overview Please see the documentation for upgrade information: https://documentation.red-gate.com/display/SM7/SQL+Monitor+7.0+release+notes / comments

Version 7.0.13 has been released. It contains the following fixes: SRP-11228 Http 500 error when using 'Save as PDF' in Reports SRP-11239 Query execution plan viewer showing NaN for sizes SRP-11240...

0 votes

SQL Monitor 7.0.10 has been released. It contains the following improvements/fixes: • SRP-11129 - Use xp_readerrorlog to read error log • SRP-11130 - Show loading indicator for Top Queries and Server Waits • SRP-11131 - No top 10 query data and no query related alerts • SRP-11134 - Server not added to group when adding server on Configuration > Monitored servers • SRP-11135 - New custom metrics not showing any data on the analysis tab • SRP-11139 - Windows 2008 clusters don't report fully-qualified domain name through WMI Please see the documentation for upgrade information: https://documentation.red-gate.com/display/SM7/SQL+Monitor+7.0+release+notes / comments

SQL Monitor 7.0.10 has been released. It contains the following improvements/fixes: • SRP-11129 - Use xp_readerrorlog to read error log • SRP-11130 - Show loading indicator for Top Queries and Serv...

0 votes

Version 7.0.12 has been released. Features: New 'Server summary' tile in reports, giving summary information (such as operating system version, availability, and uptime) on user-specified servers. Alert emails contain a link to the relevant configuration page Fixes: Resolve memory usage issue arising from WMI client library Increase limitation on database name size on monitored servers to 128 characters Feature-usage reporting for VMware SRP-10404 Threshold for capturing the text for long-running queries decreased from 15 seconds to 5 SRP-11159 Fix an issue with undisposed WMI object in cluster detection SRP-11188 Guard against no results being returned for network details in VMware host SRP-11194 Fix an issue with time-zone collection in certain circumstances SRP-11204 Fix the "send test email" button in the report configuration panel SRP-11205 Show units for plan sizes and average row size in the query plan display SRP-11206 Allow access to availability-group overview for machines with .ad domain suffix SRP-11208 Make removal of vCenter/ESXi host persist through base monitor restart SRP-11215 Capture VMware metrics when the monitored servers entry does not have the fully-qualified hostname Please see the documentation for upgrade information: https://documentation.red-gate.com/display/SM7/SQL+Monitor+7.0+release+notes / comments

Version 7.0.12 has been released. Features: New 'Server summary' tile in reports, giving summary information (such as operating system version, availability, and uptime) on user-specified servers. ...

0 votes

SQL Monitor 7.0.9 has been released, following 7.0.8 7.0.9 contains a minor fix for WMI UTC timestamp offset problem 7.0.8 is mostly a performance and stability release with some important fixes: • SRP-10724 - SQL Monitor Performance Issues on Monitored Entities • SRP-10937 - Random bad data errors causing monitoring to stop for SQL instances • SRP-11032 - "The requested resource is in use" error for remote registry collection • SRP-11075 - Slow loading Configuration>Alert Settings page • SRP-11082 - SQL Monitor Frequent Monitoring Stopped & Clock Skew Alerts • SRP-11085 - DMV Performance Query causing 100% cpu • SRP-11088 - Report emails not sending • SRP-11093 - Upgrade to 7.0.6 failed when converting SQL Handles to varbinary • SRP-11094 - CPU hitting 100% when purging data • SRP-11103 - Clock skew alert inaccurate • Replace the use of the remote registry with WMI. • In addition, it contains a critical fix which was preventing purging from working for some customers. Please see the documentation for upgrade information: https://documentation.red-gate.com/display/SM7/SQL+Monitor+7.0+release+notes / comments

SQL Monitor 7.0.9 has been released, following 7.0.8 7.0.9 contains a minor fix for WMI UTC timestamp offset problem 7.0.8 is mostly a performance and stability release with some important fixes: •...

0 votes

SQL Monitor 7.06 has now been released. This release features performance improvements, feature enhancements and fixes: Enhancements: Added search to the global dashboard page Added query plan generation date to query plans (supported on monitored entities running SQL Server 2014 or later) Truncating large queries (over 1000 lines) when sent as part of an email alert. Full query text is still retained and shown in the web interface Performance improvements: Improved load times and responsiveness of global dashboard and server overview pages Introduction of binary data type into data layer to more efficiently store SQL and query handles Replaced ICMP ping with TCP port ping, removing the requirement for ICMP to be enabled on the monitored network and adding better support for Azure based virtual machines Optimizing repository storage and retrieval queries including removal of query hint optimizations for legacy versions of SQL Server Optimizing data repository SQL connection pooling to prevent the connection pool becoming oversubscribed over time Removal of unnecessary indices on repository to increase data insertion throughput and solve deadlocking issue whereby SQL monitor could deadlock itself SRP-11075 Improved load times of the alert configuration page Fixes: SRP-11027 Fixed an issue where some instances wouldn't be correctly identified as part of an availability group SRP-11055 Fixed an issue where alert emails may not include all data SRP-11084 Fixed an issue where the global dashboard may report negative machine CPU usage Fixed an issue where query plans would not be sampled on monitored entities running SQL Server 2005 For more information about upgrading from version 7.0.5 or earlier: https://documentation.red-gate.com/display/SM7/SQL+Monitor+7.0+release+notes / comments

SQL Monitor 7.06 has now been released. This release features performance improvements, feature enhancements and fixes: Enhancements: Added search to the global dashboard page Added query plan g...

0 votes

How can we help you today?

Adam W

Comments