Spotlight on SQL Server Enterprise 2.5

Spotlight on SQL Server Enterprise is a powerful database diagnostic and resolution tool. Its unique user interface provides you with an intuitive, visual representation of the activity on a SQL server. Graphical flows illustrate the rate at which data is moving between server components. Icons display the value of key statistics and metrics. Alarms inform you of bottlenecks and other potential problems. Drilldowns show detailed information on all parts of your SQL Server.

Spotlight integrates data from various sources into a single display. It seamlessly combines data from SQL Server system tables, SQL commands, performance monitor counters, and the Windows registry. Spotlight diagnoses not just your SQL Server, but also the Windows machine that SQL Server is running on.

Spotlight on Windows Enterprise is now packaged and integrated with Spotlight on SQL Server Enterprise. The purchase of Spotlight on SQL Server Enterprise on each licensed server includes Spotlight on Windows Enterprise for free.

With the Enterprise version of Spotlight, diagnostic data can be collected continuously, even when Spotlight is not open on the desktop. A Diagnostic Server can perform data collection continuously from a middleware machine, ready for Spotlight to display whenever Spotlight is started on any client machine.

New in This Release

The development team welcomes any comments on the new features of this release, and information on any problems/limitations found in the product and not listed below.

Resolved Issues

The following is a list of issues addressed in this release of Spotlight on SQL Server Enterprise.

Known Issues

The following is a list of issues known to exist at the time of this release of Spotlight on SQL Server Enterprise.

Category	Known Issue	Defect ID
General
	Negative values in Wait Statistics drilldown. Negative values may be shown in the Waits Details grid.	ST#3757
	Response time SQL statement. When upgrading from Spotlight on SQL Server Enterprise to 2.5 the formatting in the SQL statement used to measure response time for a SQL connection may be lost. Workaround: Replace the lost formatting by opening the Spotlight on SQL Server Enterprise Options window, selecting Diagnostic Configuration and then clicking SQL Server Response Time. Only members of the Quest Diagnostic Administrators group can change the SQL statement.	ST#3547
	Spotlight Statistics Repository and SQL Server 2000. Installing the Spotlight Statistics Repository on SQL Server 2000 is not recommended. Doing so can result in errors being displayed and no data being shown in some views.	N/A
	Spotlight Statistics Repository and SQL Server 2008. Installing the Spotlight Statistics Repository on SQL Server 2008 is not supported.	ST#3677
	Data sourced from SQL Server 2000 performance counters may be incorrect. Spotlight may display an incorrect size or procedure cache hit rate for SQL Server 2000. This does not apply to SQL Server 2005.	ST#3057
	False deadlock alarm. Under some conditions, a deadlock alarm may be raised incorrectly and displayed in the Alarm log. Even in such cases, the data displayed on the Deadlocks/sec chart (SQL Activity drilldown) is correct.	ST#1734
	SQL Analysis grid. The Text Data column in the SQL Analysis grid may occasionally display blank rows. This is due to SQL Server not returning any data in the Text Data column from the trace.	CR#219577
	Virtual PC. Running Spotlight on SQL Server Enterprise on a Microsoft Virtual PC 2004 virtual machine is not recommended. There are a number of issues with Microsoft Virtual PC 2004 that may cause Spotlight to display data incorrectly.	CR#218911
	Storing statistics in the Spotlight Statistics Repository. The Store statistics in the Spotlight Statistics Repository option applies to both the SQL Server connection and its equivalent Windows connection. If you change this option for a SQL Server connection, the change is also applied to the equivalent Windows connection, and vice versa.	N/A
	Changing Spotlight configuration options. Changes to Spotlight configuration options cause all current alarms to be re-evaluated. This may result in duplicate emails or command line actions (if configured) for current alarms even if they have already been raised. This also applies to Spotlight on Windows Enterprise.	CR#218377
	SQL Analysis and SQL Server 2000. SQL Analysis is built on top of SQL Server Trace. In SQL Server 2000, Trace only supports filtering on Database ID. This limitation does not exist in SQL Server 2005 where filtering on Database Name is also allowed. SQL Analysis gets around this somewhat by allowing you to specify a database name for SQL Server 2000. This is converted to a Database ID and this ID is used for the filter. Note the following: In SQL Server 2000 wild cards cannot be used in a database filter since Trace only supports filtering on one Database ID at a time. Since a wild-carded name cannot be resolved to a single Database ID the filter will not function. In a mixed environment of SQL Server 2000 and SQL Server 2005 a database filter that uses wildcards that is set at site default level will also not function for SQL Server 2000 instances.	CR#211872
	Server permissions and NetBIOS. For information on server permissions, see Security and Firewall Considerations with Spotlight on SQL Server Enterprise. This document is available in PDF from the Windows Start menu.	N/A
	Daylight Savings time changes. Stop the Diagnostic Server service before changing the system time on the Diagnostic Server machine.	N/A
	Explain Plan. This version of Spotlight on SQL Server Enterprise does not support the collection of Explain Plan data. This functionality will be added in a later release.	N/A
	Spotlight Reporting and Trending. Some views are not displayed correctly at a screen resolution of 1024 by 768.	ST#3633
	Monitor requirements. Spotlight on SQL Server Enterprise requires a monitor that supports 65536 colors (or Hi Color) or higher so that it can properly shade graphics.	N/A
	Use of ATI Rage Video card. If you are using an ATI Rage video card or chipset (such as the ones used in Dell laptops) you may encounter display problems when using Spotlight.	N/A
