SQL Reports Offer Insight Into Performance

SentryOne makes reporting on server performance easy. With over 25 preformatted reports, you can gather baselines, uncover bottlenecks and get a total picture into the performance of your environment.

Try SentryOne Performance Advisor or Event Manager today for free and discover how you can save time on performance reporting.

Let's get started

SQL Reports

“One of my favorite things about Plan Explorer is the ability to copy the plan's XML and paste it in. When I'm working in client environments and they don't have PE installed, it's incredibly helpful.”

Erin Stellato

We All Need SQL Server Performance Reports

SQL reports are necessary for measuring your servers’ performance, finding trends and even gathering baselines to get a complete picture of your environment. SentryOne makes performance reporting easy and maximizes your valuable time with preformatted SQL Server reports that are available for any metric that SentryOne collects. Whether you are looking at individual counters or a global level, the SQL reports available via the SentryOne Client allow for a wide variety of reporting options.

You can use date range comparisons to gain valuable understanding of your server’s long-term performance. Reports are generated within the SentryOne client using SQL Server Reporting Services (SSRS) technology and can be accessed by the easy to use reports menu. Any SQL Server reports you generate you can export in other formats such as PDF, Excel, and Word. You can even customize reports to define any combination of counters or servers and save those SQL reports for future time-saving use.

What kind of reports does SentryOne offer?

SentryOne offers over 25 preformatted reports, but some that you may find most useful are:

Windows + SQL Server Performance

View detailed performance metrics for each of your instances on a selected server. Along with the Performance Advisor Dashboard, this report provides a look at the performance of your environment.

Databases without Recent Backups

View pertinent information about your databases without a recent backup in your environment. With information about both data and log files, last backup time and type and used size (MB), this is an incredibly useful report for staying on top of your backup history.

SQL Server File Growth – Top Files – All Servers

Find out where you have the most growth and where you may experience space issues with the SQL Server File Growth – Top Files – All Servers report. This report provides data and log file growth over a specified time range for the Top N files across your environment.

Performance Counter Date Range Comparison

See how the changes you made to fix that performance bottleneck have performed with the Performance Counter Date Range Comparison report by comparing the week leading up to the change and the week after. This report gives both a graphical and textual data for the performance counters of your choice over a specified date range.

SQL Server reports are provided in five different categories: Performance, Blocking, Top SQL, Disk/File Space and Deadlocks. SentryOne provides many SQL reports for all of the data you want to answer questions and test performance fixes.

LOOKS LIKE YOUR BROWSER IS OUT OF DATE

For your convenience here are links to supported browsers:

Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.

Don't show this again