Product Id: 27850475
Description: Spotlight on SQL Server Xpert Edition - License + 1 Year Maintenance - 1 monitored instance - Win
Mfr Part #: SXC-SPO-PK
Today's businesses rely on their database infrastructure to maintain service levels and provide decision makers with the data they need for success. Upholding a healthy database infrastructure, however, requires the ability to diagnose performance issues quickly and accurately. With Spotlight on SQL Server Enterprise, you can easily monitor, diagnose and optimize your database environments to ensure peak performance around the clock.
With intuitive overviews of enterprise health and performance, automated alerts and actions, and an integrated Xpert tuning module, Spotlight on SQL Server Enterprise makes it easier than ever to obtain the data you need to ensure the health of your databases.
- Provides an easy-to-follow overview of enterprise performance
- Identifies servers where performance degradation originates
- Isolates root cause of a performance issue
- Analyzes performance metrics to expedite issue resolution
- Offers custom reporting capabilities
- Generates automated SQL performance tuning and index
- Coverage for SQL Server, Analysis Services and SQL Azure
Diagnose and optimize the SQL environments that are critical to your business.
- Top SQL and real-time query plans
Pinpoint critical SQL statements running in your environment based on index utilization, resource consumption or query efficiency and immediately review run-time query plans.
- Complete high-availability support
Acquire extensive data on your SQL Server clusters, replication, database mirroring, and log shipping activities and environments.
- Diagnostic drill down
Automate CPU and I/O performance diagnosis and resolution.
- Custom performance counters
Track and set alarms for service level-specific processes to proactively handle uniquely critical issues.
- Historical playback
Navigate from any Spotlight management screen to see up to two weeks of performance diagnostics and alarm data to resolve recent issues more effectively.
- Custom reporting and trending
Understand the health, activity, and capacity trends of your SQL Server enterprise with integrated management and performance views, client-side reports, and the Spotlight on SQL Server Enterprise Report pack.
- SQL Analysis and Xpert tuning
Highlight long-running queries and sub-optimal code and immediately tune, benchmark and investigate indexing strategies through integration with Quest SQL Optimizer for SQL Server.
- Spotlight statistics repository
Configure long-term data storage for historical trending and capacity planning initiatives.
- Wait-state analysis
Determine where waits are occurring and what is causing events.
- Deadlock detection and review
Gain complete visibility of deadlock events and the conditions that caused them.
- Windows-only connections views
Add Windows-only connections to Spotlight on SQL Server Enterprise views.