ApexSQL Monitor release notes

Enhancements:

• The browse network servers option is added in the add server page
• The option to export and import custom metrics is added

Fixes:

• Link to the Group dashboard view is missing from the message that indicates that indexes are not enabled for monitoring
• Default value is set to 0 for the high alert threshold of the Deadlocks per second metric in the metrics configuration page
• A label for AlwaysOn availability group type in the Group dashboard is incorrect
• The “Select all” option is missing from the database pick list in the reports page
• The ‘No servers to display for this configuration.' Message is displayed when selecting the group in the tree view, instead of the message 'Servers in this group are disabled or offline' when offline and disabled servers are hidden via the Tree view configuration
• The daily maintenance period calculates incorrectly when scheduled to be active for period of two or more days
• The repository database cannot be created during the installation in vase that some specific regional settings are set at the OS level
• The maintenance period set to suppress alerting doesn’t work
• The maintenance time is displayed using UTC and not time from the machine where the main service is running
• The individual index size info is missing from the Indexes page
• The alert check-box in the configuration page remains checked when associated metric is unchecked in the database section
• The warning message about unsaved data from input is missing when the F5 button is used for page refresh
• The 'new folder' button in Browse for folder dialog if the application installer is missing
• The check-boxes selection in the report page is not working as expected
• If user selects a custom time frame for the charts, the original drop menu stays in the initially selected range
• The Default button is missing in the execution plan controls section
• The "Unexpected server error" is encountered when resolving alert with description larger than 250 characters
• The execution plan window controls are positioned at the top of the window in IE
• The AlwaysOn replica cannot be added as the standalone server for monitoring
• The alert indicator in the Group dashboard is missing in Internet Explorer
• The link for email profile creation is missing in the Send logs page
• Inadequate error message for invalid thresholds is displayed when saving the new custom metric
• There is no warning that restricted special characters are used for the password when editing or creating a new application user
• Access to the application will not be allowed when special characters are used for the user password
• Not all information will be displayed in the server dashboard when an instance is added using encrypted connection
• The inadequate info is displayed for the status of monitored instance that is disabled for monitoring
• The indication for the instance that is under maintenance is missing
• Values for thresholds are in nanoseconds/milliseconds where unit is indicated as second in the metric configuration page
• The select all check-box in the metric configuration page doesn’t work if some metrics are unchecked after checking select all check-box
• Selecting the chart period larger than the actual period of the collected data is allowed
• Symbol characters may appear in the Custom metrics view
• The application cannot display properly index page for the SQL Server 2016 instance
• The database configuration page will not list databases for offline servers
• Navigating back from the individual alert page to alerts page will display alerts for the last 24 hours period, instead for the period selected by the user
• Related metrics for the system availability are displayed in the alert details page
• The AlwaysOn replica cannot be added as the standalone server for monitoring
• The execution plan rotate functionality displaces the connector arrow improperly, making the plan to appears as corrupted
• Query waits ID labels are not displayed in Internet Explorer
• The Query details section will be collapsed after automatic page refresh

Changes:

• The instance dashboard now displays the commercial name of Windows OS version
• The Row count and Fill factor metrics are removed from the metrics configuration page

Enhancements:

• Configurable idle timeout period for the Web client
• Navigation from metrics charts to query waits

Fixes:

• The tree-view appears blank after adding a failover cluster instance for monitoring
• The query performance page will not display data in some specific cases
• The grid for the query waits blocked queries section are not displaying any data in some specific cases
• The message when reader try to add a new user should indicate that it has not enough privileges to perform this action, instead of indicating who can perform
• The column sorting arrow in the Alerts page grid does not change the orientation in the sort order changing
• The "At least 7 days of data is required for calculating baselines" message icon and color indicates the error message, instead of the information message
• The Tree view doesn't refresh when new group is added or removed
• Selecting a user defined group will select the All instances group in the Dark layout
• Queries in Query waits view cannot be searched by custom name or ID
• Missing space between query wait alerting controls and include query grid in Configuration/Queries view
• Date/time filtering option description in Query wait statistics alert view is not consistent with other views
• The Query performance page will not display any data in case of zero-elapsed time
• Group Dashboard grid doesn't correlate with the Tree view configuration, and if the Tree view filter returns no servers, message and link to Configuration/Tree View should be present instead of Dashboard grid
• Wrong query wait is hidden from the chart when clicked on query name, if multiple query waits with same name are listed in the view
• The query waits statistic alert do not have the link to the actual query wait page
• The SQL handle in the query wait alert is displayed in the wrong format
• Wrong breadcrumb for the Manage credentials view
• Query name column in Include query table is missing
• The "Unexpected server error" error is encountered when opening the query execution plan and the empty plan displays
• The metric chart doesn't allow drill down to the Query waits page for a specified period
• Alert notification icons are not clickable in Databases view
• On missing SSL certificate, Encrypt connection option displays warning message “Unknown server error”
• After adding the SQL Server instance, it doesn’t appear in the Tree view and the Group Dashboard in specific cases
• The Internet Explorer do not use the proper time calculation as it is always shifted for the UTC offset time
• The drill down when the single query is selected will reset the selection to the group queries
• On starting application, it will open the blank initial page and tree view will be collapsed in the Dark layout
• On the page refresh, screen is blank and the tree view collapses in the Dark layout
• Most of links in Main menu doesn’t work once the page is refreshed and the blank page is opened in Internet Explorer
• After refreshing the page in Internet Explorer, the blank page will appear, and subsequent refreshes will not load the page
• The Tree view doesn’t display the added servers in the Internet Explorer
• Interval value for sending summary email can’t be “0”
• Wrong caption and description text in test recipient input dialog in SMTP profile settings
• Tag testing requires choosing server when Server tag is not included in Command alert action view
• Link for enabling index monitoring is missing
• The charts are displayed by alphabetical order instead based on importance
• The way of setting email and alert action per database is wrong
• There is no individual queries page in the Query waits feature
• There are no arrows for ordering the multiple alert action functionalities in a single alert action profile
• The created firewall exception inbound rule has no description
• The information message “At least one user with admin privileges must exist” appears when changing the own role from Reader to Administrator role, even the active Administrator role already exists
• The information message “At least one user with admin privileges must exist” appears when the admin user with administrator privileges tries to change the privilege to another user from Reader to Administrator role
• The Power user can create a new user with administrator privileges
• If save is clicked when the change password is selected and old password not entered or not entered properly, the same error will be displayed even after unchecking the checkbox for password change
• The Reader user can change its own role to administrator
• The Power user can change the password for users with administrator role
• The Power user can change the admin role to the Reader or Power user
• The message “Not enough privileges to perform this action” should appear to indicate when Reader role try to add a new user who has not enough privileges to perform this action, instead of indicating who can perform
• The 'ApexSQL Monitor Updater has stopped working' error is encountered when updater is initiated
• The "There is an error in XML document (2,2)" error is encountered after starting the updater application
• Missing information about the blockers in the Query waits alert page
• It takes too long for the Server Dashboard to opens when offline server is selected
• The custom report charts are corrupted
• The charts larger than 30 minutes are not interpolated
• SQL Server 2005 instance cannot be monitored properly in specific cases

