Transcript

Expand

Welcome to IDERA virtual education. This video covers how to generate corrective scripts in SQL Doctor. SQL Doctor helps DBAs to quickly find SQL Server performance problems and provide detailed recommendations as well as dynamically generated scripts to help resolve those problems. SQL Doctor generates scripts for many of the performance recommendations that can be executed immediately against the server to perform remediation. These scripts can be reviewed and implemented directly from the GUI [graphical user interface]. By dynamically creating the script, SQL Doctor makes it easy for you to execute this change, improving the overall performance of your server. The Optimize Now window displays the script that used to enact the recommended change. Review the script, and then either click the Run button to initiate the optimization or click Cancel to return to the recommendation you were viewing. The Undo Optimization window displays the script that is used to enact the recommended change. Review the script and either click the Run button to initiate the undo or click Cancel to return to the recommendation you were viewing. The undo script can also be copied to clipboard and used at a later time. And that’s how you can generate corrective scripts in SQL Doctor. For more information on SQL Doctor, join us in the community at community.idera.com

Topics : Database Diagnostics,Database Performance,

Products : SQL Doctor,

How to Generate Corrective Scripts in SQL Doctor

Idera SQL Doctor helps database administrators to quickly identify SQL server performance problems such as queries, server configuration, security, database objects, and it provides tuning recommendations for resolving those problems. SQL Doctor can finish collecting and analyzing performance information and determine a specific resolution in minutes, whereas it would usually take DBAs hours to accomplish those tasks.

SQL Doctor helps DBAs save time by analyzing the most troublesome queries without having to wait for a full analysis to complete. By simply clicking a button, SQL Doctor is able to run an analysis on a specific query and provide recommendations on the performance of that query without actually executing it. SQL Doctor is also able to provide executable scripts of the recommendations that can be reviewed and implemented right away directly from its GUI. Learn More →

facebook  
Contact IDERA: