Return
-
Title
What is available to analyze SQL Performance? -
Description
What is available to analyze SQL Performance? For example, server is running at 100% CPU and would like to see if there are resource intensive SQL statements causing the issue. -
Resolution
'Find SQL' helps you locate the most resource-intensive SQL in your server. It evaluates existing SQL performance by different statistics (such as CPU time and elapsed time) from different areas (such as batches and database objects).
For more information and a tutorial on how to use this feature, please review the 'Find SQL' chapter in the Help.
For additional information on how to locate problem SQL from Plan Cache in SQL Server, please review this Toad World article