Tuning Advisor

Tuning Advisor turns what DBPulse has collected into a ranked list of recommendations. Pick a server and a time range; tiles count the total recommendations and how many are High, Medium and Low priority. Filter by priority or category, and expand any recommendation to see the details. Each one carries a score, and the page reminds you to test recommendations in a non-production environment first.

What you see on this screen

• 1
  Ranked by priorityEach recommendation shows a priority (High, Medium, Low), a category such as Maintenance, and a numeric score bar.
• 2
  Plain descriptionsFor example “8 indexes need REBUILD — 8 indexes exceed 30% fragmentation, causing extra page reads on scans and range seeks”, and “2 indexes need REORGANIZE”.
• 3
  Runnable SQLRecommendations come with SQL you can run, based on the telemetry DBPulse has collected.