Tuesday, December 4, 2007

How to check on current activity

How to check on current activity

Step 1

To check on current activity in MSSQL server, go to Enterprise Manager nad select Management

An example of the layout is illustrated below:

From here, user can get information on current activity that is related to Processes, Lock/Process ID and Lock Objects.

To view more information on it just clicks on each of the component here.

No comments: