Spotlight on SQL Server Enterprise - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new in 12.1?
How to obtain the license number
What is Spotlight federation
Alarm action push notification
Configuration Templates How to
New Template Apply changes in Spotlight 11.7
Contact Us
Technical Support
View All Contacts

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2176
Spotlight not alerting on Always On Redo Queue issues. (235429)

Spotlight not alerting on Always On Redo Queue issues.. User had a process that was blocking our AlwaysOn replication to secondary server for hours. The availability group status was showing that everything was green in Spotlight. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/15/2017
(0 Ratings) 7 views
Error, "Collection 'SQLFragmentationByIndex' failed : The SQL query has timed out" (230424)

Receiving the following error in Spotlight: Error: Monitored Server - SQL Server Collection Execution Failure. Collection 'SQLFragmentationByIndex' failed : The SQL query has timed out. WORKAROUND: None. STATUS: A fix ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/15/2017
(1 Ratings) 398 views
After upgrade to Spotlight version 12.0, diagnosing any Index Fragmentation alarm shows no data in drilldown. (229936)

Diagnosing any Index Fragmentation alarm shows "No Data". This started happening as soon as user upgraded to 12.0. How to change default parameters used for this collection for all connections? Index Fragmentation collection ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/15/2017
(0 Ratings) 574 views
Error when trying to get detail of SQL queries: The invocation of the constructor on type ... (235385)

After upgrade when trying to get the detail of SQL queries and clicking on SQL Activity getting an error: Message: An unexpected problem has occurred while collecting data. Details: Datasource: arizona.company.local_sqlserver. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/15/2017
(0 Ratings) 7 views
Error, "Unable to start service. Error 1067: The process terminated unexpectedly" when upgrading Spotlight (234126)

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 service has not started, but when trying to start the Diagnostic Server service manually, the same error occurs. Corrupted Service. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/14/2017
(0 Ratings) 1 views
Error, Virtual Machine Usage failed VM "vm_name" does not exist, on vCenter Server Appliance (227224)

When adding Virtualization Details to a Windows connection properties and selecting the VM host and then selecting the VM from the drop-down list; after clicking "OK" to save the settings, Spotlight throws an error for this connection "Collection 'Virtual Machine Usage' failed ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/14/2017
(1 Ratings) 501 views
Two instances of Spotlight are connected to the database. (235181)

Why there are 2 Spotlight instances ("Monitor" and "Monitor 2") connected the database? Is it possible to switch one of them off? No, it is not possible to turn one off. Spotlight uses two sessions so that long-running or frequent SQL scripts do not prevent a timely collection of data. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/12/2017
(0 Ratings) 3 views
Improvement in Monitoring of Availability Groups in Spotlight (235146)

Add Log Send Queue, Recovery Queue and Transaction Delay information in replication. Enhancement request number SES-133 has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/12/2017
(0 Ratings) 2 views
Where to find online documentation for Spotlight on SQL Server Enterprise version 12.0 (230497)

Where to find online documentation for Spotlight on SQL Server Enterprise version 12.0? At URL: https://support.quest.com/ spotlight-on-sql-server-enterprise/12.0/documentation/General. It is possible to download only the exe file. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/12/2017
(0 Ratings) 202 views
Spotlight today is not expanding correctly (235235)

After upgrade to 12.1 Spotlight Today screen does not expand alarms correctly. WORKAROUND: NONE. STATUS. Waiting for fix in a future release of Spotlight on SQL Server Enterprise.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/11/2017
(0 Ratings) 12 views
After upgrade to 12.1 version performance health shows erroneous number (235234)

The Health Performance metrics appears with large number metric (wrong metrics value). This is causing all the monitoring framework marking as unhealthy.The value shows 10 or more digits percentage value WORKAROUND: NONE. STATUS. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/11/2017
(0 Ratings) 7 views
CPU usage wheel does not show anything until the user interacts with it (235202)

CPU usage wheel does not show anything until the user interacts with it. Issue fixed in version 12.1.0.9001. The latest version of Spotlight on SQL Server Enterprise can be downloaded at https://support.quest.com/spotlight- on-sql-server-enterprise/download-new-releases

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/8/2017
(0 Ratings) 5 views
Alarm Log showing message SQLServerXEventChannel (232490)

The Alarm Log is showing alarms with a SQLServerXEventChannel message. For example, Monitor Server - SQL Server Secondary Connection Failure (SQLServerXEventChannel). Issue fixed in version 12.1.0.9001. The latest ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/7/2017
(0 Ratings) 119 views
Seeing Replication - Subscription Expiration alarm warnings after installing version 12.1 (235151)

After upgrade to version 12.1 the following warning alarms appear: "The replication subscription [DBPROD2\DBREP].[Msiclaim] will expire in 6 hours". What do these alarms indicate? New alarm introduced in version 12.1 Spotlight ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/7/2017
(0 Ratings) 5 views
Heat Map does not show alerts in the correct order (235144)

In v12.1, the Heat Map shows alerts in an incorrect order. Upon opening it, it does display correctly, but if left open and as alarms come in for certain connections, the order of importance is not followed and connections with alerts can appear in any location in the Heat Map. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/7/2017
(0 Ratings) 12 views
Missing index fragmentation information error: "SQLFragmentationByIndex failed Error 50000" (235102)

User is getting error in index fragmentation information: "onitored Server - SQL Server Collection Execution Failure. Collection 'SQLFragmentation ByIndex' failed : Error 50000, Level 16, State 1, Procedure -, Line 185, Message: Error 448, Level 16, State 1, Procedure -, Line 16 ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/6/2017
(0 Ratings) 6 views
Spotlight crashes when selecting a Session from SQL Activity (235098)

There is the following error when you go to SQL Activity | Session tab, and then choose any session: Message: 'An unexpected problem has occurred while collecting data. It is recommended that you send a support bundle to Quest Software. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/6/2017
(0 Ratings) 10 views
Error viewing Deadlock details from the Home page: "An unexpected problem has occurred" (231288)

User diagnosing reported Deadlocks from Spotlight Home page. When Diagnose option is selected, Spotlight shows the following error: "An unexpected problem has occurred List index out of bounds (-1)". WORKAROUND: User the Show Details option: ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/5/2017
(0 Ratings) 144 views
CLR and Preemptive wait events drive low performance however CLR Wait Events show nothing (231330)

CLR and Preemptive wait events drive low performance and most of the wait is coming from Preemptive_XE_GETTARGETSTATE from Spotlight and CLR Wait Events show nothing. The CLR wait events are the culprit, it causes the instance to show low performance. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/4/2017
(0 Ratings) 197 views
Drill down for SPID on Long Running SQL alarm run time doesn't match Long Running SQL alarm e-mail run time value (230863)

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 actually been running for 1 hour, 51 minutes. WORKAROUND: None. STATUS: ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/4/2017
(0 Ratings) 196 views
Spotlight appears to be causing wait events and server slowdowns even though the system is not busy (231423)

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 Server is not busy at all. Poor Performance Health calculation uses percentages ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/4/2017
(0 Ratings) 338 views
CLR wait types are constantly causing SQL server to show poor performance. (213771)

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 monitor to correctly report on the performance health of the server. The ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/4/2017
(0 Ratings) 1036 views
The status and login user in Long Running SQL alarm are different from sessions drill down (230865)

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 drill down the corresponding session status was running and the SQL user column is not blank. WORKAROUND: None. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/4/2017
(0 Ratings) 204 views
Workload Analysis has a long loading delay and results in Error retrieving data: ClientConnectIssue: A task was canceled." (215051)

When clicking on Workload Analysis, there is long loading delay and something follow by the error "Error retrieving data: ClientConnectIssue: A task was canceled." The Diagnostic Server maybe out of memory. Adjust the SpotlightDiagnosticServer ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/4/2017
(0 Ratings) 782 views
Error, "Cannot connect to Availability Group '' : The High Availability connection address is invalid. It must be the Availability Listener address." (230273)

After upgrading to Spotlight 12.0, the following error occurs on all Availability Group connections where once it worked before the upgrade: Cannot connect to Availability Group ' ' : The High Availability connection address is invalid. It must be the Availability Listener address. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 12/4/2017
(0 Ratings) 338 views