-
Title
What is new in Spotlight on SQL Server Enterprise 12.3? -
Description
What is new in Spotlight on SQL Server Enterprise 12.3? -
Resolution
New Features:
Plan Analysis
On the SQL Server, SQL Activity | Sessions | Plan and SQL Activity | Query Execution Statistics | SQL details pages the Optimizer Plan Visualization Control has been enhanced to show an Analysis of Query for the selected plan and the operation of each session for the selected plan. See Plan.Factory Reduced Severity Template
When configuring alarms there are two Factory Templates shipped with Spotlight: the Factory Settings Template and Factory Reduced Sensitivity Template. The new Factory Reduced Sensitivity Template reduces the severity of many alarms raised and is more likely to raise a high severity alarm only where the situation presents an availability issue. See Configure Alarms.Configuration Changes Report
This new report reports on configuration changes to the database. See the List of Default Reports.
Windows Disk Space Growth Report
The new report support multiple selected connections. See the List of Default Reports.Enhancements:
SOSSE-7433 - The Spotlight Client and Spotlight Diagnostic Server communicate over TLS 1.2; earlier protocols are no longer supported.
SOSSE-7378 - On the SQL Server | Wait Events drilldown, % of Sample Time replaces the % of Total Available CPU Time metric. The % of Sample Time calculates the proportion of wait time (for this wait type) over the time frame selected for the drilldown page.
SOSSE-7365 - Collection of the support bundle has been enhanced. You can choose not to include the Spotlight Diagnostic Server. In a federated environment you can choose to collect from all or selected Spotlight Diagnostic Servers in a federation. When the support bundle is emailed there is an option to include the Service Request ID in the email.
SOSSE-7336 - On the SQL Server | Workload Analysis drilldown as a performance enhancement the list of SQL statements is loaded 200 at a time. Click Show More to show the next 1000 statements.
SOSSE-7233 - Collection of the support bundle has been enhanced. We no longer capture historical logs automatically. The historical logs are large and rarely used. There is an option to include historical logs in the collection if required.
SOSSE-7224 - Configure | Extended Events has been enhanced with Advanced Settings.
SOSSE-7143 - On the SQL Server, SQL Activity drilldown, Sessions grid the column “Request Granted Memory” has been added.
SOSSE-7038, DS-552 - From the Spotlight Client, the Configure Alarm Action Editor now has an option to enable/disable an alarm action rule.
SOSSE-7034, DS-1076 - From the Spotlight Client, the Alarm Action dialog has a new option for each alarm action rule to “Run this action now on existing alarms”.
SOSSE-6918 - The SQL Server | Overview Page, Blocked Processes component now links to the SQL Activity drilldown | Deadlocks page.
SOSSE-6720 - While viewing the SQL Server | SQL Activity drilldown it is now possible to pause auto refresh.
SOSSE-6701 - In the Spotlight Client the Configure Alarms dialog and Playback panel now have the facility to search for alarms and filter the display accordingly.
SOSSE-6145 - Support has been improved for monitoring SQL Server instances hosted on Linux 2017.
SOSSE-6035 - The Alarm Log has been enhanced with a new entry to the Filter by Time selector (6 hours)
SOSSE-5775 - The SQL Server Wait Events drilldown has been enhanced. Each Wait Type has a direct link to Waitopedia.
SOSSE-5596 - Spotlight Today alarms can now be grouped according to Heat Map order.
SOSSE-5510 - On Configure Custom Counters, SQL Server, an Apply button has been added. If you have just added a new custom counter, click Apply before you click Edit Thresholds so the newly added Custom Counter is available on the Configure | Alarms, Key Value list.
DS-1402 - There is now the ability to connect to an e-mail server that does not have TLS enabled; contact support for details.
DS-1245 - The Extended Events session filter has been enhanced.
DS-1212 - The SQL Agent - Jobs Failed alarm has been enhanced to report on all jobs failed within the data collection period.
DS-1191 - Spotlight Enterprise can now be used to monitor SQL Server 2017 Analysis Services.
DS-976 - Improved efficiency on executing the MoveDiagnosticServerHost stored procedure in the Spotlight Statistics Repository.
DS-502 - Increased the security between the Spotlight Enterprise Diagnostic Server and the Out of Process Collector using sockets instead of HTTP.
SES-197 - Connection Manager has been enhanced with Advanced Options for connection types Availability Groups, Replication, SQL Azure and SQL Server. You can now specify for each connection the connection timeout (in seconds) and the number of retries to attempt before raising a Connection Failure alarm.
SCMM-279 - The Error Log Alarms have been refined and enhanced and are now fully configurable from the Spotlight Client, Configure | Error Log Entries dialog.
For a complete list of enhancements refer to Spotlight Enterprise 12.3 Release Notes new enhancements page.
Deprecated features:
For customized Reports the store procedure spotlight_rt_get_failedsqlagentjobs is deprecated and no longer works. Use spotlight_rt_get_batch_data instead.
Additional information can be located in Spotlight Enterprise 12.3 Release Notes page.