SQL Counts 1 Workspace

The SQL Counts 1 workspace provides information about SQL DCL (Data Control Language) declarations, SQL DDL (Data Definition Language) statements, and SQL DML (Data Manipulation Language) statements.

This workspace is comprised of the following views:

DML (table view)
Provides information on SQL DML (Data Manipulation Language) statements.
DCL (table view)
Provides information on DCL (Data Control Language) declarations.
DDL Create (table view)
Provides information on SQL DDL (Data Definition Language) statements for Create.
DDL Drop (table view)
Provides information on SQL DDL (Data Definition Language) statements for Drop.
DDL Alter / Rename (table view)
Provides information on SQL DDL (Data Definition Language) statements for Alter / Rename.
Note: Each table view provides the following information:
Information
Description
Total
The total counts since the last sample period.
Delta
The changes since the last sample period.
Rate
The number of requests per second over the last sampling interval.

Based on the information that this workspace provides, you can recommend changes, set up situations, and verify that your recommended changes improve system performance.