Enhancements:

• Full support for monitoring SQL Server vNext CTP1 instances
• Custom performance reports are now available from within the GUI
• The Configuration page loading is up to 1,000% faster
• Switching between windows is up to 500% faster
• The send email alert action can be configured for the query wait alerts
• Additional security layer is added via the ’Power user‘ user profile
• Multiple email profiles can be assigned to individual metric via alert action
• The monitored instances Tree view can be configured to display SQL Servers according to a custom criterion
• The query waits chart can be drilled down by time
• Alert list can be filtered by time
• The individual alert page displays the related metrics charts for the same time period
• The alert page grid can be grouped by any grid column

Fixes:

• Failover Cluster Add server dialog has an option for adding all databases for monitoring
• Database metrics charts are displayed only for system databases for a SQL Server Failover Cluster Instance
• The upgrade process does not upgrade the application central repository database properly to accommodate the required changes for the query report
• The application stops responding and the query report is not generated when creating the report for an inaccessible SQL Server instance
• The application installer does not install all the necessary data in the application central repository database to allow creation of the query reports
• The application is no longer activated and stops working on virtual machines after a virtual machine update, configuration change, or power outage
• The application might stop monitoring SQL Server 2005 version on specific occasions
• The upgrade process fails when upgrading from a patched application version older than 2016 R3
• Device and SQL Server measurements will not be displayed for specific configurations of SQL Server Failover Cluster Instances
• When the SQL Server connection timeout expires during the application installation the central repository database will be corrupted
• SMTP mail server authentication password is stored unencrypted in the central repository database
• The database monitoring does not work when SQL Server Failover Cluster Instance is configured as an availability replica in the AlwaysOn group
• The history settings will not be remembered after selecting another SQL Server instance in the monitored instances tree view
• The application user account information stored in the central repository database is not encrypted
• The “Disable alerting” option in the maintenance period doesn't work
• The application becomes unresponsive while monitoring database with a large number of indexes
• The application becomes unresponsive when a large number of alerts is stored in the central repository database
• The alert summary email contains duplicate alert data
• The ’Physical memory‘ info is not available in the Overview page
• The “Unable to create ApexSQL Monitor database. Please consult application log for details” error is encountered during the application installation when creating the central repository database on a remote SQL Server
• The maintenance period end time setting uses time offset that is 1 hour less than the start period
• The alerting option in the maintenance period doesn’t work
• The alert status icon next to a particular query wait type is not clickable
• Icons are pixelated in the Query plan viewer when the zoom is over 250%
• The query waits data cannot be copied to clipboard
• The central repository database performance is degraded while the application truncates the database transaction log file following data purge operation
• A SQL Server Analysis Services instance can be selected to be added for monitoring as a SQL Server instance
• The "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" error is encountered when loading the server alerts from the central repository database

Changes:

• The application is now fully web based
• The Query waits configuration time increment is now in milliseconds
• Group dashboard and server dashboard have new layouts
• Redesigned AlwaysOn Availability Group dashboard
• Redesigned index monitoring
• Email, SMTP and SNMP profiles can now be separately configured and saved
• Desktop console is deprecated

Enhancements:

• Support for monitoring SQL Server vNext CTP1 instances

Fixes:

• Option for adding all databases for monitoring in the Failover Cluster Add server dialog is redundant
• Database metrics charts are displayed only for system databases within SQL Server Failover Cluster Instance
• The upgrade process does not upgrade the application repository properly to accommodate the required changes for the query report
• The application stops responding and the query report is not generated when creating the report for an inaccessible SQL Server instance
• The application installer does not install all the necessary data in the application repository database to allow creation of the query reports
• The application is no longer activated and stops working on virtual machines after a virtual machine update, configuration change, or power outage
• The application might stop monitoring SQL Server 2005 version
• The upgrade process fails when upgrading from the older patched application versions

Enhancements:

• A new dark color interface theme is now available

Fixes:

