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 11.7.1
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 2049
Is SQL Server 2017 supported in Spotlight? (229637)

Is SQL Server 2017 supported in Spotlight? We are looking into Supporting SQL Server 2017 and the requirements involved but we cannot provide an exact timing of when and what version of Spotlight it will be officially supported. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/22/2017
(0 Ratings) 1 views
How to change default appearance period for all graphs? (229507)

How to change the default appearances period for all the graphs, let's say, to 1 day? In Spotlight Client go to Configure | Spotlight; Under "Change Display" click on "Appearance of charts"; Select the best option for you in "Amount of history to display in charts" (up to 1 day).

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/22/2017
(0 Ratings) 4 views
The RPC server is unavailable. (Exception from HRESULT: 0x800706BA (55268)

In this case, the QDS is outside the DMZ, the monitored SQL Server is inside the DMZ. Status button in Spotlight Console shows: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA. There can be a few reasons for this error: ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/22/2017
(0 Ratings) 28 views
Using Quest Single Sign On account in Spotlight Essentials site. (229612)

What has changed with new notification on Quest Single Sign On account in Spotlight Essentials site. If using an individual email address that's currently used on Quest Support or Communities page, use this password on Spotlight Essentials site. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/19/2017
(0 Ratings) 7 views
Spotlight reporting Database alarm without database name: "Database is unavailable (Suspect, Offline, Recovering, etc)" (229565)

Spotlight reporting Database alarm without database name: "Database is unavailable (Suspect, Offline, Recovering, etc)". WORKAROUND: None. STATUS: Waiting for fix in future release of Spotlight on SQL Server Enterprise.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/18/2017
(0 Ratings) 6 views
Is there a SQL Server TCP Port Change Alarm? (229511)

Is there a way to determine if the TCP port has changed for SQL Server? Is there an alarm that exists in Spotlight? WORKAROUND: None. STATUS: An enhancement request has been created for consideration in a future release of Spotlight.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/17/2017
(0 Ratings) 4 views
Clicking on new connections gave "DOMAIN\User has insufficient privileges for this operation" (126829)

Clicking on newly added Windows 2012 connection gave the following error: "DOMAIN\User has insufficient privileges for this operation". Going to Disk drill down also causes Spotlight to throw the same error. The error log from ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/16/2017
(0 Ratings) 1570 views
An overview of how the Organizational accounts work in Spotlight Essentials (136266)

It appears that the uploading of data from Spotlight Enterprise to Spotlight Essentials has stopped after enabling the Add Organization feature in Spotlight Essentials. WHY: Many customers of Spotlight Essentials (SE) have requested ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/13/2017
(0 Ratings) 1091 views
Are there built in logic for backups & transaction logs alarms to fire base on recovery mode? (229408)

Are there built in logic for backups & transaction logs alarms to fire base on recovery mode? WORKAROUND: None. Spotlight does not have any back end logic to determine if the backup or transaction log alarms should be fired based on recovery mode. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/12/2017
(0 Ratings) 2 views
Spotlight Wait Events and Workload Analysis shows the batch SQL and individual SQL statement. (229405)

Since upgrading from 11.6 to 11.7 the Wait Events drilldown shows less statements and reported statements are different. The difference is that 11.7 is showing the SQL of the batch while the 11.6 is showing the SQL of the statement within the batch. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/12/2017
(0 Ratings) 3 views
Is Spotlight Home page customizable? (229404)

Is Spotlight Home page customizable? The display of Home page of Spotlight is not customizable. Spotlight alarms are customizable so the colors of alarms can change in Home page.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/12/2017
(0 Ratings) 4 views
VIDEO: In-depth Look at Home Page Screen in Spotlight (228917)

In-depth Look at Home Page Screen in Spotlight An In-depth Look at the Home Page Screen in Spotlight. Spotlight Help; Diagnose; Acknowledge; Snooze Alarm; Alarm Settings; Ignore this Alarm; What's this? Show History; Show Details. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/12/2017
(0 Ratings) 3 views
SQL Activity | Sessions drilldown shows a truncated SQL script in Playback mode (229322)

The SQL pane of SQL Activity | Sessions drilldown shows a truncated script in Playback mode. WORKAROUND: Use SQL Activity | Query Execution Statistics drilldown to locate SQL by part of script text or by Plan Handle. Plan ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/11/2017
(0 Ratings) 4 views
Top SQL Statement not showing up in playback (229327)

When in Playback mode, the Top SQL Statement doesn't display any data. Out of the box the "Top SQL Statements" schedule is disabled and hence it will only collect when you drill into. To enable background connection go ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/10/2017
(0 Ratings)
Spotlight Essentials Data Handling & Security (184654)

Spotlight Essentials Data Handling & Security Frequently asked questions about Spotlight Essentials Data Handling & Security: What data are we sending? Any user of various Quest Software products can opt-in to send system ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/9/2017
(0 Ratings) 721 views
How to interpret the Performance Health Rating (214914)

After migrating and upgrading Spotlight reporting a Performance Health Rating has changed. How this is scored and why the Performance Health Rating is now reported as a much lower value than before from unhealthy to healthy and how the ratings are assigned. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/8/2017
(0 Ratings) 167 views
Is it possible to search using multiple tags when creating custom views? (229224)

Is it possible to search using multiple tags when creating custom views? For example, with an environment of a 1,000 server located in California, Oregon, Maine and Florida. Each of the 1,000 servers has been tagged with the state in which it is located. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/8/2017
(0 Ratings) 1 views
How can multiple license keys be used to monitor multiple servers on the same console? (23045)

How can multiple license keys be used to monitor multiple servers on the same console? Please contact Quest Licensing at license@quest. com to have the keys merged into a single key that can connect to the number of servers for which you have been licensed. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/5/2017
(0 Ratings) 1416 views
Receiving WMI errors using non Administrator user monitoring Windows connections. (229151)

Spotlight Deployment Guide "How to configure WMI with minimum required user permissions" steps were performed on a non-Administrator user. Spotlight still shows WMI errors when monitoring Windows connections using this connection. See attachment. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/4/2017
(0 Ratings) 3 views
Deadlocks are not collected even if are manually produced in monitored instance (229090)

Deadlocks are not collected by Spotlight even if are manually produced in the monitored instance and other database management tools are able to record it. The cause is an unchecked checkbox "Alarm requires acknowledgement" for Locks - Deadlock alarm. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/4/2017
(0 Ratings) 3 views
Error retrieving data: The underlying connection was closed: An unexpected error occurred on a send (185420)

Performance Health. Error retrieving data: The underlying connection was closed: An unexpected error occurred on a send. Workload Analysis. Error retrieving data: The underlying connection was closed: An unexpected error occurred on a send. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/4/2017
(0 Ratings) 796 views
Error, "The login is from an untrusted domain and cannot be used with Windows authentication" (229081)

Cannot add servers on a different domain using windows authentication. Getting Error: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [0x80131904] The Spotlight tool connects ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/3/2017
(0 Ratings) 14 views
Wait Events drill down shows "SQL was not available" or "No SQL Statement" (189600)

Wait Events drill down shows "SQL was not available" either because the wait was of a type that is not associated directly with user activity or the Extended Events subsystem did not return a associated SQL statement. Spotlight ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/2/2017
(2 Ratings) 813 views
Is it possible to identify any SQL Server DBs that cannot have SA disabled? (228604)

Is it possible to pull data of all SQL Servers that cannot have SA disabled from Spotlight? Spotlight does not retrieve this kind of data from monitored instances and thus there is no way to generate a query to pull that kind of data. WORKAROUND: None. STATUS: ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 5/2/2017
(0 Ratings) 11 views
Where does Spotlight store alarms/schedules configuration for a connection? (228992)

When you edit the alarms/schedules configuration whether directly on each connection or through a template, where does Spotlight save those configurations? Spotlight writes the alarms/schedules configuration directly into the connection XML. ...

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