Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.

Spotlight on SQL Server Enterprise - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new in 12.0.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 Support
Contact Support

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2140
Check when and who made changes in Spotlight (232238)

Where is the audit file or log in version 12.x ? It has been moved to playback database, it can be viewed by generating an audit report from Spotlight client.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/21/2017
(0 Ratings) 1 views
Spotlight service is not starting after upgrade to 12.0 (232151)

catastrophic error occurred failed to initialise Diagnostic Server runtime environment: Failed to load existing StateRepository data : Failed to load existing StateRepository data :java.io. EOFException. Delete the directory {DS ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/17/2017
(0 Ratings) 6 views
Spotlight Client keeps on crashing, sometimes constantly. (231960)

Click on Databases it has 2 alarms. One for a database that is online and one for high index fragmentation. The offline database alarm is the one highlighted and when trying to switch to the index alarm the client crashes, every time. Reinstall the Spotlight Client.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/16/2017
(0 Ratings) 4 views
Access violation at address 00B66A09 in module 'Spotlight.exe'. Read of address 00000000 (232063)

Access violation error occurred when trying to apply the license. Reinstall Spotlight for SQL Server Enterprise.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/16/2017
(0 Ratings) 4 views
How to monitor SSIS & SSRS on server without database engine. (231653)

How to monitor SSIS and SSRS when these services are installed on the server where the database engine is not installed? Use Windows connection instead of SQL Server connection and do the following: 1. Set the SSIS and ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/16/2017
(0 Ratings) 1 views
Ignoring any alarm does not work following upgrade to 12.0 (230731)

After upgrading from and older version to version 12.0 of Spotlight Enterprise, ignoring alarms does not clear them. This applies to any alarm, and used to work in older versions. This issue is caused by a product defect with version 12.0. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/16/2017
(1 Ratings) 116 views
Receiving "A full backup has never been taken for database" for some mirrored databases after upgrading to 12.0 even though the backups are fine. (230543)

Receiving "A full backup has never been taken for database" for some mirrored databases after upgrading to 12.0 even though the backups are fine. The alarms are on the primary databases. This is a bug as the primary databases have a full backup. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/16/2017
(0 Ratings) 135 views
Availability Groups - Days since last backup alert (106461)

Managing the alerts with a database in a SQL Server 2012 Availability Group... on the secondary replica, the "Days since last backup" alert goes on even though backups are occurring on the primary database. Full backup on the Primary is taken every day. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/16/2017
(1 Ratings) 2030 views
Can playback be shared in a Federation? (232107)

When setting up a Federation can the playback database be shared between the Diagnostic Servers in the Federation. Each Diagnostic Server that you set up will need to have its own Playback database. You cannot share ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/15/2017
(0 Ratings) 17 views
Unable to use Office 365 Exchange Account (232084)

User attempting to use an Office 365 Exchange account, user is receiving error. "Sending Email Failed: 530 5.7.57 SMTP; Client was not authenticated to send anonymous mail during MAIL FROM (Outlook exchange servers here). ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/15/2017
(0 Ratings) 17 views
Spotlight is generating Playback data faster than the database can store it. (46479)

When connecting with Spotlight you may see the following message: There is a Playback performance issue with the instance. Spotlight is generating Playback data faster than the database can store it. Playback data is being lost. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/14/2017
(0 Ratings) 1463 views
Monitoring a SQL Server 2012 AlwaysOn Cluster with High Availability (125704)

The High Availability Home Page is very different compared to SQL Server Home Page. Which connection (High Availability or SQL Server) should I use to monitor a 3 node SQL Server 2012 AlwaysOn Cluster? If we use the ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/11/2017
(0 Ratings) 3209 views
After upgrade to 12, alert "SQL server secondary connection failure" (232016)

Alert: "SQL server secondary connection failure". After upgrade to 12.0.1: Severity Alarm Message Raised ... High Monitored Server - SQL Server Secondary Connection Failure Connection 'SQLServer Auxiliary Channel' failed ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/11/2017
(0 Ratings) 1 views
How to determine what connections are tied to an alarm template? (231941)

User has 20 custom alarm templates and 300 connections, and would like to export data to show what connections belong to what template. WORKAROUND: None. STATUS: Enhancement request SES-80 has been submitted ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/8/2017
(0 Ratings) 4 views
Can't Uninstall Spotlight (231129)

Can't uninstall Spotlight. Corrupted registry keys on 64-bit operating systems; Corrupted registry keys that control the update data; Problems that prevent new programs from being installed; Problems that prevent existing programs ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/7/2017
(0 Ratings) 89 views
After upgrade to version 12.0, Spotlight reports incorrect SQL Agent Jobs Failed alarm. (229989)

Spotlight 12.0 is ignored the jobs excluded from SQL Agent Jobs Failed alarm and still raises an alarm for these jobs. WORKAROUND: 1. From Configure tab on top of your screen click Alarm Actions option. 2. Click New and ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/4/2017
(0 Ratings) 150 views
After upgrade to version 12.0, continuous errors: "Monitored Server - SQL Server Connection Failure or SQL Server Secondary Connection Failure: Connection SQLServerXEventsChannel failed to connect" (229980)

After upgrade to version 12.0, user receiving continuous alert errors on several connections: "Monitored Server - SQL Server Secondary Connection Failure: Connection 'SQLServerXEventsChannel' failed to connect: The event ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/4/2017
(2 Ratings) 385 views
Error clicking a database name in Monitor | High availability | Transaction Log Shipping: "Invalid column name (secondary_server) in table (LogShippingPrimariesSecondaries)" (231399)

The following error appears when clicking on a database name in Monitor | High availability | Transaction Log Shipping: "Invalid column name ("secondary_server") in table ("LogShipping PrimariesSecondaries")". Issue fixed ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/2/2017
(0 Ratings) 38 views
SQL Activity Sessions refresh new data too quick to view plans/ queries and playback doesn't have the query stored (231803)

When viewing SQL Activity | Sessions, it refreshes new data too quick so you can't review the plans and queries adequately. Also when trying to go to playback to find the query, it isn't readily available. Enhancement request ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/2/2017
(0 Ratings) 14 views
Spotlight experiencing higher CPU after upgrading to version 12. (230630)

Spotlight Diagnostic Server is experiencing higher CPU after upgrading to version 12. Some end user running the Spotlight Client are experiencing slowness and the application crashes from time to time. WORKAROUND: None. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/1/2017
(0 Ratings) 79 views
Spotlight fails to alert an email on failed SQL Server Agent jobs (231726)

Spotlight is not detecting failed jobs. A simple email alert fails on failed SQL Server Agent Jobs. WORKAROUND: Please open a service request and a Support Engineer can assist to resolve the issue. STATUS: Waiting for fix ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/1/2017
(0 Ratings) 5 views
SQL trace getting enabled and stopped by spotlight very frequently (231727)

In the SQL Server Error Log, entries “SQL Trace was started” and “SQL Trace was stopped.” repeat every 10 minutes while Spotlight is monitoring the connection. These entries are added by Microsoft; Spotlight Enterprise uses SQL Trace to monitor for deadlocks. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 8/1/2017
(0 Ratings) 6 views
As a user I want a control to set the Session details auto update or not (231725)

Spotlight End Users would like to request that in the Sessions tab you consider a filter on Status. Most customers usually only care to see the runable SPID'S. Also, customers would like a “Freeze” or “Pause” feature at the client ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 7/31/2017
(0 Ratings) 6 views
Security Notification - Unapproved File (230205)

When Bit 9 Security Platform has blocked an attempt by qkt.exe to run tmp7793.tmp which an executable used the Diagnostic Server, you will see the following pop up window with a security notification of: "Bit 9 Security Platform ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 7/31/2017
(0 Ratings) 9 views
Issues creating new VMware instance in monitoring (231721)

Upgraded to 11.71 and new vm's that are created are not being able to get monitored by Spotlight. No server shows up in the VM name under Connection Manager. Click Create then it says, "The vm is already created". WORKAROUND ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 7/31/2017
(0 Ratings) 8 views