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
Spotlight Essentials Status
What's new in version 12.2?
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

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2241
Enhancements of Windows Hardware Configuration report to show more details about CPU and number of cores. (259011)

The following enhancements are requested for the Windows Hardware Configuration report: 1. Add the number of cores per CPU. 2. Allow users to select more than one server at a time for the report. 3. Add a CPU only report ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/20/2018
(0 Ratings) 5 views
The Deadlock List Report is truncating Deadlock XML data at the end. (259003)

The Deadlock List Report is truncating Deadlock XML data at the end. WORKAROUND: 1. In Spotlight, select Configure | Diagnostic Server icon from top of screen. 2. Select Spotlight Statistic Repository database option. 3. Take a note of the instance and database name here. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/20/2018
(0 Ratings) 6 views
Various alarm errors containing message: "HTTP request to http://127.0.0.1:3166/CommandInBody Failed : An existing connection was forcibly closed by remote host. and it is paging us at all hours of the day now." (230761)

Various alarm errors containing the following message: SeverityAlarmMessageRaisedCleared. HighDatabases - Dynamic Data File Group Growths RemainingData file growths remaining could not be evaluated because Collection ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/19/2018
(1 Ratings) 718 views
No data display in SQL Agent Jobs drill-down (258837)

After upgrading Spotlight for SQL server to 12.2 a list of "SQL Agent Jobs" under support services is no longer available. There is no history displayed and SQL Agent Jobs show "No data" on the menu. WORKAROUND: Create ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/19/2018
(0 Ratings) 4 views
How to configure Spotlight to increase number of retries and timeouts when trying to connect to monitored host? (258801)

How to configure Spotlight to increase number of retries and timeouts when trying to connect to monitored host? This is to avoid number of false Monitored Server - SQL Server Connection Failure alarms. WORKAROUND: None. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/18/2018
(0 Ratings) 8 views
Monitor Spotlight connections in SCOM (149433)

SCOM views of Spotlight. Start the SCOM application. Expand Monitoring | Spotlight on SQL Server Enterprise. Select from the available views. The dashboard will show the Spotlight Diagnostic Servers known to SCOM, the ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/18/2018
(0 Ratings) 3445 views
How does Performance Health determines SQL Server health score as healthy or unhealthy? (255434)

How does Performance Health determines SQL Server health score as healthy or unhealthy? The attached white paper "Spotlight SQL Server Performance Health Calculation.docx" addresses the basis of Performance Health ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/15/2018
(0 Ratings) 3 views
What is the difference between Spotlight license unit of measure "Monitor Instance" vs. "Server"? (258583)

What is the difference between Spotlight license unit of measure "Monitor Instance" vs. "Server"? License key with "Server" as a unit of measure means that if the magnitude is for 1 Server and that Windows server has 3 SQL ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/13/2018
(0 Ratings) 4 views
Moving Spotlight on SQL Server Enterprise to a new server (121097)

How do you move Spotlight on SQL Server Enterprise to a new host sever? The steps to move Spotlight to a new host can be downloaded in the accompanying white paper, Spotlight_SS _Enterprise_Migration_Upgrade_Revise3.docx.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/13/2018
(2 Ratings) 6045 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: 6/13/2018
(0 Ratings) 874 views
VIDEO: How to see a historical view of alarms in Spotlight? (228370)

How to see a historical view of alarms in Spotlight? Spotlight Alarms Display Screens show different representation of Spotlight alarm historically or for a specific duration of time. These screens are: Heat Map; Spotlight Today; Alarms by Time; Alarm Log. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/13/2018
(0 Ratings) 716 views
VIDEO: How to create and configure Custom Views and Tags (227960)

How to create and configure Custom Views and tags in Spotlight on SQL Server Enterprise? Custom Views are used to filter connections in several Spotlight displays: Heat map, Spotlight today, Alarms by time or Alarm log. Tags ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/13/2018
(0 Ratings) 1003 views
VIDEO: How to create connections in Spotlight (228191)

