Overview
Welcome to the release notes for SQL Server enhancements for Live Optics. To avail of the most recent releases, please ensure that you download the latest version of the Live Optics collector to get the latest updates and enhancements. We encourage you to follow this page to receive email notifications when this document is updated.
12/03/2020 | Version 2.2
New Features/Fixes
Improving the Workloads SQL Server collection with the addition of the option to collect performance metrics using Optical Prime (recommended). The SQL workloads will continue to allow for Config-Only collection using SQL connection through SQL authentication or Windows authentication.
New Features include:
- Collecting SQL Server Config and Performance as part of Optical Prime collection.
- Config Data Only Workflow of SQL Server remains unchanged providing familiarity and reliability.
- Reporting Database File Locations as part of the Config-only collection.
Known Issues
No issues are currently known for version 2.2.
Known Limitations
No limitations are currently known for version 2.2.
10/23/2020 | Version 2.1
New Features/Fixes
SQL Server for Optical Prime now collects and reports SQL Performance metrics during the Optical Prime collection. The data for each discovered SQL Server Instance is collected and presented within its own individual SQL Server viewer. The output of which is in the form of graphs and a downloadable excel report. The Instances also continue to be aggregated as part of the Optical Prime Project, within a SQL Server tab containing links to each SQL Instance collected.
New Features:
- Collecting SQL Performance metrics
- Reporting Performance metrics in a downloadable .xlsx report
- Reporting Performance metrics in graph form on the SQL Instance Project viewer
Known Issues
No knowns issues are currently known for version 2.1.
Known Limitations
The current known limitations of version 2.1 are;
- Optical Prime Association to SQL Instances only takes places via Live Stream but not when standalone projects are uploaded via SIOKIT.
- There is no ability to disable this feature in Optical Prime or Workloads SQL Server
05/12/2020 | Version 2.0
New Features/Fixes
- SQL Server config data collected during Optical Prime collection
Known Issues
The following known limitations should be considered when using Live Optics to assess an SQL Server Instance;
- SQL Server can be discovered on the environment regardless if the SQL Service is RUNNING, NOT RUNNING, DISABLED or PAUSED status.
- User will not be notified upon creation of SQL Server projects spawned from Optical Prime parent projects. The user will only be notified if the SQL project is in an ERROR status or has failed to upload to the Live Optics Web Portal.
- SQL Server projects spawned from an Optical Prime parent project will not appear in the Live Optics Dashboard. SQL Server child projects are searchable through the Project Search option in the Live Optics Web Portal.
- If the SQL server instance has not been given a name, the instance will appear as MSSQLSERVER. This is the default instance name.
- The field FILESTREAM CONFIGIURED LEVEL appears blank for SQL SERVER versions 2008 and 2008 R2. This indicates that the feature is unsupported by these versions.
Known Limitations
The current known limitations of SQL Server are;
- Browser must be refreshed to see the project updates
- Once the project is uploaded to the Web Portal, and the user must refresh the page in order to see the updated project status.
- Internet connection is required
-
- To run a collection where the user chooses to upload the project to the online web portal, the collector must have access to the internet.
- If the user attempts to run a collection and upload it to the Live Optics Web Portal without an internet connection, the user will be presented with an error prompting them to run the collection once more and save their project as an SIOKIT. to upload later when the collector has internet access.
-
- The Live Optics Collector services must be allowed through the user firewall to run a successful collection.
02/07/2020 | Version 1.0
New Features/Fixes
- Initial release
- SQL Server configuration data collection
Known Issues
The current known issues for SQL Server are;
- The Workload SQL Server Asset is currently in Limited Preview Mode. Limited Preview is designed to collect limited configuration data from the nominated SQL Server Instance. In order to run a successful collection for SQL Server for Workloads, the specific conditions detailed in the Prerequisites to running a Workloads | SQL Server Collection in Limited Preview Mode Knowledge Base Article must be met.
Known Limitations
The current known limitations of SQL Server are;
- The browser must be refreshed to see the project updates
-
- Once the project is uploaded to the Web Portal, and the user must refresh the page in order to see the updated project status.
-
- Internet connection is required
- To run a collection where the user chooses to upload the project to the online web portal, the collector must have access to the internet.
- If the user attempts to run a collection and upload it to the Live Optics Web Portal without an internet connection, the user will be presented with an error prompting them to run the collection once more and save their project as a SIOKIT to upload later when the collector has internet access.
- The Live Optics Collector services must be allowed through the user firewall to run a successful collection.