What's new for Spotlight on SQL Server Enterprise

September 2017

Subscribe to the RSS


Top

Documentation

New

None at this time

Revised

None at this time

Top

Patches

New

None at this time

Revised

None at this time

Top

New

None at this time

Revised

None at this time

Top

New
233255 - Alarm Action 'Execute a SQL script' action does not execute entered script for Availability Groups connections

Alarm Action 'Execute a SQL script' action does not execute entered script for Availability Groups connections.

Created: September 28, 2017
233090 - Can connection custom Views be ordered by the highest alarm severity rather than alphabetically?

User requesting the following on connection custom Views: 1. Would it be possible to order the custom views by highest severity rather than...

Created: September 21, 2017
233108 - Performance problem when trying to load lots of data (long period, existing lots of SQL statement, etc) in workload analysis or wait event in version 12.1

Sometimes there is a performance problem when trying to load lots of data (long period, existing lots of SQL statement, etc) in workload analysis...

Created: September 22, 2017
232985 - The Growth: File Used MB graph will not maximize

The Growth: File Used MB graph will not maximize. <img alt="" height="457" src="https://prod-support-images-cfm.s3.amazonaws.com/KB_1-4D8IPS3...

Created: September 18, 2017
233075 - Creating Custom Reports documentation in version 11.7

Why does the documentation say that RDL files for SQL Server 2005 and SQL Server 2008 as custom reports are supported?

Created: September 21, 2017
233290 - SQL Copy button in Workload Analysis page copies in HTML format which should be in SQL format

In Workload Analysis, when you right click on a SQL statement, copy then paste into an external editor like notepad because you don&rsquo;t have...

Created: September 29, 2017
233027 - Incorrect details in the Total Memory Help page about MAX memory

In the Help File for Total Memory, the information is incorrect. See screenshot below with the highlighted incorrect information:<img src="data...

Created: September 20, 2017
232991 - Is there an alarm to disk(out of disk space) or Lock alarms(deadlocks etc) for Azure connections?

Is there an alarm to disk(out of disk space) or Lock alarms(deadlocks etc) for Azure connections?

Created: September 19, 2017
233108 - Performance problem when trying to load lots of data (long period, existing lots of SQL statement, etc) in workload analysis or wait event in version 12.0.1

Sometimes there is a performance problem when trying to load lots of data (long period, existing lots of SQL statement, etc) in workload analysis...

Created: September 22, 2017
233056 - Left-click in the Spotlight Overview page to show alarm details doesn't come up

When you left-click in the Spotlight Overview page to show alarm details, the details page doesn&#39;t come up. &nbsp;It flickers as it to display...

Created: September 20, 2017
233061 - Network ports for Spotlight

Spotlight's ability to function, to collect and display data, may depend on account permissions granted over the network and specific open network...

Created: September 20, 2017
233226 - Can't run Spotlight for SQL Server report.

I have someone who&#39;s user account is a member of the diagnostic server local group &quot;Spotlight Diagnostic Users&quot;.&nbsp; &nbsp;They...

Created: September 27, 2017
233204 - Event Viewer Error: Attempt to load duplicate configuration for Service LucyService

The Spotlight Diagnostic Server will not start when opening Spotlight. When restarting the Spotlight Diagnostic Server service, it shuts off again...

Created: September 27, 2017
233205 - Where does Spotlight pull the SQL Instance Configuration data?

Where does Spotlight pull the SQL Instance Configuration data? <img alt="" height="104" src="https://prod-support-images-cfm.s3.amazonaws.com/KB...

Created: September 27, 2017
233225 - What is the latest SSRS version that can use to run the Spotlight reports?

What is the latest SSRS version that can use to run the Spotlight reports?

Created: September 27, 2017
Revised
215042 - Spotlight is blocking itself in the master database

Why is Spotlight blocking itself ?&nbsp;

Revised: September 19, 2017
115537 - SQL Activity SQL Queries are not displayed, just the error: /* SPID:0 does not exist. */ in Spotlight versions 9.5.2 and 10.1

When checking SPIDs, in v9.5.2 and v10.1,&nbsp;it's not possible to see&nbsp;any queries. Instead, the following message is shown: &nbsp;/* SPID...

Revised: September 29, 2017
117205 - Reports - An error occurred during local report processing

When drilling into a report such as Enterprise sql server performance report and Enterprise windows performance report and Enterprise windows...

Revised: September 29, 2017
91830 - Partitioned tables not showing in Database Tables list in Spotlight 8.0

Using Spotlight 8.0, partitioned tables are not showing in Spotlight&#39;s Database Details | Tables drilldown.

