SQL Reports for SQL Server – SolarWinds SQL Sentry

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. SolarWinds SQL Sentry makes performancee 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 SQL Sentry 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 SQL Sentry 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.

SQL Sentry 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 SolarWinds SQL Sentry today for free and discover how you can save time on performance reporting.

What kind of reports does SQL Sentry offer?

SQL Sentry offers an expansive list of reporting options. SQL Sentry 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.