Installation & upgrades	Upgrading the Spotlight Statistics Repository. It is highly recommended that maintenance is performed on the Spotlight Statistics Repository before it is upgraded. For information on the recommended maintenance plan, see the Spotlight on SQL Server Enterprise Getting Started Guide.	ST#4155
	SMTP settings. When upgrading to 2.5, the SMTP settings that Spotlight uses to send emails may not be transferred. Configure the SMTP settings by clicking the Server button on the Diagnostic Server Administration page.	ST#3020
	Upgrading a Spotlight Statistics Repository from Spotlight version 2.1. to 2.5 (SQL Server 2000 only). When upgrading a Spotlight Statistics Repository to version 2.5, a number of warnings will be displayed when the host instance is SQL Server 2000. These warning messages can be ignored and should not affect the insertion of data into the repository.	ST#3156
	Installing other Spotlights. Do not install other Spotlights into the Spotlight on SQL Server Enterprise folder. You will be unable to run Spotlight on SQL Server Enterprise if you do this. When installing other Spotlights you must install them into a different folder.	N/A
	Installing for multi-user access. If multiple users of a system install Spotlight for use, the additional users must be local administrators.	N/A
	Remote installation. Remote installation of Spotlight on SQL Server Enterprise fails if the user has both a domain account and a local account with the same user name.	N/A
	Windows Vista. Installation of Spotlight must be performed as an Administrator and Spotlight also needs to be run as an Administrator to install the Diagnostic Server. Subsequent use of Spotlight can then be as a normal user, with the only actions that then require Administrator privileges being the viewing and editing of licenses.	N/A
	Uninstalling the Diagnostic Server (64-bit operating systems). It is necessary to stop the Diagnostic Server service before using "Add/Remove Programs" to manually uninstall the Diagnostic Server on 64-bit versions of Windows 2003, 2008 or Vista.	ST#3415
Diagnostic Server
	Moving a Diagnostic Server. If you want to move your Diagnostic Server to a different host machine and continue to use the current Spotlight Statistics Repository, you will not be able to report on data collected across the original and moved Diagnostic Servers. Contact Quest Support for assistance if you want to report on data collected by the original Diagnostic Server after the move.	ST#4178
	Renaming the Diagnostic Server. The Diagnostic Server host cannot be renamed without reinstalling the Diagnostic Server. To conserve configuration and history, migrate the Diagnostic Server to another host before the machine is renamed.	ST#3052
	MySQL on the Diagnostic Server machine. If MySQL is running on the machine you intend to install the Diagnostic Server on, shut down MySQL before installing the Diagnostic Server. If required, you can restart MySQL after installing the Diagnostic Server.	CR#215419
	Diagnostic Server user privileges. The minimum Windows privilege level required to run the Diagnostic Server is Power User. During runtime, the Diagnostic Server requires write access to folders in the C:\Program Files directory. Without the appropriate privileges, the Diagnostic Server cannot run.	CR#206558
	Uninstalling the Diagnostic Server. If, during uninstallation of the Diagnostic Server, an error message displays stating that another application has exclusive access to a file located in C:\Program Files\Quest Software\Diagnostic Server, do the following: Leave the error message open. Use Windows Task Manager to manually end the mysqld.exe process. On the error message, click Retry. This happens when the Diagnostic Server is running under SYSTEM user credentials and is then uninstalled by a normal user.	N/A
	Unable to perform certain operations. If, whilst using the Spotlight on SQL Server Enterprise client, a message is displayed stating: You are not connected to the Diagnostic Server as a member of the Quest Diagnostic Administrators group. Only members of that group can perform the requested operation. and the user needs to be able to perform the operation that led to this message, the Spotlight on SQL Server Enterprise client user must be added to the Quest Diagnostic Administrators group on the Diagnostic Server.	N/A