• The repository database indexes are not rebuilding after executing data purging operation
• Corrupted SQL Server performance tab charts could be encountered for SQL Server 2016 due to improper data collecting
• The Query performance charts data are incorrect and on every refresh the amount of displayed data is reduced up to the level that no data are displayed
• Application do not trigger the system availability status alerts
• The right side of the Wait stats tab screen will be cut when downsizing the application window below certain level
• Can't connect on AlwaysOn using windows authentication in certain active directory configurations
• The error occurs during the installation if username used for the application service contain space character
• The chart axis contains too many labels that overlaps each other in the report
• The low visibility of the Date range picker’s month/year header in the Reports screen
• Date and time format is not displayed in proper format in the Wait stats, Query waits and Indexes tabs
• The “divide by zero is not possible” error occurs in the query performance tab causing that no data will be displayed in charts and grids
• The View details sub-tab of the Alerts section in the Query wait statistics tab will not di8splay data when grid is grouped by the server column
• The alert details tab will not be updated if new alerts are triggered while the tab is in focus
• Alerts screen will not display any data for monitored instance that contains large number of databases and/or indexes
• The “Column 'PlanHandle' does not allow DBNull.Value.” error is occurred when no query execution plan handle is retrieved and query will not be stored in the database
• The connection timeout expired will be encountered when refreshing query waits if large amount of data has to be retrieved from the repository database
• The “System.NullRefferenceException” error is encountered and application closes when opening helper info box via the chart title link
• Index was outside the bounds of the array" error is encountered during installation when the partition root is selected as Data file path
• The multiple redundant entries for the Wait types are added in the repository database when adding new instance, causing the bloating of the database with unneeded data
• The T-SQL of the blocking query in the Query performance tab is displayed in the single line hoover initiated tool tip, instead in a new floating window
• Application will continue monitoring of disabled instances until restart of the monitoring service
• The alert will not be triggered when a failover cluster fail-overs from primary to secondary node
• The alert will not be triggered when the system availability status changes
• The Metrics configuration screen will collapse all submenus when changes are applied
• The Add server dialog do not have standard options to set timeouts and connection encryption
• The query wait stats alerts triggers only ones for the same query and not again if the query wait stats time exceeds the threshold on new query execution
• In uninstall process, two time asked to delete database
• The "Arithmetic overflow error converting expression to data type int" error appears when collecting 'Used space in buffer' and 'Unused space in buffer' index measurements
• The AlwaysOn diagram might be displayed incorrectly for certain AlwaysOn configurations
• When moving the zoom slider in the query plan viewer, the numerical zoom level value will not change accordingly
• The bottom of the chart lines is trimmed on some charts occasionally
• The multiple metrics charts display only a single random metric without allowing the user to choose which one to be displayed
• The Y axis on the chart will not be scaled when metric is turned on, causing that chart will not display that metric if it is out of the current y-axis range, even when it is a single metrics enabled for displaying in chart
• Alert actions could not be executed
• The unhanded exception occurred when selecting the disabled server and application closes
• The color for the metrics and legend will be changed when switching to the View alerts chart
• The installer will complete installation even in situation when the database cannot be upgraded resulting in improper application functionality after upgrade, without warning the customer
• The date time picker will close when click on either date or time, thus preventing user to select the desired date and time
• The Wait stats charts baseline will not display any baseline zones and the chart bars even it is evident that wait stats bar exists when baseline view is turned off
• When changing the SQL authentication to Windows authentication, SQL Server account password will not be replaced with the Windows account password
• Date and time pickers is displayed in the alert chart
• Baselines areas are not displayed in the wait stats alert chart
• The elapsed time in the Query waits stats tab displays wrongly in some cases lower elapsed time than the actual wait time
• The query performance feature does not have the option to not retrieve data for the excluded database list defined in the database metrics configuration
• The alert will not be triggered when a failover cluster fail-overs from primary to the secondary node
• In the "Charts" view at the "Indexes" tab graphs are not positioned correctly
• When editing the added metrics in the custom chart, these are not listed in the added metrics list
• All defined thresholds for the custom metrics added in the single chart are marked with the red color making impossible to distinguish what threshold line belong to what metric
• The Y-axis in index charts are not scaling on turning the metrics on and off, to accommodate remaining metrics and thus improve their visibility and precision
• The metric can be turned off from the chart even in when this is the only metric in that chart
• The notification bar will not be closed when user restore defaults settings, forcing them to press Apply or Cancel without knowing what will be applied or canceled
• Newly added devices in the Devices screen of the Metrics tab are not monitored even they are marked as enabled
• The "RECOURCE_SEMAPHORE" helper is missing suggested solutions
• The installer logs are part of the service log instead of being stored in the separate log file
• The “System.OverflowException exception: Value was either too large or too small for an Int32. " is encountered when resolving wait resource
• The “Collection was modified; enumeration operation may not execute" error is occurred when updating maintenance periods
• In the "Database metric configuration" of the database metrics configuration, the baseline threshold checkbox for the Status changed metric is excessive
• Query IDs in the Query waits chart are overlapping when resizing down application window
• The user will not be warned that monitoring of system metrics will not be possible if he change from Windows to SQL Server account for SQL Server instance connection in the Configure server account dialog
• Alert resolution and comment will not be saved into the repository database when checkbox is not selected
• SQL Server instance field is empty in the generated report
• Table with details from Statistics/SQL Server report is misplaced

Enhancements:

• Full support for AlwaysOn availability groups monitoring with graphical presentation of all WSFC nodes and AG replicas including the relations
• Index monitoring including the index metrics and graphical presentation
• Stricter alerting engine ensures triggering only alerts that complies with user defined alert period
• Alert management with ability to resolve individual alerts, insert comments and reporting on active and resolved alerts
• Query performance and query waits alerting
• Query performance history
• Individual query history
• SNMP notifications on alerts
• Improved functionality of custom metrics
• Performance improvements

Fixes:

• When adding instance for monitoring, especially the AlwaysOn AG or Failover cluster, the SQL Server instance will multiply displayed instance
• Clicking on ‘Add chart’ here brings ‘bigger’ dialog which just adds more options to the dialog
• There is no option to set the sender mail file in SMTP configuration of email profiles
• The query performance tab will not show data on some system
• Filters in the exported reports tab cannot be closed via the Esc key
• Reporting tab has redundant 'export to' buttons
• Buttons without a function in the reports pane
• The task bar icon preview window is blank
• The 'Preview' report button is not visible when the pane is resized to a smaller size
• Date/time range (calendar) is not visible when the pane is resized to a smaller size
• Layout changes in the custom tab cannot be rolled back to default state
• The surplus Default button in the Users tab of the Options dialog
• Disable alerts' and 'Disable monitoring' check boxes in the maintenance period dialog behaves like radio buttons
• When all devices are excluded, the associate icon for granular configuration in the metrics screen is still present
• When all databases are excluded, the associate icon for granular configuration in the metrics screen is still present
• Query plan viewer is not centered
• When colors are changed in the options dialog, those are not automatically applied to charts
• The exported reports titles are cut at the bottom part
• There is no validation and information that result of the custom metric must be the numeric value
• he F1 key does not initiate help in add server dialog
• The Copy query button in the Query waits tab is cut and displayed incomplete
• The query text is missing the last character when displayed in the query waits tab
• Changing the query name in the query waits tab, will not automatically rename all the queries at same handle
• It take a too much time after adding the Always on nodes before any measurement and status work
• The “There was an unexpected error when trying to add new server” error is encountered when adding the SQL Server for monitoring while residing in the metrics screen and none of the groups are selected
• The Locate service dialog removes underscores from the name of the machine
• The databases table in the overview tab is completely empty if all databases are disabled, instead of being hidden
• If a non-existing username is entered on login form, an error message shows up and instantly disappears (blinks)
• The total server availability doesn't have the pie chart for the system
• The Wait stats by top 5 categories doesn't have the table with groups and the pie chart is very difficult to use for the purpose of selecting
• The T-SQL text in the custom metric dialog is not syntax highlighted
• The alert report in mail displays the wrong date range for alerted metrics
• The mail summary for alerts displays the SQL Server metric alerts under the instance group and in a group reserved for system metrics
• The Listed alerts in the Query waits dialog cannot be expanded on "+" sign to list the actual waits
• Single query executed in parallel on SQL Server will be displayed as the multiple time executed query
• The query text window is cut and doesn't allow user to see complete content
• The application doesn't log the installation process
• The F1 button is not functional as help button on application dialogs
• Filters in the Query waits grid cannot be closed via Esc key
• Filters in the Query performance grid cannot be closed via Esc key
• Filters in the Server overview grid cannot be closed via Esc key
• Data purging cannot be accomplished when purging the large repository database
• The "System.TimeoutException: This request operation sent to net.tcp://a02862:65446/ApexSQLMonitorCommunication did not receive a reply within the configured timeout" error is encountered when starting the GUI
• The newly read wait stats data are recalculated and displayed wrongly in the Wait stats chart
• The Wait stats chart is not sorted properly from largest to lowest value
• The zero values shouldn't be displayed in the Wait stats chart
• Wait stats table doesn't have important "Total" and "Average" values
• SQL Server charts are not refreshing regularly
• There is no "Period" variable that can be insert in the custom query
• The Custom metrics dialog do not have a provision for user to select the percent scale if the query is designed to return the value in percent
• There is no option for user to add the comment for the created custom metric
• The test of custom metric does not display the value that specific query will return
• The "There was an unexpected error when trying to add new server. Please consult application log for details." error is encountered when adding the server that contain databases named using special characters
• The "While number value" and "Cumulative value" are organized via check boxes even they are overriding each other as different type of counters
• There is no custom metric type that will return the custom query execution time as a result
• There is no option to disable the alert period
• The status alerts have to be triggered on every state change, and alert period must be disabled always
• When adding server without appropriate permissions, the list of missing permissions and requirements must be shown
• The listed databases in the database metrics configuration are not sorted by names and by system/user databases
• The listed databases in the database metrics configuration do not have assigned appropriate icons
• The "ApexSQL Monitor has stop working" error is encountered when opening the Query plan on a system where regional settings is not set to English
• The SQL Server that is part of Availability Group, cannot be added for monitoring as the regular server
• The application collects query waits for databases excluded from monitoring
• The Blocking queries in the Query waits will display the query that has been blocked, instead of query who performed blocking
• The application will not trigger the appropriate alert even when the condition for the alert is fulfilled
• The date format on the charts do not correspond the system date format
• The application doesn't log the installation process
• The query text window is cut and doesn't allow user to see complete content
• The query text is missing the last character when displayed in the query waits tab
• The Listed alerts in the Query waits dialog cannot be expanded on "+" sign to list the actual waits
• The query waits alert section displays all alerts instead of the High alerts only
• The mail summary for the alerts, displays the SQL Server metric alerts under the group and in a group reserved for system metrics
• The alert report in mail displays the wrong date range for alerted metrics
• The "Runtime Error (at 47:255:; External exception E0434352" occurred when installing the application
• Data purging cannot be accomplished when purging the large repository database
• The "System.TimeoutException: This request operation sent to net.tcp://a02862:65446/ApexSQLMonitorCommunication did not receive a reply within the configured timeout" error is encountered when starting the GUI

Changes:

• Query waits configuration is redesigned
• Redesigned wait statistic tab graphical presentation
• Complete GUI redesign of the custom metrics tab

Enhancements:

• Improved Server overview screen with additional information
• Improved Database performance view with more database details
• Improved charts layout and look for faster response and easier navigation
• Independent baseline calculation for individual metrics
• The custom central repository database name can be defined by user during the installation
• Windows credentials can be set by user for adding the SQL Server instance for monitoring
• Blocking query waits statistics added
• Query waits alerting based on predefined threshold added
• SQL Server failover cluster support added
• Monitor SQL Server agent status added
• Improved AlwaysOn Availability Group monitoring now fully supports monitoring of all instances in the availability group
• SQL Server 2016 CTP3 can be monitored and used for hosting the central repository database
• Message box with critical information, tips and suggestions for helping DBA to understand and analyzing performance issues added
• Up to 10 times more responsive View alerts char
• Improved application responsiveness when installed in SQL Server Azure hosted Windows OS

Fixes:

