What is new in Spotlight on SQL Server Enterprise 12.1?
New features:
Choose not to store SQL text and query plans in the Playback database - A new configuration for the Spotlight Diagnostic Server allows you to disable storing this data from all monitored SQL Server. To disable storing this data for some monitored SQL Server:
1) Configure the Spotlight Diagnostic Server to enable storing this data for monitored SQL Server
2) Use the SQL Server | Connection Details screen to disable storing this data for individual monitored SQL Server.
Enhancements:
SOSSE-6829 - New SQL Server alarm, Databases - Data File Group About to Grow, disabled by default, which when enabled alerts the Database Administrator before a file is about to grow.
SOSSE-6797 - Enhancement to the SQL Activity | Sessions page - New “Loading…” indicator shows the SQL statement and Plan are loading.
SOSSE-6756 - Enhancements to the SQL Server | Support Services | Service Status page.
SOSSE-6735 - Updated the link to the new Spotlight Enterprise Community page.
SOSSE-6651 - On the SQL Server | Databases drilldown, Databases grid and Fragmented indexes grid, click Ctrl+A to ‘Select All’ rows. Click outside the grid to clear selected rows.
SOSSE-6598 and SOSSE-3642 - Enhancements to the SQL Server | Workload Analysis, Wait Events and Performance Health drilldowns to reduce loading time and consume less memory.
SOSSE-5757 - On the SQL Server | Workload Analysis and Wait Events drilldowns you can now export all SQL statements to a file.
SOSSE-5755 - On the SQL Server | Workload Analysis drilldown, right click on a SQL statement to view the SQL statement in an external editor.
SOSSE-5388 - Enhancement to the SQL Server | Wait Event drilldown, visualization of Wait Types and SQL Statements.
SOSSE-4303 - When monitoring SQL Server | SQL Activity drilldown | Sessions page, added a “Thread Count” column to enable the ability to display a single row per session as an option.
SOSSE-3091 - SQL Replication - Subscription Expiration alarm alerts prior to replication subscriptions expiring.
SOSSE-2532 - On the SQL Server | Databases drilldown | Fragmented indexes page - select multiple indexes to Generate Defragmentation Script for all selected indexes.
DS-897 - Enhance Spotlight performance by implementing a common service to resolve SQL text and SQL plan for procedures: QueryExecutionStatistics, SQLBlockingList, SQLConnectionList, SQLConnectionDetails, WaitEvents and WorkloadAnalysis.
DS-757 - Improved user interface design around previous unfriendly error message: “Unknown Identifier asked for extended events. Please connect.”
Deprecated Features:
Spotlight Enterprise no longer monitors SQL Server 2000.