Connections	SQL Server instance names containing non-US ASCII characters. Spotlight cannot connect to SQL Server instances where the instance name contains non-US ASCII characters.	ST#3343
	Access errors when connecting to SQL Server 2005. If an access error related to xp_cmdshell occurs and the user changes the SQL Server configuration to allow access to xp_cmdshell, the SQL Server documentation states that you must disconnect and reconnect. To disconnect in Spotlight on SQL Server Enterprise, you must disable monitoring and enable monitoring for that SQL Server. To disable and enable monitoring, in the Connection Manager, right-click the affected SQL Server and select Properties. On the Monitoring page, select Do not Monitor and then click OK. A confirmation message is displayed. On the Monitoring page, select Monitor and then click OK. Close the Connection Manager.	N/A
	Mandatory creation of Windows profile. When you connect to a SQL Server instance using Spotlight on SQL Server Enterprise (thereby creating a SQL Server profile for the connection), Spotlight will also create a Windows profile for use with Spotlight on Windows Enterprise, regardless of whether you intend to use Spotlight on Windows Enterprise.	N/A
	WMI access denied alarm messages. A large number of WMI access denied alarm messages usually indicates a network problem such as a malfunctioning domain controller or DNS server. When the network problem is resolved, restart the Diagnostic Server service.	N/A
	Microsoft Cluster Server connection problem. If you are connecting to a Microsoft Cluster Server system that does not have control of all disk resources, the uncontrolled disks may display a value of zero for space in total and space available in Spotlight. To rectify this problem customize your disk view to not show this disk. (Do this by right-clicking the disk and choosing Disk Options).	N/A
	Windows 2000 and Remote Registry service. When the machine being diagnosed is running Windows 2000, it must also have the Remote Registry service running. If you attempt to connect to a Windows 2000 machine that has the Remote Registry service stopped, Spotlight will return error message: *Network name not found.* Make sure the Remote Registry service is running on the Windows 2000 machine you are connecting to.	N/A
	Migrating connection properties. When changing or upgrading a Diagnostic Server, some component properties such as MaxValue, ToolTips and chart customizations are not transferred. In this case, properties that are not transferred revert to the default settings.	N/A
	Monitoring multiple SQL Server instances. This version of Spotlight on SQL Server Enterprise is designed to monitor a maximum of 50 SQL Server instances. Monitoring more than this recommended limit may result in poor performance or product instability.	N/A
	Setting multiple connections to 'Do not monitor'. When setting multiple connections on the Connection Configuration page to 'Do not monitor', it is recommended that you set no more than 10 connections at once.	N/A
