How do you use cloud databases? Take the survey.

SQL Monitor 10 Released

SQL Monitor 10.0.1 has been released.  Direct download link

Features
  • Breaking changes in Powershell API adding support for cmdlets prefix and pipeline
Fixes
  • Fixed error when trying to create an alert suppression window without specifying a name
Tagged:
«1

Comments

  • SQL Monitor 10.0.2 has been released.  Direct download link

    Features

    • PowerShell API support for alert suppression.
    • PowerShell API performance improvements.
    • Monitored servers configuration page will now provide a warning if multiple base monitors are monitoring the same target.
    • Long running query alert and sql blocking process query can now ignore databases using a regular expression.
    • Performance of the global overview page has been improved for sites with significant latency between website and base monitor.

    Fixes

    • Fixed a usability issue on Server Overview -> Query Plan dialog.
    • The PowerShell API now retrieves servers for which monitoring has recently been suspended, so that monitoring can also now be resumed via the API.
    • Improved handling of an invalid IP address for SNMP notifications
    Chris Lambrou
    Software Engineer, SQL Monitor Team
  • Chris LambrouChris Lambrou Posts: 25 Bronze 3
    edited March 6, 2020 10:38AM

    SQL Monitor 10.0.3 has been released.  Direct download link

    Features

    • Removed the Add-SqlMonitorAlertSuppressionWindow cmdlet. New-SqlMonitorAlertSuppressionWindow now creates a new window that is immediately persisted without the need for a separate call to Add-SqlMonitorAlertSuppressionWindow.

    Fixes

    • Improved sampling of machines that have migrated from VMWare.
    • Fixed an issue that could cause error pages to display incorrectly
    Chris Lambrou
    Software Engineer, SQL Monitor Team
  • DonFergusonDonFerguson Posts: 196 Silver 5
    So which version is it?  10.0.3 or 10.0.2.26696.  This post as well as the release notes say 10.0.3; however the download link in the product is for version 10.0.20.26696.
  • DonFergusonDonFerguson Posts: 196 Silver 5
    So it appears that the 10.0.3 links have been subsequently fixed.  Hence this issue is now resolved.  Thanks!
  • SQL Monitor 10.0.4 has been released.  Direct download link

    Features
    • SRP-12852 Added WMIType parameter option for Add-SqlMonitorMonitoredObject cmdlet.
    • SRP-12723 Job Duration Unusal alert now triggers on currently running alerts instead of only on finished alerts
    • New SQL Server licensing page added

    Fixes

    • SRP-12861 Fixes mapping of "Day" property when creating alert suppression windows through PowerShell API

    Software developer
    Redgate Software
  • SQL Monitor 10.0.5 has been released.  Direct download link

    Features

    • SRP-12780 Added support for Azure Government cloud SQL database
    • SRP-12425 Reporting API allows request to come from defined IP/host
    • SRP-12643 Reports user added that allows read-only access with reporting
    • SRP-12789 Added support for Custom Webhook Messages

    Fixes

    • SRP-12875 Fixed an error in not using WinRM during SQL Server detection when selected
    • SRP-12871 Fix sizing issues with licensing summary graphs
    • SRP-12802 Option to suppression of performance-related alerts now correctly suppresses Azure performance alerts and disk read/write alerts
    • Fixed an internal binding error in the PowerShell API module when retrieving empty lists.
    • SRP-12885 Improved checking of VMWare metric availability
  • SQL Monitor 10.0.6 has been released.  Direct download link

    Fixes
    • SRP-12887 Fix issue with vmware sampling breaking non vmware machine sampling
  • Jon_HJon_H Posts: 26 Bronze 1
    edited March 25, 2020 2:44PM
    SQL Monitor 10.0.7 has been released.  Direct download link

    Features
    • SRP-12886 WinRM connections now support HTTP
    • SRP-12787 Improve webhook diagnostic response

    Fixes
    • SRP-12872 SQL Server licensing now uses logical processors instead of number of cores for virtual machines
    Software developer
    Redgate Software
  • SQL Monitor 10.0.8 has been released. Direct download link

    Features
    • SRP-12811 SQL Server licensing now has licence calculation for VMware Hosts
    Fixes
    • SRP-12900 Unusual job duration alerts are no longer incorrectly raised
    • SRP-12885 Internal monitor errors are no longer raised when a WmiProperty is present but fails to return data

    Chris Lambrou
    Software Engineer, SQL Monitor Team
  • SQL Monitor 10.0.8 has been released. Direct download link

    Features
    • SRP-12811 SQL Server licensing now has licence calculation for VMware Hosts
    Fixes
    • SRP-12900 Unusual job duration alerts are no longer incorrectly raised
    • SRP-12885 Internal monitor errors are no longer raised when a WmiProperty is present but fails to return data

    Chris Lambrou
    Software Engineer, SQL Monitor Team
  • SQL Monitor 10.0.9 has been released. Direct download link

    Drops SSL3 and TLS 1.0 support for communication between the base monitor and website. Communication between the base monitor and website will now use TLS 1.2 or TLS 1.1 as available.

    Features
    • SRP-12841 Filtering version filter as version and edition in SQL Server Licensing page

    Fixes
    • SRP-12935 The alert inbox now retains use of the next and last alert arrows if the "Configure Alerts" link is used
    • SRP-12925 It is now possible to enter thresholds over 100% for the job duration unusual alert
    • SRP-12937 Prevent job duration unusual alert being raised due to improperly terminated SQL Agent sessions
    • SRP-12673 Test and Add will both resolve cluster names using the same mechanism
    • SRP-12422 Fix casing issue in database name when raising backup overdue alerts for availability group databases
    • SRP-12159 SQL Monitor will now report "Cannot connect" and raise an alert if the wrong port number is provided for a SQL instance
    Software developer
    Redgate Software
  • DonFergusonDonFerguson Posts: 196 Silver 5
    This version is failing to load.  It appears to be a bad build and I can't rollback without rolling back the database.


  • PLEPLE Posts: 12 Bronze 1
    edited April 9, 2020 9:00AM
    Same problem with this build. Failing to load 404 error on account page. 
    <file:///C:/Program%20Files/Red%20Gate/SQL%20Monitor/WebSite/Account/LogIn> There's no account folder.
  • DonFergusonDonFerguson Posts: 196 Silver 5
    I believe this issue may be a result of Active Directory authentication not working.
  • PLEPLE Posts: 12 Bronze 1
    Jon_H said:
    SQL Monitor 10.0.9 has been released. Direct download link

    Drops SSL3 and TLS 1.0 support for communication between the base monitor and website. Communication between the base monitor and website will now use TLS 1.2 or TLS 1.1 as available.

    Features
    • SRP-12841 Filtering version filter as version and edition in SQL Server Licensing page

    Fixes
    • SRP-12935 The alert inbox now retains use of the next and last alert arrows if the "Configure Alerts" link is used
    • SRP-12925 It is now possible to enter thresholds over 100% for the job duration unusual alert
    • SRP-12937 Prevent job duration unusual alert being raised due to improperly terminated SQL Agent sessions
    • SRP-12673 Test and Add will both resolve cluster names using the same mechanism
    • SRP-12422 Fix casing issue in database name when raising backup overdue alerts for availability group databases
    • SRP-12159 SQL Monitor will now report "Cannot connect" and raise an alert if the wrong port number is provided for a SQL instance
    Same problem with this build. Faling to load http error 404 on account page.

  • PLEPLE Posts: 12 Bronze 1
    Jon_H said:
    SQL Monitor 10.0.9 has been released. Direct download link

    Drops SSL3 and TLS 1.0 support for communication between the base monitor and website. Communication between the base monitor and website will now use TLS 1.2 or TLS 1.1 as available.

    Features
    • SRP-12841 Filtering version filter as version and edition in SQL Server Licensing page

    Fixes
    • SRP-12935 The alert inbox now retains use of the next and last alert arrows if the "Configure Alerts" link is used
    • SRP-12925 It is now possible to enter thresholds over 100% for the job duration unusual alert
    • SRP-12937 Prevent job duration unusual alert being raised due to improperly terminated SQL Agent sessions
    • SRP-12673 Test and Add will both resolve cluster names using the same mechanism
    • SRP-12422 Fix casing issue in database name when raising backup overdue alerts for availability group databases
    • SRP-12159 SQL Monitor will now report "Cannot connect" and raise an alert if the wrong port number is provided for a SQL instance
    Same problem with this build. Faling to load http error 404 on account page.

  • cmthomas68cmthomas68 Posts: 8 Bronze 1
    Any updates on when this build will be fixed? I've had the same issues as the people above. Have tried reverting to not using IIS, still same issue.
  • SQL Monitor 10.0.10 has been released. Direct download link

    Features
    • SRP-12939 For sites using Active Directory authentication, adding an alert comment now pre-populates the author
    • SRP-12942 Moved Fix Cluster name to windows connection properties and renamed to Auto detect cluster name
    Fixes
    • SRP-12918 Query plans will now display correctly for blocked processes on Server Overview
    • SRP-12903 Queries without a start_time in sys.dm_exec_requests will now report the SQL Server start up time as their start time
    • SRP-12850 Fix alert suppression issue for cluster nodes
    • SRP-12948 Fall back to base monitor service account for AD authentication when no credentials can be read from Credential Manager
  • PLEPLE Posts: 12 Bronze 1
    Just installed it... Doesn't make it better. Multiple connection errors on hosts -> 
    Internal SQL Monitor errorInvalidOperationExceptionOption<PropertySchema>.None has no value
    . And this on more than 10 hosts. 
  • SQL Monitor 10.0.11 has been released. Direct download link

    Features

    • SRP-12874 Detect virtual machine status from SQL 2008R2 SP1 or higher
    • SRP-12977 When applying an alert suppression window to a cluster node machine, the window now automatically applies to any SQL Server instances associated with that cluster node.

    Fixes

    • SRP-12880 For SQL2008R2 or earlier, SQL Monitor will now alert on deadlocks using the error log even if extended events is turned on
    • SRP-12913 Fix issues with groups containing "." in SQL Server Licensing page
    • SRP-12976 Fix Internal SQL Monitor error "Option.None has no value"
    • SRP-12987 Fix logon failure report tile clipping issue
    • SRP-12923 Fix issue with job duration alerts sometimes incorrectly showing as purged
  • dm1019dm1019 Posts: 2 Bronze 1
    edited April 29, 2020 12:37PM
    Installed 10.0.11 and now we're completely down, with no monitoring at all.  Error in the log:

    System.IO.FileLoadException: Could not load file or assembly 'VMware.Vim, Version=7.0.0.2660,

    Redgate support told me I needed to completely uninstall and reinstall SQL Monitor (keeping the database of course).  I did that and it's working now.  So for anyone with this issue, uninstall and reinstall, connecting back to your database.

    Seems someone in Redgate QA didn't QA properly and let this go out the door.

  • DonFergusonDonFerguson Posts: 196 Silver 5
    Yes dm1019 that happened to me as well on some of our systems, but not all.  I tried uninstalling for the systems that had this issue and then reinstalled and that worked for me as well, so I didn't open a ticket.  But thanks for the post.  It's good to know I wasn't the only one.
  • AaronCAaronC Posts: 15 Bronze 5
    edited April 30, 2020 10:12AM
    SQL Monitor 10.0.12 has been released. Direct download link

    Features

    • SRP-12866 SQL Server Licensing page now displays aliases where available

    Fixes

    • SRP-12818 Fix issue where clustered machines can become stuck in an authentication failed state
    • SRP-12975 Fix default installation path issue
    • SRP-12958 Alert suppression window's start date displayed incorrectly when the web client is in a different timezone to the server.
  • jeremiahpeschkajeremiahpeschka Posts: 5 Bronze 1
    edited May 6, 2020 3:12PM
    SQL Monitor 10.0.13 has been released. Direct download link

    Features

    • SRP-12834 Sql Server Licensing page now displays replication information where available
    • SRP-13007 Memory cache performance improvements
    • SRP-13013 Show the end time of alert suppression windows in list and create/edit modes
    • SRP-13017 It is now possible to type the duration of an alert suppression window
    • SRP-13046 Collect the "Memory Grants Pending" performance counter
    • SRP-12848 SQL Server Licensing page now able to sort columns

    Fixes

    • SRP-12661 Custom alert filters now allow use of custom alerts from all base monitors.  Existing custom alert filters may need to be checked.
    • SRP-12922 Fixes the issue of raising false positive alerts just after alert suppression window period
    • Memory values on the "System processes" tab of alerts no longer erroneously labels byte values as kilobytes
  • SQL Monitor 10.0.14 has been released. Direct download link

    Features

    • SRP-13045 Login name added to SQL User Process of Server Overview
    • SRP-12957 Alert Suppression Windows can now be appled to groups as well as individual monitored servers

    Fixes

    • SRP-12968 Test SNMP button now tests SNMP instead of raising an exception
    • PowerShell API: The parameter -NetworkProtocol of the cmdlet Add-MonitoredObject was deprecated and will be removed in the future release
    • SRP-13022 SQL Agent Jobs page now defaults to a day's data instead of a week to reduce load
    Michael Clark
    Technical Lead, SQL Monitor
  • SQL Monitor 10.1.0 has been released.  Direct download link

    Fixes

    • SRP-13063 Start date displayed in Alert Suppression Window list should ignore timezone
    • SRP-12698 Suppressed notifications for alerts that occur during an alert suppression window are now raised after the window ends if the alerts are still active.
    • SRP-13065 Fix issue with generation of reports for email when the website is accessed through a CNAME entry
    • SRP-13054 Fixed issue that could cause job duration alerts to display with job start date after alert was raised
  • SQL Monitor 10.1.1 has been released. Direct download link

    Features

    • SRP-13048 Add custom headers to webhook notifications.
    • SRP-12555 "Test" button will log errors encountered during testing the connection.
    • SRP-13012 Show current status of alert suppression windows (Active/Scheduled/Expired).

    Fixes

    • SRP-13078 Fixed issue with incorrect units in alert emails.
  • SQL Monitor 10.1.2 has been released.  Direct download link

    Features

    • SRP-12924 Active Directory sign in now supports multiple Active Directory domains
    • SRP-13064 Long running query and blocking process alerts now allow regular expression exclusion on login names
    • SRP-13049 Allow Webhook notifications to ignore SSL/TLS errors

    Fixes

    • SRP-13109 Fixed issue with activating trial license extension
  • DonFergusonDonFerguson Posts: 196 Silver 5
    edited June 4, 2020 4:48PM
    I am getting an error with legacy SQL 2005 instances. 
    Cannot assign a default value to a local variable. Must declare the scalar variable "@endDate".
    I realize that it's time to upgrade them, but this is a new issue introduced with 10.1.2.
  • I am getting an error with legacy SQL 2005 instances. 
    Cannot assign a default value to a local variable. Must declare the scalar variable "@endDate".
    I realize that it's time to upgrade them, but this is a new issue introduced with 10.1.2.
    Hi @DonFerguson, you're right, unfortunately we've introduced a query that is not compatible with SQL 2005. We'll have a fix for that in our next release.

Sign In or Register to comment.