Spotlight on SQL Server Enterprise is Quest Software's powerful
diagnostic and problem resolution tool for Microsoft SQL Server
databases in an enterprise environment.
Using Spotlight on SQL Server Enterprise, diagnostic data can be
collected continuously, even when Spotlight is not open on the
desktop. A "Diagnostic Server" performs data collection
continuously from a middleware machine, ready for Spotlight to
display whenever Spotlight is started on any client machine.
Business benefits of Spotlight on SQL Server Enterprise include:
* Data collected and alarms evaluated on a 24x7 basis, even when
no Spotlight clients are running
* Identical data and alarms provided to all users, providing a
consistent view across the enterprise
* Historical data is saved in one place (on the Diagnostic
Server), avoiding unnecessary replication of data
* Because queries are executed only once (from the Diagnostic
Server), there is no significant extra load on the database or
operating system as extra Spotlight clients are connected: they
simply "subscribe" to the data already being collected
* Operating System data is collected only once, even if multiple
instances are being monitored on that particular host
* Administrative users can tweak the collections: changing the
timing of, or entirely disabling expensive or unwanted queries
The Spotlight Enterprise Viewer displays a high-level view of the
SQL Servers in your enterprise so you can determine the state of
your enterprise at a glance. Nodes represent the SQL Servers in
your enterprise, displaying the highest severity being raised.
From the Spotlight Enterprise view, you can drilldown to the
Spotlight home page to diagnose the SQL Server database.
The Spotlight homepage displays a visual representation of the
status of the databases in your enterprise, enabling you to drill
down to graphical flows that illustrate the rate at which data is
moving between server components. Icons display the value of key
statistics and measurements (metrics).
The power of Spotlight on SQL Server Enterprise lies in its
ability to provide visual warnings if the performance metrics
exceed acceptable thresholds.
The components and dataflows change color to show you the source
of the problem.
A range of visual graphs and tabular grids provide you with
detailed information about your SQL Server instance. This
information can be viewed on the screen or printed.
You can set Spotlight on SQL Server Enterprise to warn you when a
threshold is reached. You may set a number of thresholds so that
warning messages are displayed well before the traffic levels into
or out of a database become critical. Spotlight uses a number of
different techniques to warn you when your database is exceeding a
threshold.
Spotlight on SQL Server Enterprise seamlessly combines data from
several disparate sources into a single user interface. It
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.
When Spotlight on SQL Server Enterprise detects a condition that
it considers is a potential problem, it not only informs you about
it, but advises you what you could look at to diagnose the problem
further and suggests corrective actions.
Download File Size:67.48 MB
|
