The SQL Server Riadk and Health Assessment Program, otherwise known as SQLRAP, isn't well known. It hasn't been blogged about much. Today I'm analyzing SQLRAP output and developing a plan to implement changes it suggests. You can read more about the program here: http://www.microsoft.com/downloads/details.aspx?familyid=8D54DB4D-3232-4CF8-8BA5-E80557835421&displaylang=en
The SQLRAP service is when you pay for a premier support engineer to come to your site and run the SQLRAP tools to collect metrics about your SQL Servers. A verbal description of what's done doesn't do justice to SQLRAP. The real value of SQLRAP is in the presentation. DMVs, logs, and Perfmon already provide us with lots of data - often too much. SQLRAP turns the raw data into information we can easily use.
SQLRAP is a service I'm comfortable recommending. Here’s a screenshot of a small portion of the output:
