SQL Monitor 8 released

• 
  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.

  tomdpe March 23, 2018 00:13

  - 0 +
• 
  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

  SwissJonese March 23, 2018 15:07

  - 0 +
• 
  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.

  Russell D March 26, 2018 12:41

  - 0 +
• 
  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?
  

  SLowry March 27, 2018 10:10

  - 0 +
• 

  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.

  SwissJonese March 27, 2018 10:15

  - 0 +
• 

  SwissJonese said:

  
  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.
  

  Russell D March 27, 2018 10:24

  - 0 +
• 
  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?

  Markus March 27, 2018 17:09

  - 0 +
• 
  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.

  Russell D March 28, 2018 07:29

  - 0 +
• 
  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

  Russell D April 09, 2018 09:55

  - 0 +
• 
  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

  AlexJeffreys April 18, 2018 14:31

  - 0 +
• 
  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

  joshcrang April 19, 2018 17:47

  - 0 +
• 
  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.
  
  

  Clive Tong May 02, 2018 11:39

  - 0 +
• 
  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.
  
  

  Clive Tong May 02, 2018 11:39

  - 0 +
• 
  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
    

  Jon_H May 16, 2018 09:19

  - 0 +
• 
  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

  
  
  

  kirilrupasov May 31, 2018 09:14

  - 0 +
• 
  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 June 04, 2018 10:00

  - 0 +
• 
  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

  joshcrang June 12, 2018 10:54

  - 0 +
• 

  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 July 10, 2018 13:56

  - 0 +
• 
  SQL Monitor 8.0.11 has been released.  Direct download link.
  
  Fixes

  • Resolves an issue preventing read-only users viewing reports

  Jon_H July 16, 2018 10:13

  - 0 +
• 
  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
    

  
  

  kirilrupasov July 24, 2018 13:53

  - 0 +
• 
  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.

  joshcrang July 26, 2018 12:34

  - 0 +
• 
  SQL Monitor 8.0.14 has been released.  Direct download link.
  
  This release fixes an issue with disk space alerts not being raised.
  

  Jon_H August 08, 2018 10:35

  - 0 +
• 
  SQL Monitor 8.0.14 has been released.  Direct download link.
  
  This release fixes an issue with disk space alerts not being raised.
  

  Jon_H August 08, 2018 10:35

  - 0 +
• 
  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

  joshcrang August 29, 2018 10:47

  - 0 +
• 
  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

  joshcrang September 11, 2018 09:14

  - 0 +
• 
  Deleted duplicate posts.

  Alex B September 12, 2018 11:10

  - 0 +
• 
  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 

  
  

  Russell D September 21, 2018 15:43

  - 0 +
• 
  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.

  johnyarham October 11, 2018 09:38

  - 0 +
• 
  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.

  johnyarham October 11, 2018 09:38

  - 0 +
• 
  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? 
  
  

  CEnsor666 October 12, 2018 08:10

  - 0 +

Add comment

Please sign in to leave a comment.