Release Notes

April 2025 - v25.15.0

New Features

Intergrations

Pager Duty

WISdom now supports PagerDuty integration as a built-in feature. Administrators can configure the PagerDuty integration through the Admin Console under the Integrations screen.

Single Sign-On (SSO)

Single Sign-On (SSO) has been available for several versions, and a new feature has been added to its configuration. Administrators can now test the SSO configuration before saving and applying it to all user accounts.

Here’s how it works:

1. Testing the Configuration:
* After entering all required information on the configuration screens, use the [Test Connection] button to test the SSO setup.
* A new browser window will open and attempt to connect to the configured Authentication Endpoint to validate the SSO settings.
* Once the connection is successfully authenticated, you can save the configuration, applying SSO to all WISdom Team user accounts.

2. New Account Setup:
   • When a new account is set up with SSO applied, an invitation email will not be sent to the new team member via Okta, as Okta has been removed from the authentication process.
   • Inform new team members that they can access WISdom using their network credentials at the following login page: https://app.fortifiedwisdom.com/login.

Enhancements

Errors

Error messages are now clearer and more detailed. Each message includes an error number and a quick copy button to easily copy the error number for submission to WISdom Support. If you encounter an error, please submit a support ticket to support@fortified.com and include the error number. This number is logged with the error message, enabling support staff to quickly triage the issue and assign it to the appropriate resource for resolution.

Secondary Collection Credentials

WISdom now supports the use of secondary credentials assigned to an instance instead of a data collector and instance. These credentials, which are different from the service account credentials, can be used for performing SQL and/or Windows collections. The same credentials must be used to collect both the SQl and Windows metrics.

These secondary credentials, when needed, may be managed in the WISdom UI under Admin Console > Collections > Credentials. You can define secondary credentials on the Credentials page and then apply them to individual instances via the Resources page. Credentials no longer need to be assigned to a specific data collector; instead, they can be defined and assigned to instances in the Resources screen. This enhancement allows a set of defined credentials to be assigned to various instances, independent of the data collector and removes the need to create multiple entries in the Credentials page for each data collector.

Bug Fixes

SSO Errors

A 500 error will no longer be displayed in WISdom for the SSO errors; instead, a more detailed message will be displayed replacing a 500 error message.

Home Page

Previously, under certain circumstances, the Home Page would display data for periods other than 30 days from the selected date. This issue has been resolved. The Home Page now consistently displays 30 days of data from the selected date on every load. It does not honor any other date ranges from other screens in WISdom.

Graph Legends

Previously, the legend in a graph would occasionally display an instance name without wrapping the text to fit the page. This issue has been resolved. All graphs now wrap longer text to fit within the defined area on the page.

Data Displayed for positive UTC offsets

An issue causing data in WISdom to display incorrectly for time zones that are UTC+1 or greater has been resolved. Now, if you are in a time zone that is UTC+1 or higher, the data and graphs will accurately reflect your local time zone.

Silencing Windows

A specific issue where the end time of a silencing window was greater than the selected time range, causing the silence window not to display, has been resolved. Now, any silence window that occurred or is occurring during the selected time range on the Silencing Windows page will be displayed correctly. This fix ensures that all relevant silencing windows are visible within the chosen time range, improving the accuracy and usability of the Silencing Windows page.

April 2025 - v25.14.1

Enhancements

Creating New Accounts via MSP Admin - Account page

This enhancement is exclusively available to clients with a Parent/Child plan in WISdom, primarily targeting Managed Service Providers (MSPs).

Two changes have been implemented when creating a new client account in WISdom via the MSP Admin - Accounts page:

1. The Alerts Sent To Email Address option has been updated to an Email Address/Ticketing System toggle. This allows clients to choose either a specific email address or a predefined ticketing system within the Parent organization to receive alert notifications about data collection issues.
2. After creating a new client with the [Save] button, the drop-down client selector is immediately reloaded to display the new client in the list.
   • This change eliminates the need for users to log out and back into WISdom to reload the Client drop-down list!
   • This same change has been applied when a Client is deleted from the Accounts page.

Query Statistics

Effiiciency Score Drop-Down Filter

We've enhanced the Query Statistics filter capabilities with a new efficiency score filter. This addition allows you to filter all queries based on their efficiency, helping you quickly identify and prioritize performance improvement efforts. The available filter options are:

• Less than or equal to 20%
• Less than or equal to 40%
• Less than or equal to 60%
• Less than or equal to 80%
  

