Attention A T users. To access the menus on this page please perform the following steps. 1. Please switch auto forms mode to off. 2. Hit enter to expand a main menu option (Health, Benefits, etc). 3. To enter and activate the submenu links, hit the down arrow. You will now be able to tab or arrow up or down through the submenu options to access/activate the submenu links.

VA Technical Reference Model v 24.3

Spotlight on SQL Server Enterprise
Spotlight on SQL Server Enterprise Technology

General InformationGeneral Information help

Technologies must be operated and maintained in accordance with Federal and Department security and privacy policies and guidelines. More information on the proper use of the TRM can be found on the TRM Proper Use Tab/Section.

Website: Go to site
Description: Spotlight on Structured Query Language (SQL) Server Enterprise is a database diagnostic and resolution software. When Spotlight detects a condition that it considers a potential problem, the software informs the user, advises what to look at to diagnose the problem further, and suggests corrective actions. Spotlight combines data from several disparate sources into a single user interface. This technology collects and combines data from Windows performance counters, SQL Server system tables, SQL Server commands and the Windows registry, and presents them in logically related screens.

Spotlight is available in two editions: Enterprise and Standard. The Enterprise Edition is deployable with a separate Spotlight Diagnostic Server and multiple clients. The Standard Edition is a single installation. This entry covers the Enterprise Edition only.

This technology installs two databases (Playback Database and Spotlight Statistics Repository) on any Microsoft SQL Server of the user`s choosing. These databases store historical data of all SQL Servers the user is monitoring. Additionally, this technology can monitor Spotlight connections from the Spotlight Cloud website or using Spotlight Cloud Mobile, which monitors connections remotely via a mobile device. The Spotlight Cloud service allows for performance data to be uploaded for health check analysis.

The TRM decisions in this entry only apply to technologies and versions owned, operated, managed, patched, and version-controlled by VA. This includes technologies deployed as software installations on VMs within VA-controlled cloud environments (e.g. VA Enterprise Cloud (VAEC)). Cloud services provided by the VAEC, which are listed in the VAEC Service Catalog, and those controlled and managed by an external Cloud Service Provider (i.e. SaaS) are not in the purview of the TRM. For more information on the use of cloud services and cloud-based products within VA, including VA private clouds, please see the Enterprise Cloud Solutions Office (ECSO) Portal at: https://dvagov.sharepoint.com/sites/OITEPMOECSO

This entry covers the Desktop Edition of this technology and not any mobile versions. Please note that the implementation of mobile technology applications that operate on Mobile Operating Systems must be reviewed and approved by the Mobile Technology and Endpoint Security Engineering Team: http://vaww.eie.va.gov/SysDesign/CS/MT/default.aspx.
Technology/Standard Usage Requirements: Users must ensure their use of this technology/standard is consistent with VA policies and standards, including, but not limited to, VA Handbooks 6102 and 6500; VA Directives 6004, 6513, and 6517; and National Institute of Standards and Technology (NIST) standards, including Federal Information Processing Standards (FIPS). Users must ensure sensitive data is properly protected in compliance with all VA regulations. Prior to use of this technology, users should check with their supervisor, Information Security Officer (ISO), Facility Chief Information Officer (CIO), or local Office of Information and Technology (OI&T) representative to ensure that all actions are consistent with current VA policies and procedures prior to implementation.
Section 508 Information: This technology has been assessed by the Section 508 Office and found non-conformant. The Implementer of this technology has the responsibility to ensure the version deployed is 508-compliant. Section 508 compliance may be reviewed by the Section 508 Office and appropriate remedial action required if necessary. For additional information or assistance regarding Section 508, please contact the Section 508 Office at Section508@va.gov. Please see reference tab for more information concerning product versions.
Decision: View Decisions

Decision Source: TRM Mgmt Group
Decision Process: One-VA TRM v22.3
Decision Date: 03/14/2022 at 14:30:07 UTC
Aliases: Spotlight; Quest Spotlight on SQL Server Enterprise
Introduced By: TRM Request
Vendor Name: Quest
- The information contained on this page is accurate as of the Decision Date (03/14/2022 at 14:30:07 UTC).