Loading the player...

Transcript:

Welcome to Idera Virtual Education Series. This video covers How to Diagnose Queries 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 quickly.

Some queries consume more resources than others. There are some that consume more processors, or memory, or both. SQL Doctor helps you save time by analyzing the most troublesome queries without having to wait for a full analysis to complete.

Simply: Click on Diagnose Queries. Use the Server and Database drop-down lists to select the SQL Server instance and database on which this query either currently runs or runs in the future. Type your query And click Diagnose.

By clicking the Diagnose button, SQL Doctor can run an analysis of that query and provides you with recommendations on the performance of the query without actually executing it.

And that’s how you can diagnose queries in SQL Doctor.

For more information on SQL Doctor, join us in the community at community.idera.com

How to Diagnose Queries in SQL Doctor

Idera SQL Doctor helps DBAs to quickly identify SQL Server performance problems such as queries, server configuration, security, database objects, and much more and provides tuning recommendations for resolving those problems. What would normally take a DBA hours – collecting performance information, analyzing it, and determining the resolution – can be accomplished by SQL Doctor in minutes! SQL Doctor helps you save time by analyzing the most troublesome queries without having to wait for a full analysis to complete. By simply click a button, SQL Doctor is able to run an analysis on your specific query and provides you with recommendations on the performance of the query without actually executing it. SQL Doctor is able to provide executable scripts of the recommendations that can be reviewed and implemented right away directly from the GUI. Learn More →

Start a FREE Trial of SQL Doctor
Share This
Contact IDERA:
Call toll-free in North America
1-877-464-3372
Call International
+1-713-523-4433