Report

Generate Multi-Instance SQL Server Reports

Scan your estate to generate and save SQL Server reports. With these reports you have both inventory and expert advice with just a few clicks of the mouse. All reports can be exported to Excel for filing or sharing.

Instance Report

This report contains all of your SQL Server instances, with columns for version, edition, build and more. Filter the report by any column to quickly see the layout of your estate and whether there are any unpatched instances.

Database Report

List all databases across your entire estate. Filter by name, collation, state, compatibility level, recovery model and more. Very useful for quickly answering such questions as "How many ReportServer databases are there?" or "Has the page verify option been set correctly on all databases?"

Best Practices Report

Checks every instance for more than 50 best practices. Click on any item in the report to see more detail. See SQL Server Best Practices for the full list.

System Health Report

Checks every instance for 40 signs of poor system health. Click on any item in the report to see more detail. See SQL Server Health Check for the full list.

Instance Report

Scan the instances in your estate.

Sort or filter on any column.

Export to Excel.

Useful for answering questions such as:

  • What is the breakdown of instances by edition?
  • Do I have any SQL Server 2016 that is not on the latest SP?
  • What is the total database size across all production instances?

SQL Server Instance Report

Database Report

Scan the instances in your estate and retrieve information about all databases.

Sort or filter on any column.

Export to Excel.

Useful for answering questions such as:

  • Which instances have copies of database xyz on them?
  • Do I have any databases where page verify option is not set to CHECKSUM?
  • What is my largest production database that is not using FULL recovery model?

SQL Server Databse Report

Best Practices Report

Scan the instances in your estate and check that best practices are being followed.

Checks for more than 50 best practices. This list is being added to every release. For the full list see SQL Server Best Practices.

Sort or filter on any column.

Export to Excel.

Useful for answering questions such as:

  • Which are the highest priority best practices that I should tackle first?
  • Are there any security best practices that are not being followed?
  • Has "max server memory" been set correctly on all instances?

SQL Server Best Practices Report

System Health Report

Scan the instances in your estate and check for signs of poor system health.

Checks for 40 potential issues. This list is being added to every release. For the full list see SQL Server Health Check.

Sort or filter on any column.

Export to Excel.

Useful for answering questions such as:

  • Are there any worrying wait types on any of my instances?
  • Are there signs of memory contention anywhere?
  • Is anything worrying being logged in the error log on any servers?

SQL Server System Health Report

Start for FREE today

  • Increase DBA Productivity
  • Quickly Find and Fix Issues
  • Installs in Seconds