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
Notifications & Alerts
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 Us
Technical Support
View All Contacts

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2132
getting error when adding server in planned outage, "user cancelled" error after edit (233896)

When adding the server in planned outage and save it. getting an error - user canceled. After clicking OK removes the full planned outage which was added before. The reason is when user edit a planned outage, it will recreate ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/20/2017
(0 Ratings) 9 views
Error: SQL Server Secondary Connection Failure: Connection 'SQLServerXEventsChannel' failed to connect (233895)

Monitored Server - SQL Server Secondary Connection Failure: Connection 'SQLServerXEventsChannel' failed to connect: The event data stream was disconnected because there were too many outstanding events. To avoid ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/20/2017
(0 Ratings) 8 views
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 (233108)

Sometimes there is a performance problem when trying to load lots of data (long period, existing lots of SQL statement, etc) in workload analysis or wait event. The results can be: Spotlight client crash. Takes a very long time ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/19/2017
(0 Ratings) 62 views
Spotlight needs to offer a way to filter Database Unavailable Alarms (233809)

The Alarm needs to be filterable based on the reason. For example "OFFLINE", "RESTORING", "RECOVERING" ignore, but Fire the Alarm for other unavailable causes. Is there a way to do this? Setting up any Alarm Action Filter ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/18/2017
(0 Ratings) 4 views
Error 0x800706BA The RPC server is unavailable. (97739)

You may encounter the following error when connecting to a server in Spotlight: 'Error 0x800706BA: The RPC server is unavailable. Exception from HRESULT: 0x800706BA'. The Diagnostic Server is not able to establish a connection with the target computer. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/18/2017
(1 Ratings) 2711 views
Difference between Standard Edition or Enterprise Edition. (106047)

Are there and differences between Standard Edition or Enterprise Edition when using SOSSE? Spotlight on SQL Server Standard edition is no longer supported and maintained product. In version 9 Standard and Enterprise ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/18/2017
(0 Ratings) 9 views
Performance Health incorrectly calculates when monitoring an AlwaysOn enivronment (228164)

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 no other task than waiting for events from the primary node, it appears ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/17/2017
(1 Ratings) 153 views
After upgrade to 12.0.1 acknowledging alarm crashes the Spotlight client (233553)

After upgrade to 12.0.1 acknowledging alarm crashes the Spotlight client Introducing help on line in 12.0.0, we used embedded web browser, which caused a crash when clicking on alarm in some un-patched Windows 10 versions, but this is fixed in the 12.0.1 When launching ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/11/2017
(0 Ratings) 34 views
Does Spotlight support SQL 2017 (233448)

When SQL 2017 will be fully supported in Spotlight ? Spotlight on SQL Server version 12.2 will be supporting MS SQL Server 2017.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/9/2017
(0 Ratings) 43 views
How does Spotlight handle SQL Server VMs when moved to other ESX hosts using vMotion? (233411)

How does Spotlight handle SQL Server VMs that move from other ESX hosts from vMotion when monitoring? vMotion moves the VM without interfering with network connections to the VM, this will be transparent on the Spotlight side. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/5/2017
(0 Ratings) 6 views
Database screen doesn't load data in v11 for SQL Server 2008 and shows incorrect syntax error (142077)

When opening the 'Databases' screen in v11, no data is loaded and the following errors are shown: 'Collection 'Database List' failed : Collection 'Files' failed : Error 102, Level 15, State 1, Procedure -, Line 8, Message: Incorrect syntax near ')'. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/4/2017
(3 Ratings) 1948 views
Planned outage not working correctly and sends alarms/emails once the outage window has ended. (233375)

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 as soon as the outage window is over it sends alarm e-mails about all the ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/4/2017
(0 Ratings) 1 views
Can't run Spotlight for SQL Server report. (233226)

I have someone who's user account is a member of the diagnostic server local group "Spotlight Diagnostic Users". They are trying to view reports. When they get prompted for an account (they are using their domain account) for the SpotlightStatisticsRepository the login fails. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/4/2017
(0 Ratings) 2 views
Fragmented Indexes show table owner of table rather than the schema name. (134029)

Fragmented Indexes drill down shows the table owner as a user in the database, rather than the schema in which the table resides. User has a scenario in which the table is owned by a schema that has no corresponding user in the database. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/4/2017
(0 Ratings) 1337 views
Databases drilldown shows incorrect database sizes for databases with Filestream feature. (135712)

Databases drilldown shows incorrect database sizes for databases with Filestream feature. Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/4/2017
(1 Ratings) 1200 views
Very frequent random access violations in v10.0.2 (134080)

Getting random access violation crashed in Spotlight 10.0.2 but clicking on an SQL Server connection might create the same issue. Message: An unexpected problem has occurred. It is recommended that you send a support bundle to Product.Company. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/4/2017
(0 Ratings) 1231 views
After upgrade Error Log alarm entries repeat every five minutes on SQL Server 2000 connections. (133479)

After upgrade to 10.5.2 Error Log alarm entries repeat every five minutes on SQL Server 2000 connections. There are no changes to error log file. WORKAROUND: Perform below steps to apply patch: 1. Login to Diagnostic ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/3/2017
(0 Ratings) 1603 views
Right-click | Diagnose for Deadlock does not shows last occurrence of deadlock (128233)

Assuming dead lock occurs at 9:00. At 9:02, If clicking on Status (or Blocked Processes) and doing a Right-Click Diagnose on "Locks - Deadlock alarm", it shows no data. Even though scrolling back to 9:00 from the Playback feature would show data. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/3/2017
(0 Ratings) 1318 views
Rewind in playback for SQL Activity gave "List index out of bounds" (133235)

In SQL Activity, after going to playback on a specific date, clicking on rewind a few times and results in the error. An unexpected problem has occurred. It is recommended that you send a support bundle to Quest Software. Click ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/3/2017
(0 Ratings) 1297 views
Error "Arithmetic overflow error converting float to data type numeric" for Database values (130239)

The following error occurs when attempting to look at Database details from Spotlight SQL Server home page: Messages Component: Fragmented Indexes The following error occurred while collecting data Error 50000, Level ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/3/2017
(0 Ratings) 2598 views
High Availability home page falsely reporting an unhealthy synchronization. (127992)

High Availability home page falsely reporting an unhealthy synchronization. WORKAROUND: None. STATUS: Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here. .

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/3/2017
(0 Ratings) 1406 views
Error in value field of Custom Counters: "An item with the same key has already been added" (128041)

After upgrade to version 10.5 Custom Counter values shows below error: "An item with the same key has already been added.". These Custom Counters worked in 10.0.2 and previous versions. Query used in Custom Counter ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/3/2017
(0 Ratings) 1351 views
Availability Group Failed Over alarm not raised when AG failover occurs. (127991)

Availability Group Failed Over alarm not raised when AG failover occurs. WORKAROUND: None. STATUS: Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here. .

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/3/2017
(0 Ratings) 1298 views
Error connecting to Windows: "Target Address must contain a machine name or IP address". (128225)

When setting up a new Spotlight on SQL Server Enterprise 10.5 and adding new servers by IP addresses, the following error message is thrown: "Target Address must contain a machine name or IP address". not=now*. There ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/3/2017
(0 Ratings) 2542 views
Cannot configure a custom counter for only one connection (123192)

In 'Configure | Custom Counters', for a specific connection a custom counter cannot be set up. When choosing a specific connection, the 'Add', 'Edit', and 'Remove' button is grayed out. Custom counters can only be setup in Default ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 10/2/2017
(0 Ratings) 1206 views