You may want to scan the Collectors from the SQL Collector for Monitor Server module to identify the SELECT, INSERT, UDPATE and DELETE SQL statements with their query plan and trace on (if available). This gives you a better understanding of which SQL statement is causing the performance problem within the database server.
To add Collectors
Select the SQL Collector page.
Select a Collector and click .
Use the Use Database and Set User drop down lists to select the database and user that corresponds with the SQL that you are scanning.
Note: The parameter settings for Problematic, Complex, and Simple SQL statements may differ between SQL Collector for Monitor Server and SQL Scanner modules.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center