The SQL activity refers to the actions and interactions involving Structured Query Language (SQL) within a database's system or application. Wait statistics refer to a collection of data and metrics that provide insights into the various types of waits or delays experienced by SQL queries and transactions while they are executing in a database management system (DBMS). In Wait Statistics, you can see the following information in graphical representation which are listed below:

• Preemptive: This is the time spent waiting for CPU resources to become available after a thread or task has been temporarily paused by the operating system's scheduler.
• Compilation: This refers to a specific type of wait event that occurs when an SQL query is being compiled for execution by the database management system (DBMS).
• User Wait: This refers to the type of wait event in a database management system (DBMS) where a database session is waiting for a resource or event to become available before it can continue its execution.
• Idle: This refers to the wait event that occurs when a database session is in an idle or inactive state, not actively engaged in any database activity.
• Memory: This refers to a wait event that occurs when a database session is waiting for access to or the allocation of memory resources.
• Tran Log IO: This refers to a specific type of wait event that occurs when a database transaction is waiting for input or output operations related to the transaction log of the database.
• Network IO: This refers to a type of wait event that occurs when a database session is waiting for input/output (I/O) operations to be completed over a network connection.
• CPU: This refers to the wait event that occurs when a database session is waiting for access to the Central Processing Unit (CPU) of the server on which the DBMS is running.
• Buffer Latch: This refers to the type of wait event that occurs when a database session is waiting to acquire a latch on a data page in the buffer cache.
• Buffer IO: This refers to the type of wait event that occurs when a database session is waiting for input/output (I/O) operations to read or write data pages in the database buffer cache.
• Lock: This refers to the type of wait event that occurs when a database session is waiting to acquire a lock on a resource, such as: database table, row or page.
• Other: This refers to serving as a catch-all category for wait events that do not fit into standardized categories.
• Tracking: This refers to the process of monitoring and recording wait events within a database management system (DBMS).