How do you use cloud databases? Take the survey.

SQL Monitor 10 Released

2»

Comments

  • SQL Monitor 10.1.3 has been released.  Direct download link

    Features

    • SRP-13124 Job cancelled and job failing alert can now be excluded based on job owner and job name
    • Restored support for specifying network protocol on SQL Server connections on login names

    Fixes

    • Fixed error in SQL error log sampler not running for SQL Server 2005
    • SRP-13125 Fixed an issue with sampling SQL requests on Azure SQL Databases
    • SRP-12644 UPN from login is now only used to prioritise the domain authenticated against
    • SRP-12940 Additional error handling in custom metric collection
    • SRP-13085 Restored Manual Activation prompt on the licensing page
    • SRP-13134 Port number is now saved in edit credentials
  • skattie22skattie22 Posts: 11 Bronze 1
    The powershell module looks wrong, should this function really be called Connect- ? 
    <#
        .DESCRIPTION
        The Connect-SqlMonitor cmdlet attempts to initate a connection with a SQL Monitor Server.
        Must be called atleast once before any other SQL Monitor Cmdlets. 
    .EXAMPLE
    Connect-SqlMonitor -ServerUrl "http://sql-monitor.example.com:8080" -AuthToken "GeneratedAuthenticationToken"
    #>
    function Connect- {
  • SQL Monitor 10.1.4 has been released.  Direct download link

    Features

    • SRP-13143 Job duration unusual alert can now be excluded based on job owner

    Fixes

    • SRP-13121 Low CSV space alerts and notifications now show the volume label of the affected CSV
    • SRP-13099 Web pages that aggregate information from multiple base monitors no longer fail with an internal server error when any base monitor is unhealthy.
    • Fixes a memory leak on the website when calling API endpoints
    • SRP-13170 Improved performance and error handling when collecting custom metrics
    • SRP-13161 Fixed minor cosmetic issues mostly related to spacing
    • SRP-13168 Fixed failure to display query plans when accessed through the top queries-query history links
    • SRP-13172 Fix webhook custom HTTP headers for IE11
  • SQL Monitor 10.1.5 has been released.  Direct download link

    Features

    • SRP-12296 
      Query text for SQL User Processes is now available by selecting a process on the server overview

    Fixes

    • SRP-13108 
      Delays database backup overdue alerts being raised to allow for availability group DMVs to be initialized

    • SRP-13086 
      Handle monitoring errors raised when a database becomes unavailable that were previously putting the monitored server into a stopped monitoring state.

    • Resolves an issue during base monitor startup when the data repository is not available

    • Eliminated some monitoring queries when it's known up-front that they won't return any monitoring data.

    • Improved the performance of global dashboard

  • Piers_WilliamsPiers_Williams Posts: 14 Bronze 1
    edited July 1, 2020 1:41PM
    SQL Monitor 10.1.6 has been released.  Direct download link

    Features

    • Reduced the impact of high-latency base monitors on the overall latency of the website when using multiple base monitors.

    Fixes

    • SRP-13190 Fixed issue indicating SQL Server licenses required from exempt editions
    • SRP-13207 An issue where the "primary replica" section of the availability group page could appear blank for servers with a case-sensitive collation has been fixed
    • SRP-13213 Get-SqlMonitorAlertSuppressionWindow by name no longer fails to return alert suppression windows
    • SRP-13212 Fixes display issue with Manage Users page
    • SRP-13182 Fixes time-scaling issue with server waits alert
    • Removes debug timings erroneously made visible on the website by default
  • SQL Monitor 10.1.7 has been released. Direct download link

    Features

    • Preview release of monitoring Amazon RDS SQL Servers. See documentation for more details.
    • SRP-13055 SQL User Processes combines information from sessions and now requests to provide more incremental values over time.

    Fixes

    • SRP-13217 Fixed a security vulnerability (CVSS 4.7, CVE-2020-15526) whereby the scope of disabling TLS certificate checking might accidentally extend beyond that required by various Notification Configuration options to "Ignore SSL or TLS certificate errors".
    • SRP-13244 Fixed webhook "Preview and test" notification dialog UI bug when accessing response tab.
    • SRP-13181 Fixed an issue with the longest-running queries summary report not correctly displaying the number of executions within the report period.
    • SRP-13189 An issue that could cause a memory leak for sites with high usage of WinRM has been fixed.
  • SQL Monitor 10.1.8 has been released.  Direct download link

    Features

    • SRP-13235 Added option to specify Trust Server Certificate in SQL Server connection properties

    Fixes

    • SRP-13258 Further fixes have been made for availability groups on servers with a case-sensitive collation
  • SQL Monitor 10.2.1 has been released.  Direct download link

    Breaking Changes

    Starting with SQL Monitor v10.2, SQL Monitor base monitors can no longer be installed on Windows Server 2012 or earlier. For the time being, this only affects the base monitor. Support for running the SQL Monitor website on Windows Server 2012 or earlier will be removed in the future.

    We've moved to .NET Core 3.1; Microsoft do not support Windows Server 2012 or earlier as deployment targets for .NET Core 3.1. This also means that SQL Monitor base monitors cannot be installed on unsupported desktop operating systems. Refer to Microsoft's installation guidance for specific versions.

    You can monitor the same versions of Windows and SQL Server that you've always monitored. However, base monitors need to be installed on Windows Server 2012 R2 or newer.

    Features

    • The Amazon RDS SQL Server monitoring preview now includes support for alerts and groups.
      • Most SQL Server-specific alerts can now be raised for Amazon RDS SQL Servers.
      • The alerts appear in the alert inbox, and alert summaries appear in the global and server overview pages.
      • Amazon RDS SQL Servers can now be placed into groups.
      • Alert settings for each server are inherited from their group, and can be overridden in the Configure > Alert settings pages.

    Fixes

    • SRP-13298 fixed an issue loading log pages for clusters or cluster nodes.
    • Correctly display warning when upgrading from a version of SQL Monitor earlier than 10.2 that installing on older Windows versions is no longer supported.
    Greg Smulko | Technical Architect for SQL Monitor | Redgate Software
  • SQL Monitor 10.2.2 has been released.  Direct download link

    Features

    • SRP-13263 Trust Server Certificate in SQL Server connection properties now available through the API

    Fixes

    • SRP-13300 Fixed Alert Suppression Windows powershell client issues.
    • Fixed an issue with popup action menus sometimes not being visible.
    • SRP-13306 Analysis pages now correctly get show data from all base monitors.
  • SQL Monitor 10.2.3 has been released.  Direct download link

    Fixes

    • SRP-13308 Fixes a monitoring error on SQL Server 2012 SP1 caused by accessing user_objects_deferred_dealloc_page_count
    • Resolves a visual issue with the top graph on server overview pages.
  • PaulDPaulD Posts: 12 Bronze 1
    on upgrade to 10.2.3, 100% (4 out of 4) of base monitor installs failed with "SQL Monitor Base failed with exit code 0xe0434352". However all base monitors show up in configuration without reporting errors, so I'm kind of assuming that everything is OK.
  • DonFergusonDonFerguson Posts: 196 Silver 5
    PaulD, I too experience this issue.  If you run the install a second time, it will succeed.  I'm not sure if running a second time is really needed, but I get nervous when the installer reports that the installation failed, so I run it again just in case. 

    This issue only seems to manifest itself if you are running the web monitor and base monitors on separate hosts.  I have reported this issue to Red Gate Support and they have been able to reproduce it.  They have created SRP-13303 to address this.  I have not received an indication as to when it is expected to be resolved.  But am hopeful it will be soon.
  • PaulDPaulD Posts: 12 Bronze 1
    thanks Don. I haven't re-run the installers and (touch wood) all seems good so far.
  • SQL Monitor 10.2.4 has been released. Direct download link

    Features
    • The Amazon RDS SQL Server monitoring preview now includes support for Analysis and Active Directory permissions. You can also specify Amazon RDS Sql Servers in Custom metrics.
    Improvements
    • Improved support for Amazon RDS SQL Servers on the monitored servers page.
    • SRP-13342 - Disk space SNMP alert shows disk space values.
    Fixes
    • SRP-13246 - Log Backup overdue will not raise on master databases.
    • SRP-13277 - Fix issue with testing server connectivity on the manage monitored servers page when the 'auto-detect cluster name' option is deselected.
    • SRP-13339 - Classify additional sql server processes as sql processes correctly.
    • SRP-13355 - Fix issue with Azure SQL Databases failing to be listed on the analysis page.
    • Restored the ability to set an HTTP proxy for Webhooks and Slack notifications. See documentation for steps to set this up.
    Changes
    • Replaced the log4net logging library with Serilog. A security vulnerability was reported against log4net (CVE-2018-1285, CVSS base score 9.8). Whilst the use of log4net within SQL Monitor was not subject to the vulnerability, we've nonetheless removed log4net to avoid false positives in security scans. If you have customized your log4net configuration within SQL Monitor, those customizations will no longer apply. In this case, please contact Redgate support for help with replicating your customizations using the new Serilog configuration files.
    API changes
    • PowerShell API update to support Add, Get, Remove SQL Servers for Amazon RDS and Azure SQL Servers.
  • Suyash_DubeySuyash_Dubey Posts: 4 New member
    edited August 25, 2020 9:19AM
    SQL Monitor 10.2.5 has been released. Direct download link

    Fixes
    - SRP-13303 - Fixed installation error while upgrading SQL Monitor Webserver
    - Fixes wait stats sampling failing due to NULL value

    API changes
    - SRP-13341 - Add support for Get-SqlMonitorDatabase for AmazonRds databases
  • SQL Monitor 10.2.5 has been released. Direct download link

    Fixes
    - SRP-13303 - Fixed installation error while upgrading SQL Monitor Webserver
    - Fixes wait stats sampling failing due to NULL value

    API changes
    - SRP-13341 - Add support for Get-SqlMonitorDatabase for AmazonRds databases
  • SQL Monitor 10.2.6 has been released.  Direct download link

    Features

    • Reports now support Amazon RDS and Azure for analysis graph and summary tiles.

    Improvements

    • SRP-13362 - Change left navigation bar databases icon

    Fixes

    • SRP-13030 - Fixed issue with msdb.dbo.sp_help_job returning no value when querying.
    • Fixed validation message not being displayed correctly in monitored servers add form.
  • LawrenceMcKellarLawrenceMcKellar Posts: 8 New member
    edited September 3, 2020 2:16PM
    SQL Monitor 10.2.7 has been released. (direct link)

    Features

    • SRP-13363 - Released new feature for monitoring tempdb
    • Reports now support Amazon RDS and Azure for analysis graph and summary tiles.

    Improvements

    • SRP-13375 Improve performance of vmware sampling

    Fixes

    • SRP-13386 - Prevent duplicate dashboard cards for Azure SQL Databases with non-lowercase names
  • SQL Monitor 10.2.8 has been released.  Direct download link

    Fixes

    • Resolves an issue with some tiles of the example report failing to load

    • #168702 Resolves an issue with displaying Query History Details in SQL Monitor with Azure Databases.

    Changes

    • SRP-13077 Reduce frequency of DBCC calls

    API changes

    • 7670 - The Cluster, Standalone Machine, AzureSqlServer, and AmazonRdsSqlServer classes contain Group property (please download updated powershell module)

  • Jon_HJon_H Posts: 26 Bronze 1
    edited September 24, 2020 1:43PM
    SQL Monitor 10.2.9 has been released. Direct download link

    Features

    • SRP-13285 - Added Version Store graph to tempdb
    • SRP-13395 - Added tempdb monitoring for Amazon RDS

    Improvements

    • SRP-13360 - Query plan viewer has link to open it in new tab
    • SRP-13356 - Added SQL Text to tempdb sessions table

    Fixes

    • SRP-13247 - SQL Monitor now picks up query plan changes even when an existing plan handle is reused.
    • SRP-13384 - Installer will once again automatically populate credentials for SQL Auth when updating
    • SRP-13411 - Resolves an issue with "Monitoring Error" on server in SqlProcessSampler
    • SRP-13374 - Fixes inability to launch a base monitor due to duplicated alert at a target
    • SRP-13307 - Ignore database in transition state as a monitoring error
    • SRP-13387 - Fixed errors caused by the integrity check sampler running against snapshots of offline databases
    • Zendesk 169089 - Resolves an issue with "configure alert" link on alert email not working
    • SRP-13409 - Fixes error on startup when the service account does not have permission to access process start time
    • SRP-13388 - Alert Suppression Windows resolve base api url correctly when SQL Monitor Web not at server root
    • SRP-13404 - Fixes an error in the installer: Problem connecting to SQL Monitor repository data store

    Changes

    • Multiple base monitor installs no longer require Active Directory (AD) settings to be replicated on secondary base monitors to correctly resolve authorized entities. All AD operations are performed on

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

    Features

    • SRP-13226 Added application graph to tempdb

    Fixes

    • SRP-13413 fix issue causing deadlocks in tempdb
  • SQL Monitor 10.2.11 has been released. Direct download link

    Features

    • Amazon RDS machine metrics now collected from Amazon AWS API

    Improvements

    • Amazon RDS Server Overview page now shows Memory and Disk metrics
  • NazYilmazNazYilmaz Posts: 9 New member
    edited October 8, 2020 7:56AM
    SQL Monitor 10.2.12 has been released. Direct download link.

    Features

    • Added database graph to tempdb

    • Added temporary table usage to tempdb section

    Naz Yilmaz | Software Engineer | Redgate Software
Sign In or Register to comment.