How to create connections in Spotlight ? What are the steps? Steps: 1. Open Spotlight 2. Click on "Connections" in upper left corner while on "Configure" tab 3. Double click "Add New Connection" 4. Select connection you want ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/13/2018
(0 Ratings) 743 views
Video - Alarm Action setup overview (212485)

How do you setup an Alarm Action? This video in this KB article will give a general overview on setting up an Alarm Action. The example given here is to set action to fire off an email but for specific details on other conditions ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/12/2018
(0 Ratings) 1262 views
VIDEO - How to create and configure custom alarms in Spotlight? (200455)

How to create and configure custom alarms in Spotlight? Spotlight allows to create custom counter alarms from Configure | Custom Counters option. Custom counters use custom SQL Server or Windows queries to monitor and ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/12/2018
(0 Ratings) 1784 views
VIDEO - What is the upgrade process of Spotlight on SQL Server Enterprise? (204563)

What is the upgrade process (upgrading) of Spotlight on SQL Server Enterprise? As of Spotlight on SQL Server Enterprise 11.6, Spotlight allows to upgrade from any version to the latest version as long as current Spotlight version 10.0. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/12/2018
(1 Ratings) 3609 views
Need to disable TLS 1.0 on the Diagnostic Server (258400)

To comply with PCI regulations, TLS 1.0 needs to be disabled on the Spotlight server. It has been disabled, yet the server is still accepting TLS 1.0 connections over port 40403. How to turn it off ? .net framework does not use ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/12/2018
(0 Ratings) 5 views
Databases drilldown shows incorrect database sizes for databases with Filestream feature. (135712)

Databases drilldown shows incorrect database sizes for databases with Filestream feature. WORKAROUND: None. STATUS: Waiting for fix in a future release of Spotlight on SQL Server Enterprise. This issue previously occurred ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/12/2018
(1 Ratings) 1355 views
SQL Server Job report does not show any data (258339)

SQL Server Job report does not show any data. WORKAROUND: Copy the attached RDL to the Spotlight client installation folder and overwrite the existing file: C:\Program Files (x86)\Quest Software\Spotlight on SQL Server\Plug-ins\Trending\Reports\. STATUS: ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/11/2018
(0 Ratings) 8 views
How to generate log file for Spotlight cloud connection issue. (258336)

If there is Spotlight cloud connection issue, how to generate log file for Spotlight cloud connection issue. Spotlight cloud has built-in executable file to generate log file to check. connection issue. File locate at C:\Program Files ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/11/2018
(0 Ratings) 3 views
VIDEO - How to Install Spotlight on SQL Server Enterprise (177236)

Video: How to Install Spotlight on SQL Server Enterprise. How to Install Spotlight on SQL Server Enterprise. A General transcript of the video: These documents can be found on our support portal, or on the opening page of the Spotlight on SQL Server Enterprise installation. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/11/2018
(1 Ratings) 2998 views
Spotlight shows a different run time of jobs compared to in SQL Server Management Studio, when Diagnostic Server is in a different timezone (258176)

If the Diagnostic Server is located in a different time zone to the Spotlight client (v12.2), Spotlight shows a different run time of jobs compared to in SQL Server Management Studio (SSMS) on the same machine. WORKAROUND: None. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/8/2018
(0 Ratings) 8 views
Removing custom severity in an alarm gave unexpected error (232246)

Removing custom severity in an alarm gives an unexpected error. Message: An unexpected problem has occurred. It is recommended that you send a support bundle to Quest Software. Click "Show details..." for more information about the problem. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/6/2018
(0 Ratings) 161 views
How to obtain historical data regarding CPU utilization by SQL Server over time? (257674)

How to obtain historical data regarding CPU utilization by SQL Server over time? Use SQL Server Performance Summary report. The "Avg CPU%" column is the CPU usage of SQL Server.

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/5/2018
(0 Ratings) 4 views
Error, "Stopping Diagnostic Server. catastrophic error occurred. Attempt to load duplicate configuration for Monitored_entity " (257436)

When attempting to restart the Diagnostic Server service, it will throw the following error and then will not start: Stopping Diagnostic Server. a catastrophic error occurred. Attempt to load duplicate configuration for Monitored_entity <con_name>. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/1/2018
(0 Ratings) 3 views