Statistica is now part of TIBCO. Beginning June 5th, Statistica customers will need to use TIBCO Support's customer portal, to receive assistance with Statistica.

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
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 2094
SQL Long Running SQL alarm reports wrong elapsed time for parallel thread sessions. (230755)

SQL Long Running SQL alarm reports wrong elapsed time for parallel thread sessions. Spotlight appears to combine elapsed time of all threads and report that in the alarm of SQL of one thread. WORKAROUND: None. STATUS ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/23/2017
(0 Ratings) 12 views
Various alarm errors after upgrade to 12.0 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 after upgrade to 12.0 containing the following message: SeverityAlarmMessageRaisedCleared. HighDatabases - Dynamic Data File Group Growths RemainingData file growths remaining could not be evaluated ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/23/2017
(0 Ratings) 26 views
Spotlight Reports with graphs have the date as Day Month Year, an non-American standard (230690)

Graphs in the Spotlight Reports have the dates as Day-Month- Year. WORKAROUND. To fix the format issue with the report contents rather than the start data and end data of the selector, replace the file {client installation}\Spotlight ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/23/2017
(0 Ratings) 3 views
Enterprise reports in Spotlight 11.7.1 giving error "A data source instance has not been supplied for the data source Enterprise" (227192)

All of the Enterprise reports (eg Enterprise SQL Server Inventory) in 11.7.1 are throwing the following error: "A data source instance has not been supplied for the data source Enterprise...". All of the Enterprise reports (like Enterprise ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/22/2017
(0 Ratings) 2 views
How to configure Auto Update if you connecting to network by proxy. (226724)

How to configure Auto Update if you connecting to network by proxy. The Diagnostic Server supports setting the proxy via the SpotlightDiagnosticServer. ini. a. From the Diagnostic Server host with the issue, go to "C:\Program ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/22/2017
(0 Ratings) 3 views
User defined alarm severity threshold cannot be deleted (196235)

Some alarm like Custom Counter allows you to create a custom severity of normal high or low but once that severity is created, it cannot be delete. WORKAROUND: None. STATUS: Enhancement request has been submitted ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/22/2017
(0 Ratings) 2 views
How to manually delete the data in the Playback Database? (225078)

How to manually delete the data in the Playback Database? The following script can be ran against your Playback Database to remove data older that 14 days. The change the days to delete, change the -14 value. use [SpotlightPlaybackDatabase ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/22/2017
(0 Ratings) 4 views
How can you disable alerts that are not high severity? (205087)

How can you disable alerts that are not high severity? You can create and Alarm Action for all monitor instances to suppress all alarms that are not high. Go to "Configure | Alarm Actions" to create it. Use the action call "Suppress the alarm."

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/22/2017
(0 Ratings) 3 views
Installing the Spotlight 12.0 client from the exe installer gave an error message about no support for 32-Bit OS (230716)

When trying to install the Spotlight Client using the exe installer on a 32-bit OS gave the error: "The installer does not support 32-bit operating system.". Spotlight exe installer will not longer support installing the Spotlight Client on 32-bit OS. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/22/2017
(0 Ratings) 6 views
Deadlock alarm does not show details of victim SPID in Deadlocks drilldown when diagnosing this alarm. (189176)

Deadlock alarm does not show details of victim SPID in Deadlocks drilldown when diagnosing this alarm. This issue did not occur in 11.2 version of Spotlight. WORKAROUND: Use Alarm Log screen to locate Deadlock alarm and right-click on alarm to choose Diagnose option. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/22/2017
(0 Ratings) 657 views
How to display blocker name in the Locks - Blocked Processes alarm message (230709)

How do you display the blocker name in the Locks - Blocked Processes alarm message? 1. Go to Configure | Alarms. 2. Either create a template or look for specific SQL Instance that you want to apply the change to. 3. Look for 'Locks - Blocked Processes'. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/22/2017
(0 Ratings) 5 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. STATUS. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/21/2017
(0 Ratings) 9 views
Is it possible to configure the Fragmentation By Index collection to run less often and have a much longer timeout? (189543)

Is it possible to configure the Fragmentation By Index collection to run less often and have a much longer timeout? that is not currently possible WORKAROUND. None STATUS. Index Fragmentation collection has been redesigned ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/20/2017
(0 Ratings) 1026 views
Collection 'Fragmentation by Index' failed: SQL query has "not timed out" (189584)

Getting alarm: Severity Alarm Raised Cleared Message Snoozed By Snoozed Until Information Monitored Server - SQL Server Collection Execution Failure 1/11/2016 1:11:00 AM Collection 'Fragmentation Overview' failed : Collection 'Fragmentation by Index' failed : The SQL ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/20/2017
(1 Ratings) 1182 views
Does Spotlight use data encryption? (53508)

Spotlight uses connection profiles to store information that individual monitored connections use to connect to target servers or systems. 1. How does Spotlight enciphers the user and password details? 2. Does Spotlight encrypt connections/password through network traffic? ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/20/2017
(0 Ratings) 2636 views
Database Details Disk Space option "Include Non-SQL files" doesn't show data (230600)

Drilling down into the Database Details | Disk Space details and checking the "Include Non-SQL files" option, doesn't change the data displayed to show free space and nonsql file data. WORKAROUND: None. STATUS: Waiting ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/20/2017
(0 Ratings) 3 views
How to check if the Spotlight maintenance jobs have been running successfully (230332)

How to check if the Spotlight maintenance jobs have been running successfully? If the run of maintenance procedures was unsuccessful, the following alarms are raised. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/20/2017
(0 Ratings) 4 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: 6/20/2017
(0 Ratings) 2 views
Errors in version 12.0. after upgrade (230553)

1).PlaybackWriterJob - Stop dump playback memory queue to disk. 2).OOPCollectorXEvents.OOPCollectorXEvents - Execute failed. 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: 6/19/2017
(0 Ratings) 8 views
Spotlight crashes in Windows 10. (230547)

Spotlight crashes in Windows 10. Sometimes this happens when clicking on the Status option. After selecting one of the alarms there, Spotlight crashes giving the option to debug or close the program. WORKAROUND Run ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/19/2017
(1 Ratings) 39 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 ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/19/2017
(0 Ratings) 18 views
Alarms "Data file growths remaining could not be evaluated because there is no data in the fileinfomissingreason column of the File Groups collection" appear persistently in Spotlight. (190107)

Alarms "Data file growths remaining could not be evaluated because there is no data in the fileinfomissingreason column of the File Groups collection" appear persistently in Spotlight. WORKAROUND: 1. Select Configure | Alarm Actions option from top of your screen. ...

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/16/2017
(1 Ratings) 952 views
After upgrading getting a "Connection 'windows registry channel' failed to connect' error. (230502)

WMI seems to work but getting a "Connection 'windows registry channel' failed to connect' error. This is a problem with Windows registry access and not WMI

Product(s): Spotlight on SQL Server Enterprise
Last Updated On: 6/16/2017
(0 Ratings) 2 views
VIDEO - 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/15/2017
(2 Ratings) 5210 views
How to uninstall the Spotlight client only MSI? (230475)

After installing the Spotlight client 12.0 client MSI, there is no option to remove the client from the Windows Control Panel | Programs and Features. How is it possible to uninstall the client only? 1. Open command line and use the “Run as Administrator” option. ...

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