Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If Interpoint is installed (for SAP, PeopleSoft, Siebel or COM+), the duration and average duration fields have no significant meaning and can be ignored.

Anchor
AboutSessionStates
AboutSessionStates
About session states

SQL Server provides reporting on many different types of events. Precise for SQL Server groups events according to logical relationships to enable you to easily pinpoint heavy resource consumers.

...

IconStateDescription
Request Wait

The session is waiting for the client to issue a request.

A high value can indicate that a connection pool is too large and that many connections have been left open and are not active.

Parallel Exchange WaitThe thread in a parallel session is waiting for data exchange from another thread.
IdleIndicates that the session is waiting for something other than a user request or is executing the WAITFOR DELAY command.

Anchor
AboutStatementIdentifiers
AboutStatementIdentifiers
About Statement identifiers

Each statement is identified by the following parameters:

...