Manage Learn to apply best practices and optimize your operations.

Freebie: Enterprise Manager's Current Activity

Familiarize yourself one of Enterprise Manager's performance monitoring freebies: Current Activity.

You may already be working with the usual suspects for performance tuning tools, but are you using all the features available in each tool? The following is one of several must-have free tools, or go to the complete list of freebies.

  1. Enterprise Manager's Current Activity  Return to Complete List

SQL Server Enterprise Manager is the first tool most database administrators and developers use to manage SQL Server. However, I have found that most people familiar with the tool are not aware of one of its performance monitoring freebies: Current Activity.

Three views can be found by navigating to Server, then Management and finally Current Activity. These views are: Process Info, Locks/Process ID and Locks/Object. The screen shot below is from the Process Info view offering CPU, Physical I/O and Memory statistics per process, so the specific processes can be researched by double clicking on the line for the underlying T-SQL command.

One caveat is that all of these views are a snapshot. To obtain accurate data, right click on Current Activity, select Refresh and validate that the timestamp to the right of Current Activity updates.

Click for the next featured freebie: SQL Server Profiler

About the author: Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also the Performance Tuning expert. Ask him a question here.

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.