How can we help you today? How can we help you today?
Adam W
Activity overview Badges (0) Posts (0) Comments (103)

Comments

Sort by recent activity
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
  1. Community
  2. Redgate Monitor
  3. SQL Monitor 7 released
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
  1. Community
  2. Redgate Monitor
  3. SQL Monitor 7 released
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
  1. Community
  2. Redgate Monitor
  3. SQL Monitor 7 released
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
  1. Community
  2. Redgate Monitor
  3. SQL Monitor 7 released
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
  1. Community
  2. Redgate Monitor
  3. SQL Monitor 7 released
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
Hi, To enter multiple regular expressions, type each separate expression on a new line. In Configuration > Alert settings > Long-running query you should see an embedded help icon next to the field that explains how to add exclusions. I've pasted it below (apologies if you already had this and were looking for something more specific). Excluding specific queries To stop this alert being raised for certain queries, enter regular expressions to match those queries you want to ignore. You can match against both the process name - that is, the SQL connection name - (in the first box) and any SQL statements contained within the query (in the second box). To enter multiple regular expressions, type each separate expression on a new line. Regular expression syntax All regular expressions are case-sensitive. Type the pattern of letters to find, or use the following special characters: . matches any single character (wildcard character) ^ matches the start of a string [ ] matches any of the characters contained within [a-z] or [0-9] matches any character in the specified range |matches any of the elements separated * matches the preceding character zero or more times ? matches the preceding character zero or once Note: this is not an exhaustive list of regular expression syntax. SQL Monitor supports all standard .NET regex characters. Tips White space is included; adding a space will change what the expression matches Special characters need to be escaped e.g . $ ^ { [ ( ) ] } * + ? | Examples [Bb]ackup matches any string that contains "Backup" or "backup" Backup|restore matches any string that contains "Backup" or "restore" (but not "backup" or "Restore") / comments
  1. Community
  2. SQL Monitor 6
  3. How do I add multiple exclusions whilst configuring an alert
Hi, To enter multiple regular expressions, type each separate expression on a new line. In Configuration > Alert settings > Long-running query you should see an embedded help icon next to the field...
0 votes
Hi, Yes you can alias the server names - there's a screenshot here which shows you how to do this: https://documentation.red-gate.com/disp ... +dashboard I hope that helps. Thanks, Adam / comments
  1. Community
  2. SQL Monitor 6
  3. Alias
Hi, Yes you can alias the server names - there's a screenshot here which shows you how to do this:https://documentation.red-gate.com/disp ... +dashboard I hope that helps. Thanks, Adam
0 votes
Hi, Please do log a support call so we can look into it further. In the meantime, we have added a "Send test email" button to the report email settings - this is available in the latest release, version 6.0.18 Thanks for your feedback - we're glad you're finding the reporting feature useful. Thanks Adam / comments
  1. Community
  2. SQL Monitor 6
  3. SQL Monitor 6.9.17.6667 Analysis Reporting
Hi, Please do log a support call so we can look into it further. In the meantime, we have added a "Send test email" button to the report email settings - this is available in the latest release, ve...
0 votes
Hi, We’ve just released 6.0.17 which fixes this issue. Thanks for your patience, Adam / comments
  1. Community
  2. SQL Monitor 6
  3. NEW report facility sends scheduled reports at 15 min interv
Hi, We’ve just released 6.0.17 which fixes this issue. Thanks for your patience, Adam
0 votes
Hi, Thanks for reporting this. We’ve investigated this issue which was caused by the way we were handling different time-zones. We’ve put a fix in place which will make it into the next release - I can't give you a precise date for that but it will be very soon. Thanks Adam / comments
  1. Community
  2. SQL Monitor 6
  3. NEW report facility sends scheduled reports at 15 min interv
Hi, Thanks for reporting this. We’ve investigated this issue which was caused by the way we were handling different time-zones. We’ve put a fix in place which will make it into the next release...
0 votes
Total activity
181
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
78