• The date/time text on y-axis of the chart is overlapping when the chart is resized
• The truncated "No" button the uninstall dialog
• Once logged in, the user cannot log out from application
• The "View query plan" doesn't check for the query plan existence and an empty dialog is displayed when query plan is not generated by SQL Server
• Selecting the zoom level in the Query execution plan viewer dialog corrupts the displayed values of the zoom level
• When Save is clicked on the Exported reports tab, file will be saved without the file extension
• Clicking on the View query plan link will not produce any effect or will open just the corrupted dialog
• After upgrading from the previous version, the MonitorAlerts table schema is not the same comparing to the clean installed version
• Mouse and keyboard scroll doesn't work in the report preview pane
• Database report is missing check-boxes for databases selection
• The Export and Preview button names are not consistent with the similar functionality buttons within the application
• Once the user log-in requirement is enabled, it cannot be disabled again
• When selecting reports, the blank page is displayed instead of the menu
• The Total size changes chart in the "1.1 SQL Server" report doesn’t imply to size of what it is referring and what measurement unit it utilizes
• The reports cannot be scrolled using the mouse scroll
• Cursor doesn't change to 'hand' style on the text links
• Corrupted database names in the table of the Database summary report
• The 'XDL' files created in SQL 2008 was invalid
• The "Server health" report title is wrongly used for the "System health" report
• The SQL Server statistic report displays the name only for the first SQL Server
• The selected query in the Query performance tab is not marked properly
• A query selected from the bar chart will not navigate to in the Query performance tab's query list
• Database list cannot be grouped or sorted by Alerts in the Overview tab
• Check-boxes disappear from the Alerts pane unpredictably
• The 'Bytes sent to replica/transport per second' & 'Sends to replica/transport per second' graphs cannot be displayed
• The 'Receives from replica per second' chart cannot be displayed
• In the options dialog, adding a color to the graph allows one additional color only
• The application cannot be started after canceling the upgrade process from a previous to the current version
• The check all alerts button does not work in the Alerts pane
• The "Start date and time cannot be greater than ending date and time" error is encountered when trying to set the maintenance period that crosses to the next day
• The grids highlight visibility is low or doesn't exist when higher contrast monitors are used
• The data will still be displayed after purging all data from repository database
• The "An error occurred during data purging." error is encountered when executing the purge for repository database that stores a larger amount of data
• The query waits total wait time doesn't correspond to the sum of the individual wait type times that are listed for that specific query
• The query plan link is not available in many cases
• The defined alert period cannot guarantee the user that alert will not be raised when measured value is above the threshold for the shorter time period than one defined in alert period
• The application alert tab chart displays the wrong number of alerts comparing to the listed number
• The charts are rendered empty in all reports
• The Installer’s Configuration dialog displays most of the active fields as greyed out as disabled style fields
• The redundant last column in the grid of the 'All instances' dashboard
• The performance charts display the zero values as gaps, giving the charts corrupted look
• The Alerting report's "SQL Server active/resolved alerts" table displays the name of the instance as "."
• The most of reports displays "Not enough data for chart" even when data are present in repository database
• Inadequate distribution of rights for Administrator users that leads to situation that some users can't be removed at all
• The alert period doesn't properly suppress the number of alerts and alert will be triggered earlier than alert period time should grant
• The status alerts are triggered in accordance to the defined alert period, not according to the related state change
• Charts are not optimized to interpolate values when displaying 30 minutes’ period in case that metric period is set to lover than the default value
• Removing server can fail in specific cases
• Configurations child settings overriding is not visible and no indicator that the child setting is different from the parent
• The "Create SQL Server login (sysadmin)" option in the installer is wrong
• The alerts for status metrics will not be sent to inform that the alert state has returned to OK state
• In case of SQL Server where the repository database is down, the application is almost or completely unresponsive
• The "Provide the required configuration details" sentence is redundantly used in two consecutive sentences in the Setup's Configuration dialog
• The small initial repository database size causes its quick fragmentation and significant performance decrease
• The Auto growth value for the repository database is way too small that lead the performance issues because of consuming too many resources for frequent auto-growth
• The creating firewall exception will open completely the target port, instead to be opened only for application
• The startup of application is slow when the user login is required
• There is a memory leakage in application that cause the uncontrolled growth of the used memory and cause application to stop working
• The "System active/resolved alerts" table in the Alerting summary report displays wrongly the total Server alerts, not only the System alerts
• The Alerts by metrics table in the alert summary, displays the total alerts number instead of number of the alerts for the selected report period
• The Alerts by metrics table in the alert summary, displays the total alerts number for SQL Servers not selected for report
• There is no option to select/unselect all databases for the Database summary report in the Report configuration dialog, preventing the database selection for servers with large number of databases
• The Database summary report in the Report configuration dialog do not differentiate the user and system databases
• The Database summary report in the Report configuration dialog do not sort database list by alphabetical and type order making them listed random and hard to locate
• There is no option to include or exclude system databases from report in the Database summary report in the Report configuration dialog window
• The exported report will overwrite the existing one without a warning
• The Alerts by metric table will display all the existing alerts, even when only machine is selected for report and SQL Servers are excluded
• There are no measurement units for the report charts and tables
• The Restore defaults option applied to "All instances" will not properly restore defaults for system metrics of the monitored instances
• There is no progress indicator when adding instances for monitoring
• The application prevents Windows taskbar to be shown when set to auto-hide the application window is maximized
• The Avg CPU time chart in the Query performance tab displays the wrong queries in chart
• The Query performance tab chart' Avg I/O per sec' doesn't have the corresponding column in the table, while other two charts have
• The Query performance's 'Avg Execution time' charts displays the wrong queries in chart
• The rows in the Query waits grid are not clickable to allow opening the chart with details for that query
• The incorrect size of the grid columns of the single queries option in the Query waits tab
• The database metric tab list of databases does not have appropriate system and user database icons
• The database metric tab list of databases should list system database at the top and user databases below
• The devices metric tab list of devices does not have appropriate icons
• The "System.ServiceModel.FaultException: The server was unable to process the request due to an internal error" is encountered when restarting the application service
• The queries with the same handle are designated with the different names
• The SQL handle should be removed from the Query waits tab and moved to tool tip or details
• The custom tabs are displaying the completely wrong charts, and charts values are wrongly interpolated with other metrics
• The performance metrics charts are not displayed as interpolated values for 12 hours, 1 day and 30 day period display
• The number of servers added for monitoring during the trial will not be reduced to the number allowed by license after activation
• The calculate baselines don't have any progress/work indicator causing the GUI to appears as unresponsive
• The Query plan viewer window maximizes on double-click on header but not to full screen
• The Query plan viewer window cuts off the lover part when expanded vertically to a maximum
• The maximized Query plan viewer window have restore to normal size button but it doesn't have the maximize when not maximized
• The connection status do not differentiate the actual SQL Server status and availability status of machine that hosts monitored SQL Server
• The links in Exported reports tab do not match the styles of other links in the application
• The "System.NullReferenceException: Object reference not set to an instance of an object" error is encountered when Manage databases tab is selected while the selected server is offline
• The longest running transaction chart displays the worktable transactions time, causing that chart displays only the values for worktables transactions
• In the Alerts screen entire screen is scrolling without ability to scroll only the grid

Changes:

• Waits stats isolated into separate view
• History navigation changed to use history slider
• Redesigned Query waits view
• Redesigned Maintenance periods view
• The Configure baselines dialog name is changed to Calculate baselines
• The "View query plan" title is changed to "Query plan"
• The default horizontal screen split between the chart and grid is changed to a vertical split
• The user is not allowed now to turn off the SQL Server status monitoring
• The system alert action profiles cannot be deleted now

