Server Assessment Code

Thanks for visiting my blog.  Sadly, when running SSRS reports in SQL Server Management Studio, the text cannot be selected to copy.  Because of this, I have created these pages to make it easier for you to capture the code used in the assessment tool.


Report Description
Additional Memory Counters More memory related counters such as Free List Stalls and Lazy Writes
Alert Information General information about the Alerts, including the last occurrence.
Authentication Information Windows or Mixed authentication. How is the server configured?
Auto Delete Jobs Are there any jobs configured to delete automatically? This report will tell you.
Availability Group Information What Availability Groups exist and what databases are involved
Azure Database Resource Stats Returns Performance related information on an Azure SQL DB
Azure SQL DB Service Tiers You can use this report to find the service level for each Azure SQL DB on your instance.
Row:6 Cell:1 Row:6 Cell:2