SQL Reports Offer Insight Into SQL Server 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.

 

Download Trial

Try the SentryOne Platform today for free and discover how you can save time on performance reporting.

 

SQL Reports | SQL Server | SentryOne

“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, Principal Consultant at SQLskills

We All Need  Microsoft 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. The SentryOne Platform 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 counters at 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. SQL Server 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 Adobe PDF, Microsoft Excel, and Microsoft Word. You can even customize reports to define any combination of counters or servers and save those SQL reports for future time-saving use.

 

 

 

Learn more about SentryOne Reporting by watching this video!

SentryOne Reporting Video-1

What kind of reports does SentryOne offer?

SentryOne offers an expansive list of reporting options. SentryOne reports are generated using SQL Server Reporting Services (SSRS) technology. Below are four reports you might find interesting. For a complete listing of SentryOne reports, click here.

Windows + SQL Server Performance

The Windows + SQL Server Performance report provides detailed performance metrics for each instance on the selected server with regard to Windows and SQL Server performance. Use the Windows + SQL Server Performance report in conjunction with the Performance Analysis Dashboard to gain an insight into the performance of your monitored environment.

DBs without Recent Backups

The Databases without Recent Backups report provides information about Databases without a recent backup in your monitored environment. Information is included for both Data and Log files, including the Last Backup Time, Last Backup Type, and Used Size (MB). The default time range for this report covers the last 15 days, but is configurable. Transaction Log files are not included in this report if the database is in simple recovery.

SQL Server File Growth - Top Files

The SQL Server File Growth - Top Files - All Servers report provides data and log file growth over the selected time range for the Top N files, as selected in the report parameters, across your entire installation. There are representations for Total Size and Used size over the selected time frame.

Perf. Counter Data Range Comparison

The Performance Counter Date Range Comparison report provides both graphical and textual data for the selected performance counter(s) over the specified time range. Various parameters can be configured including: Server, Instance, Category, Counter, and Instance. This report is similar to the Performance Counter History report except two different time ranges can be selected.

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

Try SentryOne for free today!
 
Download Trial