SQL Server environments are becoming more complex while remaining a critical component of your application architecture. It’s a struggle to keep up with this continual growth without the right SQL monitoring tools. What if you could proactively manage your SQL Server environment and diagnose database performance issues by viewing the health of all your SQL Server instances on a single screen, anytime, anywhere on any device? You can with the right SQL Server monitoring tool.
With Spotlight on SQL Server Enterprise, you can manage your SQL Server environment while also gaining visibility into your operating system – Windows or Linux – and also monitor your virtualization infrastructure. Make configuration a breeze with templates, automated alerts and customizable actions. Spend less time fighting fires by accurately diagnosing real-time and historical database performance issues, and focus on more proactive measures like query tuning.
Before installing the Spotlight client, ensure your system meets the following minimum hardware and software requirements:
1GHz Processor
1GB RAM recommended
200MB
This space should exist on a local disk drive rather than a network drive
SQL Server Client Tools
Install .NET 2.0 or later
Before installing the Diagnostic Server, ensure your system meets the following minimum hardware and software requirements:
2GHz Dual Core Processor
300MB
4GB RAM
If the Diagnostic Server’s connection to the Spotlight Statistics Repository or playback database is interrupted, the Diagnostic Server will cache data to the local disk. In this event, an extra 2MB per hour, per monitored server is required.
SQL Server Client Tools
SQL Server Management Tools
Spotlight can diagnose SQL Server instances of the following versions:
Spotlight on SQL Server also supports MSDE (2000), SQL Express (2005) and SQL Server 2008 Express Edition and SQL Server 2012 Express. Note that use of these versions to host playback or Spotlight Statistics Repository databases is not supported.
Spotlight cannot diagnose earlier versions of SQL Server (version 7.x and earlier).
Spotlight supports all SQL Server sort orders, including case-sensitive and binary sort orders. Spotlight cannot connect to SQL Server instances where the instance name contains non-US ASCII characters.
Spotlight on SQL Server can monitor virtual guest machines in a VMware ESX infrastructure. The following versions are supported:
Note: On each monitored instance, Spotlight requires the network setting "File and Print Sharing" to be enabled and any firewall to be configured to:
Spotlight on SQL Server can monitor virtual guest machines in a VMware ESX infrastructure. The following versions are supported:
Spotlight on SQL Server can monitor virtual machines in a Hyper-V® infrastructure. Spotlight supports
Before installing the Spotlight Statistics Repository, ensure your system meets the following minimum requirements:
By default, the size of the Spotlight Statistics Repository is set to 1000MB (data size) and 250MB (log size). These sizes are flexible and can be changed by running the Spotlight Statistics Repository creation script.
The script is located in the install directory as follows:
Approximately 1.2GB for each monitored SQL Server instance and the corresponding monitored Windows host on which the SQL Server instance resides. This estimate assumes default configuration in an average environment. Actual space used will depend on your environment and any data collection/storage configuration changes that are made. For more information, see the Spotlight on SQL Server Sizing Wizard. You can access the wizard from the Spotlight Installation Center. To use Spotlight Reporting and Trending, it is recommended that the Spotlight Statistics Repository is installed on SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 or SQL Server 2019.
Installing the Spotlight Statistics Repository on SQL Server 2000 can result in errors being displayed and no data being shown in some views. Installing the Spotlight Statistics Repository on SQL Server 2000 is not recommended.
Note: Due to the size of the Spotlight Statistics Repository, it is recommended that this database is not installed on a SQL Express instance.
The SQL Browser service must be running on the machine where the Spotlight Statistics Repository is installed. Alternatively you can use the host and port number of the (named) SQL Server instance you want to connect to, when creating a connection and connecting to the Spotlight Statistics Repository.
The TCP protocol must be enabled on the instance where the Spotlight Statistics Repository resides.
For more information, see the Spotlight on SQL Server Deployment Guide.
It is highly recommended that regular maintenance is performed on the Spotlight Statistics Repository. The recommended maintenance plan is outlined in the online help and in the Spotlight on SQL Server Deployment Guide.
Before installing the playback database, ensure your system meets the following minimum requirements:
By default, the size of the playback database is set to 500MB (data size) and 125MB (log size).
Requires approximately 270MB for each monitored SQL Server instance and the corresponding monitored Windows host on which the SQL Server instance resides.
Assumes default configuration in an average environment. Actual space used will depend on your environment and any data collection/storage configuration changes that are made.
For more information see the Spotlight on SQL Server Sizing Wizard, you can access the wizard from the Spotlight Installation Center.
Due to the size of the playback database, it is recommended that this database is not installed on a SQL Express instance.
The SQL Browser service must be running on the machine where the playback database is installed. Alternatively you can use the host and port number of the (named) SQL Server instance you want to connect to, when creating a connection and connecting to the playback database.
The TCP protocol must be enabled on the instance where the playback database resides.
For more information, see the Spotlight on SQL Server Deployment Guide
It is highly recommended that regular maintenance is performed on the playback database. The recommended maintenance plan is outlined in the online help and in the Spotlight on SQL Server Deployment Guide.