SQL Monitor 9.1.x

Released: Jul 24, 2019

Updates in 9.1.x

9.1.10

Updated Oct 17, 2019

Fixes

  • Fix memory usage issue with permissions sampler when there are circular Active Directory groups.

9.1.9

Updated Oct 16, 2019

Features

  • Added ability to unpin top graph on server overview page.

Fixes

  • Fix top graph on server overview page shrinking problem for Chrome.
  • Improved performance for queries against availability groups.
  • An issue that caused the test button on the monitored servers page to incorrectly report errors for standalone machines in a separate domain has been fixed.
  • Purge aggregate database storage data according to settings for the storage category.
  • Fix issue that prevented AD users from being granted direct access to more than one Azure SQL server.

9.1.8

Updated Oct 10, 2019

Features

  • Powershell API Module is now capable of skipping ssl certificate validation checks for development/evaluation purposes.

Fixes

  • Fix rendering of custom metric alert descriptions.
  • Fix groups in Estates pages disappearing when filtering.

9.1.7

Updated Oct 2, 2019

Features

  • Estates pages use dynamic unit selection for memory usage.
  • Added PowerShell example script for copying alert settings between monitored objects through API.

Fixes

  • Clear backup overdue alerts when they are present on a secondary node.
  • Fix issue with enumerating some AD groups in permissions sampler.
  • The error that appears when a base monitor that has been added cannot be reached has been fixed.
  • An issue that could lead to custom metrics incorrectly displaying as being disabled has been fixed.

9.1.6

Updated Sep 25, 2019

Features

  • A number of VMWare metrics, including Effective VM Speed, have been added to the server overview page.
  • Added example scripts for Alert Configuration API for updating alert specific settings.

Fixes

  • A problem that could cause recent alerts not to appear on the server overview page has been fixed.

9.1.5

Updated Sep 18, 2019

Features

  • Added support to the PowerShell API for the retrieval and update of Alert Specific Settings for the following alert types: DatabaseNotBackedUp, DatabaseNotLogBackedUp and DatabaseNotDifferentialBackedUp.

Fixes

  • Reduced warnings from SqlDatabaseStorageSampler.

9.1.4

Updated Sep 12, 2019

Features

  • Added new option to display both SQL Server network name and instance name for failover clusters.
  • Added support to the PowerShell API for the retrieval and update of Alert Specific Settings for the following alert types: AvailabilityGroupDatabaseNotHealthy, AvailabilityGroupFailover, AvailabilityGroupListenerOffline, AvailabilityGroupNotHealthy, AvailabilityGroupReplicaNotHealthy, ClusterFailover, CustomMetricCollectionError, DatabaseUnavailable, HighCpu, HighCpuAzureSqlDb, HighCpuElasticPool, HighDataIoAzureSqlDb, HighDataIoElasticPool, HighDtuAzureSqlDb, HighDtuElasticPool, HighLogIoAzureSqlDb, HighLogIoElasticPool, HighMemoryAzureSqlDb, HighSessionPercentageAzureElasticPool, HighSessionPercentageAzureSqlDb, HighWorkerPercentageAzureElasticPool, HighWorkerPercentageAzureSqlDb, JobDurationUnusual, LimitedSampling, LowCpu, MachineUnreachable, MonitoringErrorMachineDataCollection, MonitoringErrorSqlServerDataCollection, MonitoringStoppedMachineCredentials, MonitoringStoppedSqlCredentials, PageVerification, SqlDeadlock, SqlJobCancelled, SqlJobFailure, SqlErrorLog, SqlServerAgentState, SqlServerAnalysisState, SqlServerBrowserState, SqlServerIntegrationState, SqlServerReportingState, SqlServerSearchState, SqlServerWriterState and SqlServerUnreachable. Further alert types will be supported in upcoming releases.

Fixes

  • Ensured Alert Summary Report Tile respects security settings.
  • The DatabaseFileUsage threshold values for time remaining were changed from a TimeSpan to an integer representing the number of days.
  • Disk read and write time metrics now cope with increases of greater than 2^32 ticks between sampling intervals.
  • Correct the way the server URL is populated in the API PowerShell module.
  • Fix error when renaming groups.

9.1.3

Updated Sep 5, 2019

Features

  • SQL Monitor is now FIPS compliant.
  • Ignore sp_server_diagnostics in long-running query alert.
  • Added new analysis graph metrics for SQL Server memory.
  • Display seconds on times in long-running query alert.
  • Added support for base monitor error notification email address configuration.
  • Added initial support for the retrieval and update of Alert Specific Settings for the following alert types: DatabaseFileUsage, AvailabilityGroupDelayedQuery, AvailabilityGroupReplicaFallingBehind, LowDiskSpaceAlerter, LowMemorySpaceAlerter, SqlDeadlockXE and DatabaseSizeAzureSqlDb. Further alert types will be supported in upcoming releases.

Fixes

  • Reduce frequency of AD queries for user running base monitor process.
  • Fixed an issue where the authentication type page could show incorrect information on multiple base monitor environments.
  • SRP-12253 Fixed an issue where the server summary report failed to load data.

9.1.2

Updated Aug 21, 2019

Features

  • Added ability to enable an error notification if base monitor loses connection to its repository.

Fixes

  • The backups page now correctly shows the latest backup date across availability groups.
  • Fixes an issue with 9.1.1 where the website fails to load with certain .NET Framework versions.
  • Reintroduce link to inherited settings in Alert Settings.

9.1.1

Updated Aug 14, 2019

Features

  • Invalidate authorization token on logout / website restart.
  • Invalidate authorization token when user updated or deleted.
  • Expanded Alert Configuration API to allow for the updating of comments on any alert configuration.
  • Expanded Alert Configuration API to allow for the updating of notification settings on any alert configuration.
  • Added example scripts for Alert Configuration API for updating comments and updating notification settings.

Fixes

  • Fixed an issue where the monitored servers page would be empty if there was a large number of monitored servers.
  • Fixed an issue with alerts not correctly sending email notifications when ending.
  • In the PowerShell API, Get-InstanceForMachine now represents a default instance name as '(local)', to be consistent with other cmdlets in the API.

9.1.0

Updated Jul 24, 2019

Features

  • Enable or disable alerts at group level.
  • Disable alerts at base monitor level.
  • Example scripts for API now available in product at Configuration > Example scripts.

Fixes

  • Fix issue with multiple base monitors causing connections to not be closed.
  • Fixed an issue that could cause the API command Get-Clusters to error if there were clusters without machines in the database (including recently added clusters).
  • Fixed an issue with changing recovery model not clearing log backup overdue alerts.