Playback mode	History Browser and Playback mode. A number of drilldowns do not display data correctly when Spotlight on SQL Server Enterprise is in Playback mode. Some grids display "no data" when being viewed in Playback mode. The affected drilldowns, grids, and Spotlight home page elements include: Spotlight on SQL Server Enterprise home page The Status button is disabled. The Error Log, Replication and Services buttons show the alarm that was current at the selected time. Memory drilldown Buffer Cache page - Shows data only if the Buffer Cache page was viewed in live mode at the selected time. If the Page Life Expectancy alarm was raised during the selected time, the Buffer Cache page shows data. Procedure Cache page - Shows data only if the Procedure Cache page was viewed in live mode at the selected time. If the Procedure Cache Hit Ratio alarm was raised during the selected time, the Procedure Cache page shows data. Session Details sub-page (SQL Activity drilldown > Session page) Shows data only for those sessions that were selected in live mode at the selected time. If the Disk Queue Length alarm was raised during the selected time, the top five sessions sorted by I/O are populated in the Sessions grid. If the Windows CPU alarm was raised during the selected time, the top five sessions sorted by CPU are populated in the Sessions grid. SQL Analysis grid (SQL Activity drilldown > SQL Analysis page) The Show Real-Time data option is not available in Playback mode. The Show Statistics Repository data option is available in Playback mode but displays data from the time period specified in the From and To fields, not from the time selected in the History Browser. Job Messages sub-grid (Support services drilldown > SQL Agent Jobs page) Shows data only for those jobs selected in live mode at the selected time. Replication drilldown Shows data only if the drilldown was viewed in live mode at the selected time. Configuration drilldown Shows data only if the drilldown was viewed in live mode at the selected time. Error Log drilldown Shows data only if the drilldown was viewed in live mode at the selected time. The Error Log drilldown is accessible only via the Error Log button on the homepage when Spotlight is in Playback mode. Note: Playback data is collected when any Spotlight client is viewing a drilldown. This means that Playback data may be available for a drilldown that you never viewed. For procedures that are collected only when a Spotlight client is connected, you can change the Scheduling options so that data is collected and stored for those procedures, even when no Spotlight clients are connected. To display the Scheduling options, on the Diagnostic Server Administration drilldown, click the Scheduling button. The following grids and charts show data in Playback mode only if an alarm was raised at the selected time: SQL Agent Alerts grid (Support Services drilldown > SQL Agent Alerts page) Blocking grid (SQL Activity drilldown > Blocking page)	N/A
SQL Server	SQL Server SP3 and SP4. If you install SQL Server 2000 SP4 without installing SP3, some of the functionality that Spotlight relies on is not installed and Spotlight may display errors relating to the work database. To overcome this, it is recommended that you install SP3 and then install SP4.	N/A
SQL Server 2008	Spotlight on SQL Server Enterprise has SQL Server 2008 tolerance. The following are known issues when monitoring a SQL Server 2008 instance: Procedure Cache grid. The Procedure Cache grid (Memory drilldown > Procedure Cache page) does not show data. SQL Analysis drilldown. Enabling SQL Analysis causes an error. Using the "Show Statistics Repository data" option causes an error. Full Text Search page. The Full Text Search page (Support Services drilldown) does not display data, even when Full Text Search is enabled on a SQL Server 2008 instance. Configuration Suggestions page. The Configuration Suggestions page (Configuration drilldown) may not show data. Session Trace. The Session Trace grid (SQL Activity drilldown > Sessions page) does not display data. Spotlight cannot collect session trace data for SQL Server 2008.
Spotlight on Windows Enterprise	Errors when monitoring Windows 2000 Server. When monitoring a Windows 2000 server, errors may be displayed in Spotlight Today and the Alarm log. This is due to the Win32_PerfFormattedData_PerfProc_Thread WMI class not being installed by default.	ST#3092

Upgrade and Compatibility

Upgrading to a 2.5 Diagnostic Server

For more information about upgrading, see the Spotlight on SQL Server Enterprise Getting Started Guide.

The Getting Started Guide is available as a separate download from www.quest.com and after install, from the Windows Start menu.

System Requirements

The following tables outline the basic system requirements required to use Spotlight on SQL Server Enterprise. For further information, see the Spotlight on SQL Server Enterprise Getting Started Guide. The Getting Started Guide is available as a separate download from www.quest.com and after install, from the Windows Start menu.

Spotlight Client

Before installing Spotlight on SQL Server Enterprise, ensure your system meets the following minimum hardware and software requirements:

Diagnostic Server

Before installing Spotlight on SQL Server Enterprise, ensure your system meets the following minimum hardware and software requirements:

Deployment Guidelines

For deployment guidelines, see the Spotlight on SQL Server Enterprise Getting Started Guide.

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release supports any single-byte character set. Double-byte or multi-byte character sets are not supported. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America.

Getting Started

Contents of the Release Package

The Spotlight on SQL Server Enterprise release package contains the following products:

Installation Instructions

Refer to the Spotlight on SQL Server Enterprise Getting Started Guide for installation instructions.

For More Information

Contacting Quest Software:

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com/.

Technical Support

If you have questions about using Spotlight, please contact our technical support staff. Please include the version number and if your question is about an error message, include the error text as well.

Support bundles contain information for the active instance only. If you are using Spotlight to diagnose multiple instances, ensure that the correct instance is displayed before creating the support bundle.

This document contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

If you have any questions regarding your potential use of this material, contact:

Trademarks

Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, InTrust, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

Third Party Contributions

Disclaimer

Disclaimer: The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

Category	Resolved Issue	Defect ID
General
	Username column not displayed on Locks drilldown.	ST#1821
	Spotlight on SQL Server Enterprise shouldn’t raise backup alarms for SQL Server 2005 snapshot databases.	ST#3490
	Catastrophic failure error displayed when fetching SQL Analysis data from the Spotlight Statistics Repository.	ST#3526
	Spotlight Statistics Repository is slow when running reports.	ST#3936
Spotlight on Windows Enterprise
Spotlight on Windows Enterprise	Spotlight on Windows Enterprise fails to recognize the PAE switch on Windows servers.	ST#3840

