Viewing Detailed Process Activity
The day will come when your phone is ringing off the hook because suddenly the system is slow or a user has been waiting a very long time for a report to complete. With SQL Server 2000, you can easily view the current activity of the system using the Current Activity dialog box (refer to Figure 15.8). To view detailed information on an executing process, select the process in which you wish to view the information from the current activity view (refer to Fig 15.8) with a single mouse click, and then right-click and select the Properties option. The Process Information dialog box of the Current Activity dialog box appears (see Figure 15.9).
Figure 15.9. The Process Information dialog box.
The Process Information ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
