Overview
Welcome to the release notes for SQL Server for Optical Prime 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.
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.
For more information, please see Workloads SQL Server Release Notes and Knowledge base articles.