Enhancements:

• AlwaysOn Availability Groups performance metrics and the dashboard
• The built-in Query execution plan viewer
• Ability to create reports on SQL Server performance is implemented
• Ability to define users and their privileges is implemented
• Added notification icon when reviewing charts in a historic view
• Configuration of metrics per device is implemented
• Configuration of metrics per database is implemented
• Added a logarithmic Y-axis scale for Average bytes per write, Free space, Average bytes per read, Available megabytes of memory, Page life expectancy, and Buffer cache hit ratio charts
• Improved performance base lining with ability to graphically convey medium and high alerts threshold zones in chart
• Charts loading time improved by up to 100%
• Charts can now be viewed in time intervals of 12 hours, 1 day and 7 days
• The application can now display all wait statistic types

Fixes:

• There is no automatic notification on application start, when a new version of the application is available
• The "Purge data automatically" feature will not purge any data regardless of the parameters set, if the GUI is closed
• The "An item with the same key has already been added. Type: System.ArgumentException" error is encountered when all parameters of the queries are identical and a query will be missed
• The "Alert action test executed successfully" message is wrongly displayed when testing query text for custom metrics
• The newly added custom metric will not be listed in the metric window
• The time format of the “Last exec time” column in the Query waits tab, is not in the proper time format as it displays a time zone info
• After change a chart metric via the chart combo box and save layout, the original chart will not be displayed anymore
• SQL Server and database measurements will not be displayed and instance will be marked as unavailable when removing and then adding again that server instance
• The "Wait stats" chart doesn't scale Y-axis according to the values of the graphs which could prevent analysis when chart displays one or two wait stats
• The application allows displaying a baseline threshold graph for more than one metric in charts with more than one metric
• Having "MSSQL" as part of the name of a named SQL Server instance, will prevent adding it for monitoring
• The query performance tab tries to load the data even for SQL Server that is stopped for monitoring
• The "Date" drop down menu in the Query waits tab allows selecting a date even when data doesn't exist for that day
• The "Query execution plan' filter displays values that are not readable
• Filter in the query waits dialog remains on the top even when focus is changed to another application
• The graphical presentation of baselines threshold will be automatically turned off when switching to another tab or window
• The chart name text is truncated when more than one chart are docked next to each other in a single line
• Only baseline configurations are deleted when server is removed while baseline calculated values are still stored in the repository database
• The baseline configuration tooltip is not displayed for all charts for Show/Hide baselines buttons
• A false error that indicates that the application is not closed, will be displayed during the upgrade process
• The Wait stats chart will not display anything when SQL Server 2005 is selected in the left pane
• Parts of the versions description text are truncated in the update service form
• The databases can be added twice for monitoring in some specific case

Fixes:

• The 'Buffer cache hit ratio' metrics are incorrect for some system configurations
• The "Failed to upgrade database" error is encountered when upgrading from version 2014 to 2015 if the repository database contains a large amount of collected data
• Vertical scrolling through charts stops when pointer reach the gap between charts
• The "An item with the same key has already been added. Type: System.ArgumentException" is encountered when all parameters of queries are identical and query will not be collected
• The Y-axis value of charts will not be updated when the value is out of its current range in some cases
• The time axis of the Query waits graph utilize the 12h time display without AM/PM
• The "Purge data automatically" feature will not purge any data regardless of the parameters if GUI is not started
• The information about the baseline configuration is not displayed anywhere
• The Question dialog buttons are missing or do not work
• Base-lining configuration values in "Configure baselines" dialog are always reset to default
• The column name "Baseline alert" is misleading since it doesn’t enables baseline alerting but baseline thresholds
• Upper right corner buttons are missing hover over shading
• Shading in the 'browse for folder' dialog makes selected folder name blend in with shade and hard to see
• The regional windows settings are not applied to alerts or emails
• Numeric values have up to 12 decimal places
• Docking the graphs using the up or down docking wheel arrow, results in graphs cut in half horizontally
• The sorting does not sort databases per size in the server "Overview" screen
• If windows resolution is changed while console is active the new resolution parameters will not be applied when resizing the application
• The "An unhandled exception System.UnauthorizedAccess" is encountered when starting the "View query plan"
• The column in the Query waits table is truncated and not visible
• After removing a server instance and adding it again, it will not display any SQL Server or database measurements and will be marked as not available
• When remote computer that hosts monitored SQL Server instance becomes unavailable, the application will falsely continue to treat these instances as online
• The "ERROR: Error while trying to get performance counter measurement" is encountered and application will wrongly continue to read the measurements from the unavailable instance
• The application will allow monitoring of all instances added during the trial, regardless off the allowed number of licenses after activation
• The left/right scroll buttons in the main tab's ribbon are barely noticeable
• The baseline configuration settings info is not available to user

Known limitations:

• Missing support for clustered Always on servers

Enhancements:

• Query wait statistics history and analysis
• Wait statistics for individual servers
• Custom SQL Server and database metrics
• Calculated metrics baselines for desired date range
• Built-in ApexSQL Deadlock info alert action for analyzing deadlocks
• Improved server overview and charts loading performance up to 70%
• One click navigation from dashboard or charts to alerts window and from measurements to query waits tab

Fixes:

