Discover how to view expert tuning recommendations, including ready to run SQL scripts, in SQL Doctor.
With SQL Doctor, you can identify problems and misconfigurations on a SQL Server instance. And provide recommendations and options for fixing those problems. Today we will talk about how to view expert tuning recommendations, including ready to run SQL scripts. When we start an analysis, we can select the categories we want. The time of the analysis. And filter the specific areas we want to analyze. Then we can run an analysis. The analysis will run for the time you selected. Plus, a few minutes more to create the recommendation report. Once we have the recommendations. By default, they come organized by priority. This priority will display the highest performing improvements based on a ranking system. Each recommendation will have a recommendation title and a description of the recommendation. Some recommendations will also give you information on why this might not be a problem. Why might it be a problem? And also provide you with external links to blogs or articles to cover the subject. And also, some of the recommendations will provide a recommendation script. This will allow you to run directly from SQL Doctor. In the script that would fix or optimize the problem. It would also provide an undo script. In case you want to backtrack that change. If you wish to do this manually, you can simply flag the recommendation as a to-do item in the future. SQL Doctor can be downloaded from the IDERA website at www.idera.com. Visit our community forum community.idera.com when there is a lot of different users that are ready to answer some of your questions. Thank you, and have a great day.