Performance Analysis for SQL Server

By: Edgewood Solutions | Read Comments | Print Edgewood Solutions is a technology company focused on Microsoft SQL Server and founder of MSSQLTips.com. Related Tips: More

Foglight Performance Analysis for SQL Server

Detailed Wait-Event Analysis and Optimization

Download Now!

Foglight® Performance Analysis for SQL Server lets you see enterprise-level performance at a glance. You can determine the root-cause of performance deviations and identify changes to your SQL Server environment quickly and easily.

A powerful enterprise administration and alerting interface lets you create custom dashboards and reports as well as automate and track performance-tuning and problem-resolution initiatives. Foglight Performance Analysis provides a wealth of information — through context-sensitive advisories and detailed wait-event analysis — at a fraction of the impact of conventional collection methods.

Features:

• StealthCollect® – Delivers deep SQL-level collection and analysis at a fraction of the overhead of tracing or T-SQL.
• Context-Sensitive Advisories – Reviews workload data and produces custom reports to maximize performance through built-in analytics and business intelligence.
• True Time-Sensitive Baselines – Allows you to easily determine out-of-bounds activity with the IntelliProfile® learning baseline algorithm.
• Historical Lock Analysis – Speeds resolution of SQL Server concurrency issues with historical reviews of blocking-lock scenarios.
• Statement-Level Wait-Event Analysis – Reveals wait-event data down to the statement level, speeding resolution of resource-related performance problems.
• Compare – Provides a shortcut for identifying the root causes and symptoms of performance deviations in application environments.
• Automated Change Tracking – Receive notifications of changes to server, instance, database, and schema environments, as well as application SQL degradations. Offers custom change alerts.
• Integrated Reporting – Provides targeted, built-in reports. With easy-to-use wizards, you can define, customize, generate, schedule, and deliver reports on system health, performance, trends, changes, and a variety of other topics and data points.
• Long-Term Performance Repository – Delivers unlimited performance and environmental data storage and dimensional analysis in a relational SQL Server database.

Download Now!

Share:

Share

Tweet

Free SQL Server Learning Free webcast - Introduction to SQL Azure Demystify TempDB Performance and Manageability

Comments and Feedback:

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code