What's new for Spotlight on SQL Server Enterprise

December 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
235385 - Error when trying to get detail of SQL queries: The invocation of the constructor on type .

After upgrade when trying to get the detail of SQL queries and clicking on SQL Activity getting an error: Message: An unexpected problem has...

Created: December 14, 2017
235202 - CPU usage wheel does not show anything until the user interacts with it

CPU usage wheel does not show anything until the user interacts with it.

Created: December 8, 2017
234989 - How to upgrade Spotlight in a Federated Deployment

What are the best practices to upgrade Federation in Spotlight?

Created: December 1, 2017
235151 - Seeing Replication - Subscription Expiration alarm warnings after installing version 12.1

After upgrade to version 12.1, the following warning alarms appear: "The replication subscription [DBPROD2\DBREP].[Msiclaim] will expire in 6...

Created: December 7, 2017
235385 - Error when trying to get detail of SQL queries: The invocation of the constructor on type ...

After upgrade when trying to get the detail of SQL queries and clicking on SQL Activity getting an error: Message: An unexpected problem has...

Created: December 14, 2017
235102 - Missing index fragmentation information error: "SQLFragmentationByIndex failed Error 50000"

User is getting error in index fragmentation information: "onitored Server - SQL Server Collection Execution Failure Collection &#39...

Created: December 6, 2017
235151 - Seeing Replication - Subscription Expiration alarm warnings after installing version 12.1

After upgrade to version 12.1 the following warning alarms appear: "The replication subscription [DBPROD2\DBREP].[Msiclaim] will expire in 6...

Created: December 7, 2017
235234 - Spotlight performance health shows an exaggerated number in Windows foreign language settings.

Spotlight performance health shows an exaggerated number in Windows foreign language settings.The value shows 10 or more digits percentage value...

Created: December 11, 2017
235235 - Spotlight today is not expanding correctly

After upgrade to 12.1  Spotlight Today screen does not expand alarms correctly.

Created: December 11, 2017
235385 - Error when trying to get detail of SQL queries: The invocation of the constructor on type .

After upgrade when trying to get the detail of SQL queries and clicking on SQL Activity getting an error: Message: An unexpected problem has...

Created: December 14, 2017
235234 - Spotlight performance health shows an exaggerated number in Windows foreign language settings.

Spotlight performance health shows an exaggerated number in Windows foreign language settings.The value shows 10 or more digits percentage value...

Created: December 11, 2017
235151 - Seeing Replication - Subscription Expiration alarm warnings after installing version 12.1

After upgrade to version 12.1, the following warning alarms appear: "The replication subscription [DBPROD2\DBREP].[Msiclaim] will expire in 6...

Created: December 7, 2017
234993 - No data on Network/TCPIP in Playback mode

When running a playback on the Network counter on monitored hosts, the TCPIP tab on the Network monitoring counter is coming up with No data.

Created: December 1, 2017
235151 - Seeing Replication - Subscription Expiration alarm warnings after installing version 12.1

After upgrade to version 12.1, the following warning alarms appear: "The replication subscription [DBPROD2\DBREP].[Msiclaim] will expire in 6...

Created: December 7, 2017
235234 - After upgrade to 12.1 version performance health shows erroneous number

The Health Performance metrics appears with large number metric (wrong metrics value). This is causing all the monitoring framework marking as...

Created: December 11, 2017
235235 - Spotlight today is not expanding correctly

After upgrade to 12.1  Spotlight Today screen does not expand alarms correctly.

Created: December 11, 2017
Revised
213771 - CLR wait types are constantly causing SQL server to show poor performance.

CLR wait types are constantly causing my SQL server to show poor performance. These waits can be ignored safely. How to fix the performance health...

Revised: December 4, 2017
228825 - Workload Analysis very slow to load and refresh screen for a specific connection.

Workload Analysis very slow to load and refresh screen for a specific connection. This is a high activity production server.

Revised: December 1, 2017
229322 - SQL Activity | Sessions drilldown shows a truncated SQL script in Playback mode

The SQL pane of SQL Activity | Sessions drilldown shows a truncated script in Playback mode.

Revised: December 1, 2017
215051 - Workload Analysis has a long loading delay and results in Error retrieving data: ClientConnectIssue: A task was canceled."

When clicking on Workload Analysis, there is long loading delay and something follow by the error "Error retrieving data: ClientConnectIssue: A...

Revised: December 4, 2017
225693 - Wait Event drilldown wait types table and SQL text size is inconsistent and SQL text overflowing the text frame

In the Wait types drill down, the column width is different for each wait types, yielding inconsistent layout and for some tables increasing the...

Revised: December 4, 2017
230273 - Error, "Cannot connect to Availability Group '<Availability_Listener_Name>' : The High Availability connection address is invalid. It must be the Availability Listener address."