Platform	500 MHz Pentium III PC
Memory	256 megabytes of RAM (minimum); 512 megabytes recommended. 256 megabytes is generally adequate unless there are many other applications running. 512 megabytes of RAM or above will provide optimal performance.
Hard Disk Space	60 MB This space should exist on a local disk drive rather than a network drive.
Operating System	Windows 2000 (Professional, Server, Advanced Server, Datacenter server) with Service Pack 4 Windows Server 2003 Windows Server 2008 Windows XP (Both 32 and 64-bit versions are supported.) Windows Vista (Both 32 and 64-bit versions are supported.)
Supported SQL Server versions	Spotlight can diagnose SQL Server instances of the following versions: SQL Server 2000 with Service Pack 3 or later SQL Server 2005 (Both 32 and 64-bit versions are supported.) Spotlight on SQL Server also supports MSDE (2000) and SQL Express (2005). Spotlight has SQL Server 2008 tolerance. For more information, see Known Issues. Spotlight cannot diagnose earlier versions of SQL Server (version 7.x and earlier). Spotlight supports all SQL Server sort orders, including the Case-Sensitive and Binary sort orders. Spotlight cannot connect to SQL Server instances where the instance name contains non-US ASCII characters.
Additional Software	SQL Server 2000 Client Tools
	Microsoft® Internet Explorer 4.0 or later
	Microsoft Data Access Components (MDAC) MDAC includes the ODBC and other components that enables a connection to be established to a SQL Server database. The database may be local or remote. Your client machine must have MDAC 2.7 (or later) installed. MDAC is available from the Microsoft website: www.microsoft.com/data/download.htm. To find out the version of MDAC that you are currently running, you can download an application from the Microsoft website called comcheck. You can review the following Microsoft Knowledge Base article for more information: http://support.microsoft.com/default.aspx?scid=kb;EN-US;3012022
Other Requirements	CD-ROM drive or Internet connection (required for installation only). A monitor capable of supporting a resolution of 1024x768 or greater. The Spotlight home page and drilldowns were designed to run on a desktop area of 800 by 600 pixels or larger. However, the Spotlight Enterprise Viewer requires a desktop area of 1024 by 768 pixels. You should also set the display to use, as a minimum, the 64K-color palette (65536 colors). Mouse Printer (optional)

Platform	1GHz Pentium 4 PC
Memory	1 GB RAM minimum (2 GB recommended)
Hard Disk Space	For a Diagnostic Server configured as follows: With all default refresh and storage settings SQL Analysis switched on and with the duration filter set at 0 Monitoring a single SQL Server configured as follows: 5 user databases 100 logged on users with moderate activity Spotlight requires the following disk space: 3.5 GB per year for each monitored SQL Server for the Spotlight Statistics Repository. 2.5 GB per seven days for each monitored SQL Server in the Playback database. The Diagnostic Server automatically retains 7 days of historical data for each connection in the playback database. Actual space used will depend on your environment and any data collection/storage configuration changes that are made. Note: These figures include the data gathered whilst monitoring the Windows host on which the SQL Server instance resides. Spotlight Statistics Repository 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 SQL Browser service must be running on the machine where the Spotlight Statistics Repository is installed. Installing the Spotlight Statistics Repository on SQL Server 2008 is not supported. 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 Enterprise Getting Started Guide. Playback database By default, the size of the playback database is set to 500MB (data size) and 125MB (log size). These sizes are flexible and can be changed by running the playback database creation script. The SQL Browser service must be running on the machine where the playback database is installed. Note: Due to the size of the Spotlight Statistics Repository and playback database, it is recommended that these databases are not installed on a SQL Express instance. Installing the Spotlight Statistics Repository on SQL Server 2000 is not recommended.
Operating System	Windows 2000 (Professional, Server, Advanced Server, Datacenter server) with Service Pack 4 Windows XP Windows Server 2003 Windows Server 2008 Both 32 and 64-bit versions of Windows 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: open port 1434 for UDP packets open the SQL Server TCP port (default is 1433)
Additional Software	SQL Server 2000 Client Tools
Additional Software	SQL Server 2005 Management Tools (from SQL Server 2005 Developer edition or SQL Server 2005 Enterprise edition only). To use the Session Trace functionality in Spotlight on SQL Server Enterprise you must install SQL Server 2005 Management Tools and .NET 2.0 on the Diagnostic Server.

Email	info@quest.com
Mail	Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA
Web	http://www.quest.com

Welcome to Spotlight on SQL Server Enterprise	New in this Release	Resolved Issues	Known Issues	Upgrade and Compatibility
System Requirements	Global Operations	Getting Started	For More Information