Revised: September 25, 2017
186941 - Cannot configure the Playback Database with a specific port number

When configuring the Playback database with a port number (e.g. SQL_Server_name,1400 or SQL_Server_name:1400) , the Diagnostic Server cannot...

Revised: September 29, 2017
113913 - Access violation at address 00815A7A in module 'Spotlight.exe' error in Spotlight version 9.5.2

Spotlight is left running 24/7. When it is maximized in the morning, the error shows...

Revised: September 29, 2017
96206 - In Spotlight 8.5, "Do not raise an alarm for certain values" only works for SPID/session id values

Using Spotlight 8.5, in &quot;Locks - Blocked Process&quot; alarm settings, other values entered other than SPID/session is ignored; hence, user...

Revised: September 25, 2017
78289 - SQL Server Alarm Action Failure alarm remains even though the SMTP Spotlight 7.6

In Spotlight 7.6, there is a problem with the SMTP server, Spotlight&nbsp;will not be able to&nbsp;send an email.&nbsp; It will&nbsp;then&nbsp...

Revised: September 25, 2017
80929 - Exception when going back to a custom Counter in spotlight at the default settings in Spotlight 8.0

Using Spotlight 8.0, after having created a custom counter in spotlight under default settings and unchecking this and clicking OK =&gt; then...

Revised: September 25, 2017
77832 - Disk Queue Length alarm showing very high value in Spotlight 8.0

Using Spotlight 8.0, the Disk Queue Length alarm is displaying a very high average queue length value which is beyond the normal range.

Revised: September 25, 2017
97650 - In Spotlight 8.5, the Custom Counter only triggers the alarm once.

Using Spotlight 8.5, I configured a Custom Counter and setup a custom alarm for my SQL Server connection but the custom alarm only fire once.

Revised: September 25, 2017
102684 - In Spotlight 9.0, Alarm acknowledgement and switching between connections / diagnostic servers cause Assertion failure

1. In Spotlight for SQL Server 9.0.1, whenever doing a combination of alarm acknowledgement and switching between connections, gives the following...

Revised: September 25, 2017
102850 - Spotlight 9.0 is showing DTC service as inactive when it's active

In Spotlight 9.0, when monitoring one of the clustered SQL 2005/SP4 servers, Spotlight detects DTC as inactive when it&#39;s online or active.

Revised: September 25, 2017
103335 - In Spotlight 8.5, failed SQL jobs end up with SQL hanging around in the PROCCACHE / PROCEDURE CACHE as adhoc SQL

Using Spotlight 8.5, Entries of&nbsp;SQL in the PROCCACHE/Procedure Cache&nbsp;is using 800Kb and has a usecount of 1 and the only thing that...

Revised: September 25, 2017
103729 - In Spotlight 9,0, alarms not generated for SQL Server Connection failure

Using Spotlight 9.0, SQL server connection failure occurred but the alarm was not raised for a few hours after the event

Revised: September 25, 2017
104155 - In Spotlight 9.2, no reporting of Processor Queue Length in Windows Keyed Metric report

Using Spotlight 9.2, when running the Windows Keyed Metric report,&nbsp;there is no reporting of the Processor Queue Length, even though the &ldquo...

Revised: September 25, 2017
104372 - In Spotlight 9.0 error: 'Invalid Floating Point Operation' message appears at random times

Using Spotlight 9.0, after adding a second connection, the error &#39;Invalid Floating Point Operation&#39; appears&nbsp;at random times, or when...

Revised: September 25, 2017
106333 - In Spotlight 9.2, ErrorLog count alarm shows more rows that are in the Error Log

Using Spotlight 9.2, the ErrorLogCount alarm shows a particular number of errors, but when you check in the Error Log in Spotlight, it shows 0 rows.

Revised: September 25, 2017
107839 - In Spotlight 9.0 and 10.0, error "Data File Group Space Used: Data file fixed space remaining could not be evaluated"

Using Spotlight 9.0 or 10.0, errors found: Databases - Data File Group Space Used: Data file fixed space remaining could not be...

Revised: September 25, 2017
107839 - In Spotlight 9.0 and 10.0, error "Data File Group Space Used: Data file fixed space remaining could not be evaluated"

Using Spotlight 9.0 or 10.0, errors found: Databases - Data File Group Space Used: Data file fixed space remaining could not be...

Revised: September 25, 2017
233029 - Selecting or extracting connection tag data

In Spotlight Enterprise, is there a way to select or extract connection tag data? Is the tag data stored on the database?

Revised: September 27, 2017
Top

Product Life Cycle

New

None at this time

Revised

None at this time

Top

Notifications

New

None at this time

Revised

None at this time