After upgrading to Spotlight 12.0, the following error occurs on all Availability Group connections where once it worked before the upgrade...

Revised: December 4, 2017
230424 - Error, "Collection 'SQLFragmentationByIndex' failed : The SQL query has timed out"

Receiving the following error in Spotlight: Error: Monitored Server - SQL Server Collection Execution Failure Collection...

Revised: December 4, 2017
230863 - Drill down for SPID on Long Running SQL alarm run time doesn't match Long Running SQL alarm e-mail run time value

Received a Long Running SQL alarm e-mail indicating the SQL has been running for 6 minutes, but when drilling down to the same SPID the SQL has...

Revised: December 4, 2017
230865 - The status and login user in Long Running SQL alarm are different from sessions drill down

After receiving a Long Running SQL alarm email from Spotlight, it indicated the status was suspended and Login Name was blank while in the sessions...

Revised: December 4, 2017
231330 - CLR and Preemptive wait events drive low performance however CLR Wait Events show nothing

CLR and Preemptive wait events drive low performance and most of the wait is coming from Preemptive_XE_GETTARGETSTATE from Spotlight and CLR Wait...

Revised: December 4, 2017
231423 - Spotlight appears to be causing wait events and server slowdowns even though the system is not busy

Spotlight seems to bring down the performance health by itself where it shows Spotlight causing CLR wait events and slow downs, but the actual SQL...

Revised: December 4, 2017
228164 - Performance Health incorrectly calculates when monitoring an AlwaysOn enivronment

The Performance Health Monitor claims a secondary node is unhealthy because of the wait time for AlwaysOn or MISC events. As the secondary node has...

Revised: December 1, 2017
228825 - Workload Analysis very slow to load and refresh screen for a specific connection.

Workload Analysis very slow to load and refresh screen for a specific connection. This is a high activity production server.

Revised: December 1, 2017
232490 - Alarm Log showing message SQLServerXEventChannel

The Alarm Log is showing alarms with a&nbsp;SQLServerXEventChannel message. For example, Monitor Server - SQL Server Secondary Connection Failure...

Revised: December 7, 2017
235146 - Improvement in Monitoring of Availability Groups in Spotlight

Add Log Send Queue, Recovery Queue and Transaction Delay information in replication.

Revised: December 12, 2017
227224 - Error, Virtual Machine Usage failed VM "vm_name" does not exist, on vCenter Server Appliance

When adding Virtualization Details to a Windows connection properties and selecting the VM host and then selecting the VM from the drop-down list...

Revised: December 14, 2017
235181 - Two instances of Spotlight are connected to the database.

Why there are 2 Spotlight instances (&quot;Monitor&quot; and &quot;Monitor 2&quot;) connected the database?&nbsp; Is it possible to switch one of...

Revised: December 12, 2017
234126 - Error, "Unable to start service. Error 1067: The process terminated unexpectedly" when upgrading Spotlight

Trying to upgrade from 11.7 to 12.0.1 and getting an error: Unable to start service. Error 1067: The process terminated unexpectedly. Noticing the...

Revised: December 14, 2017
148518 - Diagnostic server causing PREEMPTIVE_OS_DEVICEOPS waits

Many instances are reporting that the spotlight diagnostic server (monitoring) is causing PREEMPTIVE_OS_DEVICEOPS waits.&nbsp;

Revised: December 1, 2017
230068 - After upgrade to version 12.0, Spotlight is raising Long Running SQL alarm reported from Diagnostic Server.

After upgrade to version 12.0, Spotlight is raising Long Running SQL alarm reported from Diagnostic Server on production monitored servers: &quot...

Revised: December 1, 2017
233375 - Planned outage not working correctly and sends alarms/emails once the outage window has ended.

Monthly we do maintenance on all our servers. We do a planned outage in Spotlight for the time frame. Everything is silenced during the outage, but...

Revised: December 1, 2017
230497 - Where to find online documentation for Spotlight on SQL Server Enterprise version 12.0

Where to find online documentation for Spotlight on SQL Server Enterprise version 12.0? At URL: https://support.quest.com/spotlight-on-sql...

Revised: December 12, 2017
234883 - Fetching of data to workload analysis causes a crash of application.

While fetching data, spotlight crashes, user tries to repeat but the problem reoccurs.

Revised: December 1, 2017
234248 - Index fragmentation graphical image for Median Fragmentation no longer present on Version 12.

After upgrading from SoSSE 11 to 12.0.1,on the SQL Server Overview page that the graphical image for Median Fragmentation and Maximum...

Revised: December 4, 2017
229565 - Spotlight reporting Database alarm without database name: "Database is unavailable (Suspect, Offline, Recovering, etc)"

Spotlight reporting Database alarm without database name: &quot;Database &nbsp;is unavailable (Suspect, Offline, Recovering, etc)&quot;

Revised: December 1, 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