|
|
 |
|
Foglight Performance Analysis for SQL ServerFeatures and Benefits
 |
StealthCollect® – High-frequency in-memory collection provides deep SQL-level collection and analysis at a fraction of the overhead imposed by tracing or T-SQL-based collection methods. |
|
Context-sensitive Advisories – Built-in analytic technology and business intelligence is like having an automated in-house SQL Expert review workload data and produce custom reports to guide DBAs toward maximizing performance. |
|
True Time-Sensitive Baselines – The IntelliProfile® learning baseline algorithm allows the DBA to easily determine the activity that is outside the bounds of what is expected. |
|
Historical Lock Analysis – Historically review blocking lock scenarios with detailed information empowering the DBA to easily resolve SQL Server concurrency issues. |
|
Statement-level Wait Event Analysis – Provides the DBA with wait event data down to the statement level, greatly decreasing the time required to resolve resource-related performance problems. |
|
Compare – Using the wealth of information collected by Foglight® Performance Analysis, the compare utility provides DBAs with a shortcut to identifying the root causes and symptoms of performance deviations in application environments. By allowing customized comparisons of any aspect of an instance or application workload with full access to baseline data, identifying the cause of performance deviations is simple, and can even be automated and leveraged with scheduled reporting. |
|
Change Tracking – Automated change tracking enables DBAs to receive notifications of changes to server, instance, database and schema environments as well as application SQL degradations and a facility to define custom change alerts. The integrated alerting mechanism allows DBAs to use the Foglight® Performance Analysis history view to correlate performance slowdowns with changes to quickly understand where to focus their tuning and troubleshooting initiatives. |
|
Integrated Reporting– Foglight® Performance Analysis comes with built-in reports targeted toward audiences from upper management to developers. With easy-to-use wizards, DBAs can easily define, customize, generate, schedule and deliver reports on system health, performance, trends, changes, and a variety of other topics and data points. Plus, by leveraging the long-term performance repository’s schema documentation and Quest’s community of consultants and developers, detailed custom reports are always just a query away. |
|
Web Console – Enterprise-level visibility, administrative shortcuts, custom dashboards and reports, and robust event notifications, workflows and auditing are available from one easy-to-use web interface. By leveraging Quest’s Foglight® management technology, the Web Console delivers DBAs with a centralized, configurable set of dashboards to expose performance anomalies across any SQL Server or Oracle instance monitored by Foglight Performance Analysis. |
|
Long-term Performance Repository – Unlimited performance and environmental data storage and dimensional analysis are provided in a relational SQL Server database. DBAs can feel confident that application trends and the custom reports created on their application workload will be available and accessible using standard T-SQL query techniques. |
|
Dimensional Analysis – Traditional methods of analyzing application and workload trends require DBAs to trace activity and sift through huge amounts of data, or to employ specialists trained in business intelligence and cube analysis. Foglight® Performance Analysis provides DBAs with a dimensional drill-down approach that makes exposing resource bottlenecks from poorly written code, inefficient database accesses or rogue applications or users simpler and more efficient. |
-
Quick Demo
See for yourself how Performance Analysis takes tuning and troubleshooting to a whole new level
 View the demo
-
Customer Tech Brief
Read how customers like you solve their toughest performance challenges with Foglight® Performance Analysis for SQL Server
Read the customer tech brief
-
Request More
Foglight Performance Analysis for SQL Server includes downloads for additional components including WebView as well as documetation on middleware sizing and the Performance Repository schema. Access our download area and choose the appropriate options for your architecture.
-
-
-
Additional Resources
-
Related Solutions
-
Contact Us
|
|
|
|
|