How do you use cloud databases? Take the survey.

SQL Monitor 8 released

kirilrupasovkirilrupasov Posts: 9 New member
edited February 11, 2019 1:57PM in Redgate Monitor

Features

  • Grouped inbox for alerts
  • Support for Multiple Base Monitors
  • Support of Azure SQL DB (beta)
  • Blocking processes displayed as a tree
  • Query history displayed on the server overview page
  • A database file usage alert
  • Use Extended events to track deadlocks
  • Deployment integration with ReadyRoll and DLM Automation
  • Option to import multiple servers at once

Upgrading to SQL Monitor 8.0

SQL Monitor 8.0 is a major upgrade from SQL Monitor 7. If your current license includes a valid support and upgrades package for SQL Monitor 7.x, the same license serial number will automatically activate SQL Monitor 8.0.
If your v7.x license does not include support and upgrades, SQL Monitor will upgrade to a 14-day trial of v8.0. You cannot roll back to the previous 7.x version, so we recommend that you install a trial version of v8.0 on a separate machine. For more information, see Upgrading to a later version of SQL Monitor 

Find out more or contact us:

Read more about SQL Monitor 8 and its key features.
Report any issues and raise questions on the support forum or email support at red-gate.com
Tagged:
«1

Comments

  • tomdpetomdpe Posts: 10 Bronze 1
    While installing SQL Monitor 8 The create database step hangs.  It appears to create the database but gets stuck while running this step.  "DECLARE @command NVARCHAR(MAX)
    SET @command = 'ALTER DATABASE ' + QUOTENAME(DB_NAME()) + ' SET ALLOW_SNAPSHOT_ISOLATION ON'
    EXEC (@command)"   This is not actually doing anything.  This same statement comes up when trying to use that created db after closing the window and finishing the instal using the created database, when first launching the web site.  I am using a windows server 2016 standard server and using a separate existing SQL Server 2016 FCI.  The trace on this process just shows it connected with no activity and the activity monitor shows it as suspended with repeated ~1000ms ENABLE_VERSIONING Waits.  I would appreciate a solution as I finally have licenses to install this and would like to get using it.
  • SwissJoneseSwissJonese Posts: 3 New member
    I've just upgraded from version 7 and I believe the folder used in IIS might have changed as I got an 500.19 "cannot read configuration file".  Checked and my Physical Path in IIS was pointing to C:\Program Files\Red Gate\SQL Monitor\Web but looks like it is now C:\Program Files\Red Gate\SQL Monitor\WebSite
  • Did you ever have this configured differently (eg from version 5, 6)? I've checked back to the 7.0.0 installer and the path is C:\Program Files\Red Gate\SQL Monitor\WebSite.
    Have you visited our Help Centre?
  • SLowrySLowry Posts: 2 New member
    Is the forecasting for data file usage only visible from the alert when it triggers?  Is it possible to view the forecast without having to trigger an alert first?
  • SwissJoneseSwissJonese Posts: 3 New member
    Russell D said:
    Did you ever have this configured differently (eg from version 5, 6)? I've checked back to the 7.0.0 installer and the path is C:\Program Files\Red Gate\SQL Monitor\WebSite.

    Nope, not changed the Directory Path, but we have been using the software for a couple of years, started on Version 5.
  • Russell DRussell D Posts: 1,324 Diamond 5
    edited March 27, 2018 10:24AM

    Nope, not changed the Directory Path, but we have been using the software for a couple of years, started on Version 5.
    That could be the culprit then, v5 and 6 installed to C:\Program Files\Red Gate\SQL Monitor\Web. Quite why you didn't see this error when upgrading to v7 I don't know however.
    Have you visited our Help Centre?
  • MarkusMarkus Posts: 26 Bronze 2
    Interesting.  I don't see the Website folder in that path either, I only see a Web folder.   To make the upgrade be successful do I just create a Website folder in that path then?
  • Russell DRussell D Posts: 1,324 Diamond 5
    edited March 28, 2018 7:30AM
    It depends really - if you want to keep \Web\ just change the installation path to point to that directory. Or install as per defaults and copy your files across to the (new) \Website\ folder.
    Have you visited our Help Centre?
  • Russell DRussell D Posts: 1,324 Diamond 5
    SQL Monitor 8.0.3 has been released. Direct download link.

    Features
    • Added a .xdl download for deadlocks when using extended events
    • Added wait time and wait resource when viewing a blocking session tree
    • Improved behavior of links throughout the application to allow use of browser features such as open in a new tab, or copy link address
    Fixes
    • Improved memory consumption of the server overview page when run for extended periods of time with auto-refresh enabled
    • Auto-refresh on the server overview correctly persists page reloads
    • Server overview page correctly respects the time period when provided as a URL parameter
    • Fixed an issue where database file usage alerts may not be raised or be configurable
    Have you visited our Help Centre?
  • SQL Monitor 8.0.4 has been released. Direct download link.

    Features
    • Added option to increase number of queries viewed in top queries table

    Fixes
    • Fixed an incorrect warning when alerting on database file usage for filestream files
  • SQL Monitor 8.0.3 has been released. Direct download link.

    Features
    • Added a .xdl download for deadlocks when using extended events
    • Added wait time and wait resource when viewing a blocking session tree
    • Improved behavior of links throughout the application to allow use of browser features such as open in a new tab, or copy link address
    Fixes
    • Improved memory consumption of the server overview page when run for extended periods of time with auto-refresh enabled
    • Auto-refresh on the server overview correctly persists page reloads
    • Server overview page correctly respects the time period when provided as a URL parameter
    • Fixed an issue where database file usage alerts may not be raised or be configurable
    Software Engineer
    Redgate Software
  • SQL Monitor 8.0.5 has been released. Direct download link.

    Features
    A new logon failures summary report tile Information on space usage on the Data purging configuration page Suspended instances now appear on the global dashboard
    Fixes
       This release contains a number of bug fixes for various issues reported to support.

  • SQL Monitor 8.0.5 has been released. Direct download link.

    Features
    A new logon failures summary report tile Information on space usage on the Data purging configuration page Suspended instances now appear on the global dashboard
    Fixes
       This release contains a number of bug fixes for various issues reported to support.

  • SQL Monitor 8.0.6 has been released. Direct download link.

    Features
    • Alert types for high resource utilization on Azure SQL DB databases
    • Test button on monitored entities configuration page for Azure SQL DB
    • New data purge category has been added for storage data (e.g. Disk Capacity and Data File Size), allowing for data needed for usage projections to be stored for longer
    • Performance of the server overview page has been improved when the server has a large number of disks
    • The alert inbox now shows the duration of alerts when hovering over 'Last Updated' values
    Software developer
    Redgate Software
  • SQL Monitor 8.0.7 has been released.  Direct download link

    • IMPORTANT - The schema upgrade may take a few minutes due to population of the Alert GroupCIR column. This change significantly improves the performance of the Grouped Inbox.
    • Telemetry has been updated in accordance with the privacy policy available at https://www.red-gate.com/website/legal
    Features
    • Installed Versions now shows the latest available Service Packs and Cumulative Updates for your estate
    • Differential backup overdue alert
    • Failed job report tile
    Fixes
    • Fixes to an Active Directory authentication


  • Michael ClarkMichael Clark Posts: 123 Silver 4
    edited June 4, 2018 10:00AM
    SQL Monitor 8.0.8 has been released.  Direct download link

    Fixes
    • Prevent Unknown values appearing in some long running query and blocked process alerts when using a low alert threshold
    Michael Clark
    Technical Lead, SQL Monitor
  • SQL Monitor 8.0.9 has been released. Direct download link.

    Features
    • Disk capacity planning (preview) - see historic, current, and projected disk usage across your estate
    Fixes
    • The VMWare hosts configuration page now shows the configured VMWare hosts correctly
    • Improved the configuration page when working with Azure SQL DB servers and databases
    • Fixed an issue where Azure SQL DB servers may momentarily show as connected before failing
    Software Engineer
    Redgate Software
  • Michael ClarkMichael Clark Posts: 123 Silver 4
    edited July 10, 2018 1:58PM

    SQL Monitor 8.0.10 has been released. Direct download link.

    Features

    • Redesigned purging configuration page: the purging configuration page has been redesigned to provide more information and the Performance diagnostics data category has been split in two
    • Added new Estate tab containing the new features "Installed Versions" and "Disk Capacity Planning"
    • Added "Comments" for alert configurations so that you can record why a configuration is setup a certain way
    • Make clock skew alert configurable
    • Update PowerShell API for adding instances using the SQL Monitor Web API

    Fixes

    • Prevent installing the SQL Monitor repository to versions below SQL Server 2008 as this is minimum supported version, SQL Monitor continues to support the monitoring of SQL Server 2005 and above
    Michael Clark
    Technical Lead, SQL Monitor
  • SQL Monitor 8.0.11 has been released.  Direct download link.

    Fixes
    • Resolves an issue preventing read-only users viewing reports
    Software developer
    Redgate Software
  • SQL Monitor 8.0.12 has been released. Direct download link

    Features
    • Added the ability to export the data from the Installed Versions page to Excel
    • Added the ability to export the data from the Disk Usage page to Excel
    Fixes
    • Alert details page incorrectly shows times in UTC instead of browser-local time
    • Error message intermittently displays an incorrect error message on server overview page when loading data
    • Monitored servers page intermittently shows no servers when maintenance windows are configured
    • Top graph on server overview page doesn't show values on hover inside the selected interval
    • Performance improvements when loading alert counts in the alert inbox and when loading the global dashboard

  • SQL Monitor 8.0.13 has been released. Direct download link.

    This release fixes an issue with alert details links on the global dashboard not working correctly.
    Software Engineer
    Redgate Software
  • SQL Monitor 8.0.14 has been released.  Direct download link.

    This release fixes an issue with disk space alerts not being raised.
    Software developer
    Redgate Software
  • SQL Monitor 8.0.14 has been released.  Direct download link.

    This release fixes an issue with disk space alerts not being raised.
    Software developer
    Redgate Software
  • SQL Monitor 8.0.15 has been released. Direct download link.

    Features
    • What's new release timeline: see features and fixes available in updates to SQL Monitor
    • Failover cluster instances are now displayed by their SQL Server network name, rather than Windows cluster name. Switching back to the previous behavior can be done in Configuration > Display settings.
    Fixes
    • Fixes an issue sampling index fragmentation on some databases
    • Fixes an issue where low disk space alert may incorrectly associate database data files with a volume
    • Fixes an issue with data file usage alerts not being raised
    • Fixes an issue where the "Older" button on the alert details page may go to the same alert
    Software Engineer
    Redgate Software
  • joshcrangjoshcrang Posts: 21 Bronze 2
    edited September 12, 2018 11:07AM
    SQL Monitor 8.0.16 has been released. Direct download link.

    Features

    • Added 14 days as an option to view reports
    • Filter Installed Versions by clicking pie chart
    • Support Installed Versions 2014 SP2 CU13 and 2017 RTM CU10

    Fixes

    • Add IE 11 support for What's new release timeline
    • Fix DFU alerts firing when it is disabled when auto-growth is on
    • Fixed an issue where the sidebar on the alert inbox may fail to load
    Software Engineer
    Redgate Software
  • Deleted duplicate posts.
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Russell DRussell D Posts: 1,324 Diamond 5
    edited September 21, 2018 3:43PM
    SQL Monitor 8.0.17 has been released: https://download.red-gate.com//checkforupdates/SQLMonitorWeb/SQLMonitorWeb_8.0.17.16240.exe.

    Fixes

    • Fixed a bug where low disc space alert displayed unknown for the space used
    • Fixed a bug with Export to (CSV) not working on the Analysis tab 

    Have you visited our Help Centre?
  • johnyarhamjohnyarham Posts: 3 New member
    SQL Monitor 8.0.18 has been released: https://download.red-gate.com//checkforupdates/SQLMonitorWeb/SQLMonitorWeb_8.0.18.16605.exe.

    Fixes

    • Fix bug where backup overdue alerts were being raised incorrectly.
  • johnyarhamjohnyarham Posts: 3 New member
    edited October 16, 2018 3:31PM
    SQL Monitor 8.0.19 has been released: https://download.red-gate.com//checkforupdates/SQLMonitorWeb/SQLMonitorWeb_8.0.19.16748.exe .

    Fixes

    • Fix bug where backup overdue alerts were being raised incorrectly.
  • CEnsor666CEnsor666 Posts: 1 New member
    Morning guys, 

    I have installed version 8.0.19 this morning but I cannot see where: 

    • Added the ability to view estate-wide backup information.
    • Added the ability to view estate-wide SQL Agent job statuses. 
    Is it possible for some one to point me in the right direction? 

Sign In or Register to comment.