These options enable you to swiftly pinpoint the least efficient queries, allowing you to prioritize and target performance improvements on the most critical areas.

SQL Statement Grouping Flyout

An enhancement has been introduced to the SQL Statement grouping (the default grouping) in Query Statistics. Each top-level row now features an action icon (three vertical dots), providing quick access to detailed insights. This new action allows you to display a flyout that presents aggregated data for all instances and databases included in the filters applied to the query.

The Properties card within the flyout has been updated to show counts for Instances, Databases, and Objects, rather than listing their names. This change offers a clearer overview of the query's impact across your environment. Additionally, the Query Statistics, Projected Total Cost of Code, and Query Information sections now display summation data, highlighting the cumulative effects of the query.

This enhancement enables you to quickly assess the total cost and performance implications of a query running across multiple databases or instances, facilitating more informed optimization decisions.

Alerts

An Alert Frequency data point has been added to the Alert Types flyout in the Admin Console's Monitoring section. This addition provides a clearer understanding of the alert definitions.

Chart Enhancements in WISdom

WISdom charts have undergone a visual and functional upgrade to improve usability and data presentation. Here are the key changes:

Legend and Controls

• New Position: The legend and chart controls have been relocated from above the chart to below it. This change enhances accessibility and provides a cleaner and easier to understand layout.
• Legend Functionality: The legend remains a control for toggling the display of selected colored lines or bars on the chart and allowing multiple objects to be displayed or removed.
• Average Value Display: The average value for the selected time range is now displayed alongside the legend, offering quick insights into overall trends.

Auto-Scale Feature

• Default Setting: The Auto-Scale feature is enabled by default for most charts, providing a normalized view, especially when multiple data objects are present.
• Legend Details: With Auto-Scale activated, the legend displays both the average value for each object and the scale at which the object is displayed.
• Benefits: This feature is particularly useful on the Query Information - CPU & Reads chart located on the Query Statistics flyout. It allows for a unified view of Executions, CPU, and IO on the same chart, making it easier to identify performance changes for a query.
  

These updates aim to enhance the user experience by providing more intuitive controls and a clearer presentation of data trends and performance metrics.

Resource Pressure Icons

The resource pressure icons on the Hosts and Instances pages within the Inventory Module have been standardized to consistently display the same color across all pages.

April 2025 - v25.14.0

We are excited to announce the latest release, which primarily focuses on UI enhancements. These improvements aim to provide a better user experience and more clearly defined information.

Key Highlights:

• Improved Navigation: Streamlined menus and intuitive layouts make it easier to find what you need.
• Enhanced Visuals: Updated graphics and design elements for a more modern and engaging look.
• Clearer Information: Refined data presentation ensures that critical information is easily accessible and understandable.

We hope these updates enhance your experience and make navigating our platform more enjoyable.

New Features

WISdom Data Collector Installer

The new installation package has been designed to streamline the installation process for WISdom data collector services. This update includes multiple new checks to ensure a smoother and easier installation experience.

Key Features:

• Enhanced Messaging: Building on the improvements from the last release, the installer now provides clearer and more informative messages.
• Component Check: The installer validates a .NET Desktop Runtime has been installed that is greater the version 8.0. This currently includes versions 8 an 9, but not 10 as it is still in preview.
• Permission Checks: The installer verifies that the correct permissions have been granted to the service account, including "Log on as Service," local administrative rights, or at least the necessary permissions to the installation folder.
• API Endpoint Connectivity Validation: The installer also checks that the service can successfully connect to the API Endpoint URL.

We believe these enhancements will significantly improve your experience with the WISdom data collector services.

Notification Channels - SMS Support

We have introduced a new method of communication in the Admin Console under Monitoring - Notification Channels. WISdom now supports sending SMS messages using the international format, accommodating both US and Canadian prefixes and numbers. Once an SMS channel is defined, it can be utilized in the creation or modification of profiles.

Auditing of User Actions in WISdom

A new auditing feature that logs user actions related to changes in configurations or settings within the WISdom environment has been implemented. Initially, this data will be accessible only through a support request. However, we plan to make it available directly in the Admin Console in a future update.

Enhancements

Monitoring - Silencing Windows

The Silencing Windows screen now features a time range selector to help refine your search. By default, the date range is set to two months, covering one month before and one month after today's date. This range is customizable, allowing for easier management and quicker searching of your silencing windows.

Inventory - Instances

SQL instances that are part of a failover cluster now display both nodes in the Host(s) column in the Database Instances table. The current primary node is highlighted in bold print with status of which host is the primary node checked hourly.

Home Page Update

The Home page has been updated to display the total number of Opportunities in the Operational Analytics section. This replaces the previously displayed Data Protection information. Clicking the [>] button will now navigate directly to the Environment - Opportunities screen.

UI Enhanced with Toggle buttons

Various screens have been updated with a new toggle button, replacing the previously used tabs. This change is particularly noticeable in the Flyouts available in the Environment module. The new toggle button will enable users to more easily see and navigate the tabs on the screen with the active toggle displaying blue.

Impacted Screens:

• Activity Flyout
• Activity Details Flyout
• Blocking Details Flyout
• Deadlock Details Flyout
• Query Details Flyout
• Blocking
  • Top Chart
  • Bottom Grid
• Jobs
  • Top Chart

Monitoring - Alerts

The Alert drop-down filter has been updated to improve the display of data for the selected alert and minimize the presentation of additional information.

Deleting a Data Collector with Assigned Instances

When attempting to delete a data collector that still has instances assigned to it, a message will display listing the instances still associated with the data collector. The deletion cannot proceed until these instances are reassigned.

The message provides two links that navigate to the Collection - Resources screen and apply a filter showing all instances still assigned to the collector. This filter allows you to:

• Quickly select all the instances.
• Use the bulk edit feature and the [Assign Value] button to either:
  • Assign the instances to a new data collector.
  • Set them to an Unassigned status to stop collections.

Then return to the Data Collectors screen and delete the selected data collector.

Admin Console - Monitoring - Profiles

For clients with a Parent/Child plan (MSP) in WISdom, any Profile that includes an instance marked as Managed by Parent by the parent client will not be editable by child client users. Only a Parent MSP Administrator has the authority to edit the Profile or change the Managed by Parent setting.

March 2025 - v25.13.0

We are thrilled to announce the newest version of WISdom! The star of this update is the long-awaited support for Query Store. But that's not all! We've also packed in some fantastic enhancements, like the Grouping of Tags in the Tags filter and a smoother WISdom service installation with clearer messaging. Plus, we've squashed some pesky bugs to make your experience even better. Get ready to dive in and explore all the amazing new features!

New Features

Query Statistics

Effortless Query Store collection with zero setup! If Query Store is already configured for your database(s), the WISdom collection service will automatically start gathering data from Query Store to enhance the information available on the Query Statistics screen. Stay tuned for even more Query Store collections and data displays in upcoming releases!
If you've been thinking about enabling Query Store in your environment, this is the perfect time to take the leap!

Enhancements

We've enhanced the usability of popovers and dropdowns throughout the application, making your experience more consistent and intuitive. All pop-up displays now feature up to 8 rows per page, a handy search bar at the top, and a download icon conveniently located in the upper right corner. Additionally, the Tag pop-ups in the Inventory module and the Admin Console's Collections - Resources section have been standardized to display 8 rows per page in two columns: Tag Group and Tag. They also include a convenient new Edit Tag feature right within the pop-up.

Tags

Tag Management

The Admin Console's Tags section has been enhanced to simplify tag management, now featuring inline editing for both Group Names and their associated values, making your experience smoother and more efficient.

Drop-Down Filter

The tags drop-down filter has been enhanced for easier use and selection. Tags are now organized by group name, with an expander for each group to view and select all values for the filter.

WISdom Service Installer

The WISdom installer has undergone a complete redesign, offering a smoother and more streamlined experience for installing the collector. The process has been simplified with fewer steps, and troubleshooting has been enhanced with clear, concise messaging to help you quickly resolve any issues that may arise.

Environment Module - Alert Status

The Alert Status widget, located on the Hosts - Overview and Details and Instance - Overview and Details screens, has been improved for better clarity and usability. Now, clicking on the Critical, Warning, or Information icons will take you directly to the Monitoring - Alerts - Details page. This action will apply a Severity filter based on your selection and add the "Alert Status = Open" to any existing Instance or Host filters selected in the Environments screen, displaying all open alerts with the selected severity.

Silencing Windows

We're excited to announce a few updates to the Silencing Windows feature:

• The Silencing Windows tab has been relocated to the Admin Console - Monitoring screen.
• With this move, we've introduced the ability to create recurring windows directly in the UI. When setting up a new silencing window, you can now toggle between Make recurring and Make one-time. The recurring option allows you to define windows that repeat Daily, Weekly, or Monthly and set an end date for the recurring window.
• Additionally, the table displaying silencing window details has been streamlined. The Start Time and End Time columns have been combined into a single Information column. This new column now displays the start date and time for non-recurring silencing windows, or the day on which recurring windows occur.

Bug Fixes

Tag Assingment

When assigning tags in any screen that supports tag editing, a selected tag will now appear below the Add Tag dialog once chosen. Each selected tag will be added to the list of all tags associated with an object. Additionally, each tag in the list will feature an X on the right side, allowing for easy removal of individual tags. Once the list has been updated, clicking the [Save] button at the bottom will apply the selections to the object.
Tags that are system generated or managed by the parent organization will no longer display in the Edit Tag dialogue boxes.

March 2025 - v25.12.0

WISdom v25.12.0 is now live, bringing new features, enhancements, and bug fixes.

New Features

We have introduced a new Integrations module into the Admin Console.

Integrations

The integrations screen apps related to Single Sign-On (SSO), ticketing system integrations, Zendesk and ServiceNow, and an Alert Webhook for WISdom.

Security - SSO

Clients can set up Single Sign-On (SSO) by configuring an OIDC-compliant application within their identity provider, such as Azure Entra, and integrating it with WISdom. This process includes creating client credentials, whitelisting redirect URLs, and configuring the application to trust WISdom. The platform supports authentication protocols like SAML and OAuth/OIDC.

Ticketing System

WISdom now offers integrations with both Zendesk and ServiceNow. To set up the connection, you need to provide a Name, an Endpoint, and a Token for the respective ticketing system. Once configured, alerts can be sent directly to the specified ticketing system.

Alert Webhook

The WISdom Webhook has been designed to facilitate the ingestion of alerts generated by WISdom into various customized applications and dashboards. This allows for seamless integration and real-time monitoring. The data is transmitted in JSON format, ensuring compatibility and ease of use across different systems.

Enhancements

Admin Console

We're excited that the Admin Console has been relocated to the navigational bar on the left side of the WISdom UI, directly beneath the Compliance module. This change is designed to provide easier access and a more intuitive workflow.

Additionally, the visibility and configurability of the Admin Console is determined by the profile assigned to each user, ensuring a personalized and efficient experience.

Blocking

The Blocks by Object table has been enhanced for improved functionality and usability. Now, when you open the page, the table is grouped by the table object, providing a clearer and more organized view of the impact from all blocks.

Expanding a table group displays the amount of blocking and its impact by Index ID. Clicking on an Index ID row or selecting the View Details action will open the Index statistics screen, filtered by Instance, Database, and Table. This offers additional insights into the impact of blocking, helping you better understand and manage database performance.

Activity

The Activity Overview screen now includes a Wait Category column in the Top Wait Types slicer. This new column is linked to the Wait Category filter, allowing you to filter the slicer by the selected category.

MSP Admin

When creating a new Client account from the Accounts section, the pop-up wizard now features an enhanced workflow for a simpler account creation process. You need to fill in two required fields: Account Name and Alerts Sent To Email Address. The Display Name field is optional; if left blank, the account name will be displayed.

The Alerts Sent To Email Address will be used to create a Profile in the Admin Console - Monitoring - Profiles page and will send any collection error alerts to the provided email address.

Bugs

Admin Console

Collections - Resources

Both the Profile and Data Collector may be set to [Unassigned].

• Profile: Setting the Profile to [Unassigned] for an Instance will remove the instance and its corresponding host from the Resources list associated with the removed Profile. This action will also stop alerting for both the host and the instance.
• Data Collector: Setting the Data Collector to [Unassigned] at the instance level will change the instance and host's Data Collection Status to Not Collecting. This action will stop all data collections for the target and decrease the Active Licenses count in the Admin Console - Subscription page, freeing up the license for use on another instance.

February 2025 - v25.11.1

Version 25.11.1 is now live, featuring enhancements and bug fixes.

Enhancements

Subscription and Collection Management

Subscription management has been relocated to its own screen within the Admin Console, under the Collections module in the Resources screen. The Inventory screens for Hosts, Instances, and Databases will still support tag management for the respective objects.

The new screen now contains data related to the configuration of instances and hosts in WISdom. The Resource table includes the following columns, Resource Type (Instance or Host), Data Collector, Data Collection Status (Collecting or Not Collecting), Credentials, Profile, and Tags.

Subscription Management

The method of managing subscriptions and collections has been modified to accommodate both Hosts and Instances being displayed on the same page.