• The "Trial period has expired" prompt is not initiated when application is started after trial expires
• Missing information about number of remaining/used licenses for SQL servers
• The application experience significant memory leakage and cannot flush unused memory
• Loading time of "Alerts", "Metrics" & "Server" screens is slow
• The 'F1' key does not initiate application help
• The "Metrics" screen became messed completely if the ApexSQL Monitor service is unpredictably stopped for some reason
• Inconsistent measurement unit for different metrics in the "Database performance" tab
• The application falsely indicates that the service cannot be located while it is clearly visible that graphs are updating regularly
• The "Overview" tab displays the wrong OS version on the same machine for different SQL Servers
• Uninformative message "An error occurred while sending request" is encountered when adding SQL server without located service
• The calendar-drop-menu title is mostly invisible due to font and background color
• Click on a database name in the "Overview" tab will always wrongly jump to the master database in the "Database performance" tab, instead on the selected database
• Error is encountered if "Send logs" is initiated when mail client doesn't exist on the system
• It is possible to create multiple email profiles with the same name
• Once created and then closed custom tab cannot be recalled again, instead it must be created again
• The "ApexSQL Monitor has stopped working" error is encountered when starting ApexSQL Monitor on not fully loaded windows
• There is an empty (sufficient) column in the "Metrics" screen
• The application service will not try to restart once it stops unexpectedly and it have to be started manually
• There is no 'default' metrics setting which user can return to
• The installer doesn't stop installation when detects that .Net 4.5 isn't installed
• The "An error occurred while testing the alert action. Please consult application log for details" error is encountered when testing the "Create command" alert action
• Installer cannot perform upgrade when user console only is installed, but indicate that the full install will be performed
• The "Add server" dialog cannot list the available SQL Servers in the drop down menu in the remote console
• The "Jump to end" button navigates chart and sets time to incorrect value
• Consecutive clicks on the left/right history navigation chart arrows will zoom out the chart
• The "No series added" message is shown when navigating between alerts and the chart in the "Disk free space" chart
• Enlarged graphics cannot be closed via 'esc' key
• Mouse and keyboard scroll do not work in the chart selection pane
• The monitored database cannot be taken offline as ApexSQL Monitor prevents this operation
• All measurements after 10th measurement in a single custom chart will be displayed in the single blue color
• The "System.NullReferenceException" error is encountered when removing the SMTP provider from the combo-box list
• The "About" dialog wrongly indicates "Professional Version"
• Selecting the monitored instance that is unreachable for service ends in couple of minutes of completely blank white screen, before the empty graphs are displayed
• Clicking on the last item checkbox in the "Manage databases" tab list will scroll the list down instead to affect the checkbox
• "Metrics" tab cannot be scrolled via mouse/keyboard scrolling
• Copied alert action profile is not named properly
• Columns doesn't have minimal horizontal size in the "Metrics" screen
• The "The system cannot find the file specified" error is encountered when trying to execute the action script
• The parameter value in the test is set at 1000 which is way to high and can cause the serious troubles during the test of some actions
• The action tag {Server} isn't a fully qualified name causing the script to not execute
• The query text in the "Query performance" tab cannot display the text from the non-standard code page tables
• The "Metric name" column is invariably sized wrong by default and it is too wide
• The "Metrics" tab grid resizes only the "Metric name" column, causing the last column to be cut when resizing
• The "Email profile" column is too narrow by default and is fixed width, allowing only small amount of characters to be displayed
• The "Alert action profile" column is too narrow by default and is fixed width, allowing only small amount of characters to be displayed
• The column auto-size occurs if sorting is changed in the "Query performance" tab
• The "An error occurred during data purging" error is encountered when trying to purge all data manually

Changes:

• Alerts are displayed per selected server, group or for all instances
• Metrics are configurable per server, server group or for all instances at once
• The "Dashboard" screen displays the number of online instead of offline instances
• CPU, disk, memory and databases alerts are displayed in the "Dashboard" screen
• Up to 10 metrics can be displayed in a single chart at once
• "Show previous series" and "Show next series" chart buttons are added for navigation between metric sets for charts with more than 10 metrics
• Restyled metrics and alerts tables
• "Manage email profiles" and "Manage alert action profiles" links are displaced from the "Metrics" screen to corresponding dropdown menus
• SQL Server instances hierarchy pane is removed from the "Metrics" screen
• The "Back to charts" button is added in "Alerts" and "Metrics" screens for easier navigation back to charts
• "Select action tag test data" dialog is added for inserting the test values for tags when testing created alert action or custom metric query
• New alert action tags "{ServerFullName}" and "{DefaultPath}"

Known limitations:

• Missing support for clustered Always on servers

Enhancements:

• Email notifications for raised alerts
• Creating and managing multiple email profiles
• Option to perform execute SQL scripts or start a program actions on raised alert
• SQL Server instances grouping
• New system performance metrics: Logical disk free space
• New SQL Server performance metrics: Compilations/s, Recompilations/s, Index Searches/s, Forwarded Records/s
• New database performance metrics: Transactions/s
• Fully customizable arranging of metrics tab charts
• Combine several metrics in a custom chart
• Combine several charts in a custom tab
• Disable alert notification during the maintenance period
• Improved charts loading performance by up to 100%
• Focus the chart on raised alerts in a single click
• Alert period, email profiles and action profiles can be set from "Alerts" screen

Fixes:

• The application installer doesn't detect presence of the .Net Framework 4.5 version
• The application cannot use the WPF software rendering which results in inability of application to display the GUI properly
• The application client indicates that service cannot be located when installed on the remote machine
• The "Internal error: Expression error 'Runtime Error (at 202:227): External exception E0434352' error is encountered when installing ApexSQL Monitor preventing service to be installed
• The query text cannot be copied from the Query performance tab
• Left and right pane of the Configure metrics dialog are not resizable in width by moving the border line
• The "Period" in "Metrics information" of the "Alerts" screen is not defined and could be interpreted as both, Metric or Alert threshold period
• The application shows the different system measurements for different SQL Server instances, even when all are located on the same machine
• The "SQL text" in the "Query performance" tab displays the incomplete query text
• When move through the charts data history using arrows, chart will stop responding and/or will stop displaying the data
• When user have data sampled in the short time frame (below 5 sec) the density of the drawings in the chart will prevent proper reading of the measurements due to density of the chart lines
• The overview tab displays the wrong OS version on the same machine for different SQL Servers
• Missing prompt 'Are you sure you want to disable monitoring of XYZ server' when server disabling is initiated
• The communication port cannot be added in firewall exceptions during the installation process
• The installer doesn't allow changing of the predefined communication port
• The application read and display more than one value for the same unique reading when reading period is set to low value
• The "System.InvalidOperationException" error is encountered randomly and application stops responding and closes
• The "Unhandled exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation" error is encountered when changing the metric period value
• The "There was an unexpected error when trying to delete a server. Please consult application log for details." error is encountered when trying to remove server
• Query statistics displays the time in microseconds for real, but it wrongly displays the time in milliseconds
• The "Metrics" screen text boxes are not aligned vertically with the main text boxes in the header
• New metrics colors cannot be added in the "Options" dialog
• Missing vertical scroll bar for the query text box of "Query performance" tab
• Chart Y axis is only partially visible on the charts
• The missing threshold warning is not set for all affected text boxes when all alerts are selected via the "All" button in the "Metrics" screen
• The SQL Server instance chart tabs do not indicate for which server data are displayed
• The "Overview" tab's "Remote login timeout" unit is not displayed
• Scrolling vertically through charts stops when pointer is between charts

