Question of the Day Twenty-Five

Let us continue our question of the day series with day twenty-five.

What is the activity monitor in SQL Server?

Activity monitor is a built-in monitor that provides information about the process, resource waits, data file input/output, and recent expensive queries that involve the current instance of SQL Server.  It also gives you a small graphical representation of the monitoring as shown below.



About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on August 27, 2012, in SQL Schoolhouse and tagged . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: