LiteSpeed 2005 allows you to monitor current activity on a SQL server in much the same way as Microsoft� SQL Enterprise Manager, by reviewing activity in the LiteSpeed 2005 Current Activity window.
In the Enterprise Console do one of the following:
- Select (click on) the server of interest and choose main menu View | Current Activity. - Right-click on the server of interest and from the context menu choose Current Activity.
This allows you to do the following:
- View current processes and process information - View current locks and lock information - Kill a process - View last command batch for a connection - Send a message to a currently connected user
For more information, refer to SQL Server Books Online: "Administering SQL Server", "Monitoring Server Performance and Activity", and "Monitoring with SQL Server Enterprise Manager".
