info@amalit.ae +971 4 3599916 amalit
 

Easily optimize and tune SQL Server performance anywhere on any device

Ensure peak performance around the clock with unmatched monitoring, diagnosis and optimization of SQL Server environments. Spotlight provides access to the details you need for optimal fitness of your SQL Server databases. Get intuitive overviews of health and performance, automated alerts and actions, and mobile device support.


Features


24x7 monitoring and diagnostics

Establish around-the-clock agentless monitoring from a centralized diagnostic server for a single view across multiple clients, with alarms and notifications when performance deviates from pre-set operating thresholds.

Simplicity without compromise

Install quickly and monitor large environments easily. Template configurations, automated alerts and customizable actions make configuration a breeze. Intuitive overviews and mobile device support deliver the data you need where and when you need it.

Powerful root cause analysis

Create multiple diagnostic workflows, including detailed wait stat/workload analysis and deadlock detection, with over 70 diagnostic drilldowns. Correctly recognize the symptoms to correctly deal with the root cause of any diagnostic challenge.

End-to-end monitoring

Get a complete picture of everything that affects your SQL Server performance including SQL Server itself, the underlying operating system, its VM layer, SQL Azure, high availability, replication and analysis services — all available in one package for one price.

Never miss a beat with playback and mobile

Rewind your dashboards and diagnostic drilldowns to the time an incident occurred and step through it in slow motion. Monitor your SQL Server environment anywhere, anytime and run SQL Server diagnostics directly from your mobile device or web browser.

Multidimensional analysis

Analyze workload elements and wait stats by database, application, user, host or SQL statement. Establish top SQL. Drill down to determine the biggest contributors to the SQL Server workload.

Customize for your environment

Set custom thresholds or create counters specific to your environment. Create rule-based custom actions or define planned outages on a one-time or recurring basis.

Tool of choice

Integrate with enterprise monitoring or issue tracking systems. Use the SCOM management pack to easily integrate Spotlight as the tool of choice for your SQL Server needs.

SQL analysis and Xpert tuning

Utilize the integration with SQL Optimizer to highlight long-running queries and sub-optimal code. Immediately tune, benchmark and investigate indexing strategies.

Historical trending and reporting

Understand the health, activity and capacity trends of your SQL Server environment with integrated management and performance views and client-side reports.

System Healthcheck and Collective Intelligence

Obtain a holistic view of the health of your system and benchmark results with other users.

PagerDuty™ integration

Users of PagerDuty can now send Spotlight alarm notifications to a PagerDuty dashboard.

Manage large-scale monitoring deployments

For large-scale SQL Server deployments, Spotlight provides custom views and template configuration to make monitoring your environment easy at any scale.

View more details
© 2017 All Rights Reserved.
Amal IT