Get maximum usage reports for your databases. Select an Instance, a Database, a Report and the number of rows to return (5, 10, 20, 50 or 100 rows). Reports are:
Top Applications by Sort Time: Lists applications with the greatest wait and sort times. Includes User IDs, number of sorts and wait time.
Top Lock Waits by Application: Lists applications with the most lock waits.
Top Queries Against Package Cache: Lists statements with the greatest number of executions against a package cache. Includes wait and total times.
Top Queries by Execution Time: Lists queries with the greatest execution times. Includes elapsed time, AUTH_ID, AGENT_ID and SQL_TEXT.
Top Tables by Index Use: Lists tables containing the most used indexes. Includes Schema, #Leaf Nodes, Nlevels, Index Scans, Key Updates and Page Splits.
Top Tables by Rows Selected: Lists tables containing the most selected rows. Includes Schema, Table Scans, Rows Read, Inserted and Deleted.
Top Consuming Transactions: Lists applications executing transactions that require the greatest CPU use. Includes App Handles, User IDs, wait time, request time, CPU time and client wait time.
Sort reports by any of its columns.