Add subscriptions
Click the blue button in the upper right corner of the screen, now labeled [+ Resource(s)]. The flyout requires you to define a* Data Collector, Monitoring Profile, Credentials,* and Instances List. Setting the Data Collector to [Unassigned] will add the instance(s) in a Not Collecting state, while setting the Monitoring Profile to [Unassigned] will add the instance(s) without alerting defined.
A new switch, Managed By Parent Organization, has been added at the Instance level! This feature is designed for MSPs and multi-level organizations with child-level clients (organizations). Enabling this switch for an instance with an account in the Parent Client will restrict editing of the instance at the child-level accounts, even if they are using an Administrator profile.

Managing Subscriptions
Setting the Data Collector to [Unassigned] for an existing instance will stop data collection for the instance and related host, freeing up a subscription for use with another instance. It is not necessary to change the Monitoring Profile; when an instance is not collecting, it will not raise any alerts.

Deleting Collection Targets
Collection targets can be removed from WISdom via the Collection - Resources screen. The action icon (three vertical dots) at the end of each row in the Resources table includes a delete option for both Host and Instance objects. The ability to bulk delete has been added to this page. Select all the objects you wish to remove, click the [Assign Value] button, and choose the Delete option. Note that Bulk Delete will not remove multiple Hosts; a warning will be displayed for the selected hosts indicating they will be skipped. Deleting an instance will also remove its associated host.

Activity Module

Both the Activity Overview and the Activity Compare screens have been updated.

Activity Overview

A compare button has been added to the upper right corner of the screen.

Selecting the [Compare button] will jump to the Activity Compare screen honoring any instance filter selected.

Activity Compare

When you navigate to the Compare screen with a filter applied for an instance, the selected instance will automatically appear in the instance selector. If multiple instances are selected or no filter is applied, the instance with the highest activity will be displayed by default.

Additionally, the date and time selection options have been enhanced. You can now choose specific start times down to the minute and select a time range of the previous 1, 3, 6, 12, or 24 hours.

Tags

Three new system tags have been introduced to quickly highlight the top 10% of instances based on specific criteria. These tags are:

• Top 10% Instances: Compute and Storage Cost
• Top 10% Instances: Data Size
• Top 10% Instances: Transaction Workload

These tags are automatically assigned and updated nightly for instances that meet the criteria.

These tags simplify the identification and management of key instances, saving time and enhancing operational efficiency. By highlighting the top-performing instances, users can concentrate their monitoring efforts on the most critical ones, potentially boosting performance and optimizing cost management.

Bugs

Activity Details

When using the Group By functionality in the Resources table of the Activity Details flyout, all displayed data will now adhere to the time range selected for the details flyout.

February 2025 - v25.11.0

New Features

We are excited to announce 2 HUGE new features have been released today, Alerting and Custom Costing.

Alerts

A new alerting module has been added, featuring dedicated screens for managing alerting channels and assigning alerts to custom profiles. The revamped Alert screen now correlates all raised alerts for various objects. All alert configuration and management screens are located under the new Monitoring tab in the Admin Console.

Custom Costs

Custom costing can now be assigned to individual Hosts, improving cost estimations displayed throughout WISdom. Cost resources are managed and assigned via the Admin Console's Cost Management tab and Inventory - Hosts screen, respectively.

Enhancements

Admin Console

Several changes have been made to various screens in the Admin Console, as listed below:

Tags
Availability Group (AG) names now have automatically generated tags. These tags, derived from the AG name, are assigned to all AG nodes and updated hourly to reflect any changes.

Collections

Data Collectors
The Data Collectors table now includes an Instances column. Clicking this column opens a popup listing the instances assigned to that Data Collector.

Bug Fixes

MSP Admin

Accounts
The link to jump to the Accounts page in the Admin Console has been fixed.

Activity

Compare Screen
The issue preventing the anomaly list from displaying when clicking the red anomaly count has been resolved.

February 2025 - v25.10

New Features

The new Alerting module is almost ready, some aspects of the new alerting module have been released in this release.

Enhancements

Tags

Tags can now be assigned to databases in the Inventory - Database screen. Clicking the action icon (three vertical ellipses) opens a flyout where tags can be assigned at the database level. Additionally, tags can be managed in bulk by selecting specific databases (or all), clicking the blue [Assign Value] button, and selecting tags to assign or deselecting tags to remove.

Admin Console

This release contains new additions to the Admin Console, the Account, Subscription, and Monitoring tabs have been added. Regular Users can now view information across all areas of the Admin Console, while users with the Administrator profile have elevated management rights.

Account

This tab contains information related to account setup, including:

• A Display Name field for clients to change the name displayed in WISdom.
• The ability to upload a client logo.
• A Collection checkbox that, when unchecked, turns off all collections for the client.
• An Alerting checkbox that, when checked, requires a "to" and "from" email address and turns on all default alerts.

Subscription

Provides details related to the client's subscriptions, including the Plan Type, number of Active Licenses, total License Count, and service start and end dates.

Monitoring

This new tab contains 3 tabs related to configuring alerts.

Notification Channels

Provides an interface to create and manage email notification addresses.

Alert Types

This page lists the available alerts for notification. The table includes columns for the alert Name, alert Description, a Profiles indicator showing the number of profiles assigned to each alert, and an Alert Categories column listing the number of categories each alert falls into. Both the Profiles and Alert Categories columns display the list of objects for selection when clicked.

When the action icon (three vertical ellipses) is clicked, the Alert Type Details flyout appears. This flyout includes the alert Name, Default Severity, Alert Categories list, Description, Recommendations for resolution, and a Rules section. The Rules section explains how and why an alert is raised, detailing the Alerting Logic and Tolerance Settings for the Low, Medium, and High settings.

Profiles

The Profiles feature includes two predefined profiles: 24/7 Monitoring and Core Business Hours, with the option to create custom profiles. Each instance can be assigned to only one profile. Each profile can have all or selected alerts assigned, and each alert's severity level can have one or more notification channels assigned.

Bug fixes

Activity Details Export

When exporting the Activity Details table data from the Database - Activity - Details page to Excel, the date is now included with the timestamps, providing a clear indication of the specific day in question.

Database Space Allocation Pop-up

When clicking on the Data Space Reserved or Transaction Space Reserved on the Database Space Allocation card in the Environment - Instances screen, the pop-up informational box now displays the correct title for each pop-up.

January 2025 - v25.9.0

WISdom version 25.9.0 is now live featuring bug fixes, enhancements, and behind the scenes works in preparation for the new alerting module coming soon.

Enhancements

Monitoring - Alerts

You can now filter alerts displayed in the Overview or Details screens by their Alert Status. This filter lets you choose between Open and Closed alerts while leaving it unfiltered will display all alerts.

Login Page

Clear messaging is displayed when a session times out during the login process, providing better guidance for the user.

Pop-up Lists

All pop-up lists on the WISdom platform are now standardized. Lists with 8 or fewer entries will display in a single pop-up without a Search box. For lists with more than 8 entries, the entries will be paginated, and a Search box will appear at the top of the pop-up.

Tags

A new system tag for an Availability Group Name has been introduced in WISdom. This tag is automatically assigned to each instance node of an availability group. An instance may have more than AG Name associated to it.

Bug Fixes

Admin Console - Teams

When managing team members, selecting the deactivation option will disable the user's account, preventing access to WISdom. The account will be marked as Deactivated on the Teams page, indicating that it can be reactivated later. Once reactivated, the user can log in using their previous credentials and multi-factor authentication (MFA).

Monitoring - Collector Health

Collection Errors flyout
The Since timestamp at the top level of the drop-down expander has been updated from UTC to Browser time. This change ensures consistency with the Since timestamp in the expanded details section and the display of all times in the Browser timezone.

Monitoring - Alerts

Exclusionary Filtering
The drop-down filters for Alert, Alert Category, and Severity now support exclusionary selections. These exclusions will remove any matching records from both the Overview and Details pages.

Admin Console - Monitoring

In the previous release, the Data Collectors, Credentials, and Silencing Windows pages were consolidated into a new Monitoring tab in the Admin Console. These three pages now reside under the new Collections tab. This change allows all users with administrator rights to view and modify objects on the related pages.

January 2025 - v25.8.0

The latest release is setting the stage for the upcoming version of alerting in WISdom by laying a strong foundation and ensuring a consistent user interface experience in addition to resolving a few bugs.

New Features

Monitoring - Alerts Module

The Alerts Module has been given a facelift! Both the Overview and the Details pages have been revamped, while the Alerts List page has been removed. The available filters are now Host, Instance, Alert Category, Severity, Alert, or Tag.

• Overview Layout
  • Top Alerts by Severity - New
    • All alerts have been defined by a severity of *Critical, Warning, *or Information
    • This chart provides a quick count by severity for the selected time range
  • Top Alert Category - New
    • Displays a pie chart defined by the alert category
  • Top Resources - New
    • This table displays the alert count by category for each instance or host
  • Top Alerts - Updated
    • The columns of data displayed have been updated
• Details Layout
  • The Alerts table has updated the column data
    • Note the new Resource column replaces the Server column and specifies the object related to the alert
    • An Alert Category column has been added
    • A Tags column has been added
    • Several columns have been removed

Enhancements

Login Page

The login page has been refreshed with a new logo, coloring, and layout, providing an updated look and feel, while the functionality remains unchanged.

Admin Console

The Admin Console has undergone reconfiguration. A new module named Monitoring has been added. It includes the Data Collectors, Credentials, and the Silencing Windows pages, which has been relocated from the Monitoring module. This change aligns with the effort to consolidate all configuration pages within the Admin Console.

The Data Collectors page has been reformatted:

• The [Download WISdom Installer Package] button has been moved to the top right side of the page, next to the add data collector button.
• The Data Collectors table now includes a Status column and an updated Instances column.
  • The Instances column features a new indicator for the monitored instances.
    • Clicking the new icon displays a paged list of all instances monitored by the data collector.
  • The Status column includes a toggle that allows you to Disable or Enable a data collector.
    • A disabled data collector does not perform any collections for the assigned targets.
    • A disabled data collector does not display in the Collector Health page.
    • A disabled data collector does not display in the Data Collector drop-down filters.
    • Instances assigned to a disabled data collector are not modified in the Inventory - Instances page.

Bug Fixes

Silencing Windows

• When creating or editing a silencing window for an instance, the list of instances displayed in the flyout are now the instance names instead of the host names
• The Silencing Windows table now displays Current, Completed, and Future silencing windows

December 2024 - v25.7.0

We are excited to announce the latest release of WISdom, which includes two powerful new features designed to enhance your SQL instance management and analysis capabilities! A new option in the Activity screen, allowing you to compare both workloads and configurations for deeper insights and more efficient management.

The release also includes numerous bug fixes, user experience improvements, and backend enhancements and upgrades to optimize system performance and support future feature additions. Below are the detailed enhancements and bug fixes:

New Features

Environment - Activity

1. Workload Comparison Across Dates
   • Feature Overview: Compare workloads on two different dates for the same or different SQL instances.
   • Functionality: This feature allows you to select two dates and compare the performance and workload metrics of your SQL instances. Easily identify trends, anomalies, and performance changes between the selected dates with the option to view only variances or all SQL statements on both selections.
   • Benefits: Gain insights into how your SQL workloads evolve, helping you to find optimization opportunities and quickly find changes in the performance of your workloads. This is especially beneficial when deploying changes that could impact the workload.
2. Configuration Comparison
   • Feature Overview: Compare the configuration settings of the same SQL Server or two different SQL Servers.
   • Functionality: Choose to display either only the differences in the configurations of the server or all configuration settings for both servers. This feature provides a detailed comparison, highlighting any discrepancies or changes in configuration.
   • Benefits: Quickly identify configuration mismatches, ensure consistency across environments or clustered nodes, and streamline troubleshooting and auditing processes.

Enhancements

• Enhanced Login Page: We are pleased to introduce improvements to the WISdom login page, designed to streamline your login experience:
  • Email Auto-Population: When you open the login page at https://app.fortifiedwisdom.com/login, the email address you previously used to log in will now be automatically populated.
  • Quick Login with ENTER: You can now submit your login credentials by simply pressing the [ENTER] button, eliminating the need to tab to the Sign In button or use your mouse to click it.
• Zendesk Integration: The integration with Zendesk has been improved to include previously missing ticket information. This ensures that all relevant ticket details are now accurately captured and displayed.

Bug Fixes

• Home Page:

  • Performance Score Display: For accounts created after the migration of WISdom to Azure, the Performance score is now correctly displayed. This fix ensures that new users can view their Performance score without any issues.
  • Resource Health Score Consistency: The algorithm used to calculate the Resource Health score on the Home page has been updated. It now matches the algorithm used on the Monitoring - Resource Health page, ensuring consistency in the Resource Health score across both pages.
  • Workload Summary section
    • Database Health Table: The scores in the Database Health table are now rounded to the nearest tenth or whole number. This change enhances readability and accuracy, making it easier for users to interpret the data.

• Environment – Hosts and Instances: The** Migrate** feature on either of the pages has been updated to allow the export of the migration information into Excel.

• Database - Activity Page:

  • Activity Flyout: The calculation for the Wait Time in the Wait Statistics page of the Activity Flyout has been updated to accurately reflect the total wait time for each Wait Type.
  • Activity Details Page: We have resolved a drill-down issue allowing users to correctly drill into all selected time ranges, allowing access down to the detailed 1-minute data for the chosen time range.

• Database - Blocking Page:

  • Blocker ID Filter: The Blocker ID drop-down filter now correctly filters all data on the Blocking page based on the selected ID(s).
  • Overlay Calculations: The calculations for the Day of the Week and Time of Day overlays have been updated to accurately reflect data on the Blocking Events and Blocking Victims graphs.
  • Blocks by Object: The Block Wait Time calculation now correctly sums the Page Wait Time and Row Wait Time data.

• Admin Console - Teams Page: The Teams page now correctly allows users to be deactivated, reactivated, sent a new invite, and re-invited when a previously sent invite has expired. These fixes ensure smoother and more reliable user account management.

• **Monitoring - Resource Health Page:

  • Resource Health Score Consistency: The algorithm used to calculate the Resource Health Score on the Home page has been updated. It now matches the algorithm used on the Monitoring - Resource Health page, ensuring consistency in the Resource Health score across both pages.
  • Instance Health Table: The Database Health column has been updated to support sorting, enhancing the usability and data management on this page.

• Database - Activity - Compare: Corrected the messaging when an instance selected for comparison does not have more than 2 full days of data for compare.

November 2024

Release Notes

This release primarily focused on the migration of our data center and updating all processes to the new Azure environment, replacing the previous infrastructure. Key highlights include:

• Data Center Migration: Successfully migrated our data center to Azure, ensuring a more robust and scalable infrastructure.
• Process Updates: All processes have been updated to align with the new Azure environment, replacing the old processes to enhance efficiency and reliability.
• Bug Fixes and Inconsistencies: Addressed and resolved various bugs and inconsistencies as they were found or reported by users. This includes improvements in data accuracy and system stability.

This migration and the associated process upgrades will enable further backend improvements, optimizing system performance and laying the groundwork for future feature additions and enhancements. These changes are crucial for maintaining high performance and reliability, ensuring that we can continue to meet and exceed user expectations.

Thank you for your continued support and feedback.

October 2024 - v25.6.0

Enhancements

Performance Improvements

We are gearing up for the planned data center migration in November. This migration is set to significantly boost the performance and capabilities of WISdom.

Tag Filtering
The new Tagging feature released in the previous releasae has been incormporated on additional pages.

• A Tag drop-down filter has been added to the Security page in the Compliance module. This update also resolves occasional errors encountered when accessing the page.

The Tag drop-down filter has also been added to the following pages in the Monitoring module:

• Alerts
• Resource Health
• Performance

Bug Fixes

This release includes several bug fixes.

Time of Day Filters

• The time of day filters on the Blocking and Deadlocks pages have been updated.
• The Details table on each page now correctly applies the selected Time of Day filter(s), displaying only data within the chosen time range(s).
• This update resolves the occasional error when opening the Deadlock Details flyout on the Deadlock Details page and the Blocking Details flyout on the Blocking Details page with a Time of Day filter selected.

Charts X-Axis

• The X-Axis for all charts has been updated.
• It now consistently starts at the beginning of the interval that includes the start time of the selected time range.

Resource Health

• Under specific circumstances, the Hosts Health scores were not displaying in the Host Resource Scores table, even though they appeared in the Overall Performance chart.
• This issue has been identified and resolved, ensuring all scores now display as expected.

October 2024 - v25.5.0

Enhancements

Tags
Custom tags are now available in WISdom! Administrators can manage these tags. All users can utilize all tags in the drop-down filters, this includes automated tags and the custom tags!

Tag Administration

Administrators can create these tags through the newly added page in the Admin Console.

Create New Tags and add Tag value(s)

Quickly search the existing tags to manage tags

Tag Assignment

The ability to assign Tags is now available on the Inventory - Hosts and Inventory - Instances pages. Tags may be assign when editing a single instance or using the Bulk Edit function. When selecting multiple instances or hosts, a new [Assign Value] button will open the Bulk Edit flyout. When editing a single instance or using the Bulk Edit function, the Tags drop-down selector allows you to assign one or more tags to the instance(s).

Tag Drop-Down Filter

Quickly filter data on the page via the Tags drop-down filter now an available option for filtering data on most pages in WISdom.

Performance Improvements

Updates to backend processing have been implemented to provide better front end performance on the WISdom client

Bug Fixes

The Query Details flyout now displays the time range selected on the the Query Statistics page.