Administering SQL Server
Sessions Event Classes
The following table describes the Sessions event classes in the Sessions event category.
| Event class | Description |
|---|---|
| ExistingConnection | Detects activity by all users connected to Microsoft® SQL Server™ before the trace was started. |
Using the ExistingConnection event classes, it is possible to monitor the length of time each user connection was connected to an instance of SQL Server, and the amount of SQL Server processor time the queries submitted on the connection took to execute. This information can be useful for determining:
- The amount of time and the volume of activity used by each SQL Server user. This can be useful for tracking database activity and charging each user for the time and SQL Server CPU time (CPU data column) used.
- The security of the system, by checking the users connecting to and using an instance of SQL Server.