Changes:

• Chart size option has been removed from "Options" dialog: charts can now be directly resized to any width and height

Known limitations:

• Missing support for clustered Always on servers
• The "An error occurred when trying to replace existing file" error is encountered when updating application to the latest version

Enhancements:

• Query performance monitoring of SQL Server instances
• Improved server overview tab displays more information
• Improved dashboard to include the basic server information and to show the most important alerts
• Automatic data purging feature allows deletion of data in the repository database older than the time period specified by the user
• The maintenance periods feature allows user to schedule when the monitoring of specified SQL Server instances will be disabled for the defined time intervals
• Option to define the length of time for which a value must be exceeding the threshold before the alert is triggered
• Drop-down list of displayed charts is added for quick and easy access to the desired chart
• Easy navigation through the charts history via the date/time picker or navigation arrows
• Toggle charts line on and off by clicking on chart legend
• Chart metric and thresholds colors can now be configured in the "Options" dialog
• Changes made on layout or colors are automatically saved so users do not need to set these options every time the application is started
• Metric configuration can now be reviewed or changed directly in the "Alerts" window
• All disk and network metrics are now monitored per disk and per network card
• Ability to exclude devices from monitoring
• Added validation when changing the metrics configuration
• Added database state and SQL Server availability monitoring

Fixes:

• The "Chose server for registration" offers you to add the already monitored server, making the noise and non-monitored servers hard to locate
• The application allows setting of overlapped low, medium, and high threshold values, in which case alerts will not be triggered
• The installer doesn't provide an option to automatically create a SQL Server login for the user that the service will run under, and the service cannot start after installation
• The "Chart size" option allows the graphs to exceed the window size making them unreadable
• The "Object reference not set to an instance of an object" error is encountered when trying to add a remote server instance
• Changing the low alert threshold for the parent metrics item will affect the medium alerts threshold of child items
• The "System performance" tab isn't disabled for remote server instances added using the SQL authentication and the graphs are displayed with the "No data to plot" info text
• Unchecking the "Schedule all available measurements" option will allow the instance to be displayed in the "SQL Server instances" pane but not in the “Configure metrics”, and metrics cannot be displayed, configured or changed
• Inconsistent use of words metric and measurement in the application
• The installation of the repository database on SQL Server 2005 during installation is allowed even if it is not supported and the application will not work properly afterwards
• There is no indication that the remote server instance isn't accessible and that it cannot be monitored
• The "The existing version is the same as the one being installed. The installation cannot continue" message is encountered when reinstalling the application
• The "Manage databases" button on the "Configure metrics" window disappears when a database is selected
• The Network utilization graph shows exaggerated values in the range of over 2500MB/s
• The uninstallation process will ask the user whether he wants to delete the related database, without providing him with information as to what database will be deleted
• The application dialogs cannot be closed via Esc key
• With an increased quantity of collected data in the repository database, the application became slow and switching between the different monitoring tabs can take up to 3 minutes
• The "Unhandled exception: System.InvalidOperationException: Connection was disconnected before the invocation result was received" error is encountered when working in GUI for a longer period of time
• The "An error occurred during data purging." error is encountered when executing Purge data manually
• The "Error while trying to get SQL measurement: Invalid object name 'SYS.MASTER_FILES'" error is encountered frequently and the application stops responding and closes

Changes:

• SQL server instances can now be disabled or enabled
• A database can now be excluded from monitoring in the "Manage databases" tab of the "Metrics" window
• Charts display 30 minutes of measured values
• Removed "History" ribbon group
• Info panels have been removed
• The chart size settings and data purging have been moved to the new "Options" dialog
• The changed charts trackball information style for charts that displays more than two metrics
• The metric period in graphs is now displayed in seconds instead of milliseconds
• Purge data settings has been moved to the "Options" dialog

Known limitations:

• Missing support for clustered Always on servers

Enhancements:

• The "Alerts information" pane is displayed faster when the "Review alerts" option is used
• The "Alerts information" pane is redesigned to be more user friendly
• The SQL Server authentication can be used for connecting to SQL Server instances
• Improved data loading and displaying time for graphs

Fixes:

• When hovering above the diagram line with multiple metrics, the value information about a specific metric is not displayed at all
• The database drop down list is not sorted in alphabetical order
• The monitoring status of the system, server, and database cannot be determined by overviewing the Configure metrics left pane
• The application stops working when switching between monitored SQL Servers if the network connection is lost
• The graph reading hangs and does not show refreshed values after changing the counter reading resolution
• The "Microsoft.AspNet.SignalR.Client: System.InvalidOperationException" error is encountered when trying to change the counter reading time period
• A default remote SQL Server instance cannot be added
• The ApexSQL Monitor service cannot be started after it was manually stopped
• The application service doesn't start automatically after computer restart
• There is no option to resize graphics charts in the application GUI
• The application Info boxes next to the graphs cannot be hidden/removed in order to gained additional space for graphic enlargements

Known limitations:

• Missing support for clustered Always on servers
• The installer doesn't automatically create a SQL Server login on the server for the user that the service will run under, and the service cannot be started afterwards
• The application allows setting of overlapped threshold values, in which case alerts will not be triggered

Features:

• Monitoring most important SQL Server performance metrics on multiple SQL Server instances
• Monitoring most important operating system performance metrics on multiple machines
• Monitoring most important database file parameters
• Select monitored metrics for each SQL Server instance, machine, and database
• Custom configuration for all metrics
• Real-time graphical presentation of monitored metrics
• Metric historic data stored in a central repository database
• Graphical presentation of historic data
• Manually purging of historic data
• Automatic alerting when a threshold value is reached
• Three configurable alerting levels
• Supports SQL Server 2014, 2012, 2008 R2, 2008, and 2005