SQL Activity Monitor

Connect SQL Server using Microsoft SQL Sever Management Studio.  Right click and select Activity Monitor.

activity monitor

 

Here you can view monitor Processes, Resource Waits, Data File I/O, and Recent Expensive Queries.  To kill process, select a Session ID.  Usually, I would eye on Database and Host Name (processed is being used by) and right click and select Kill Process.

process is being used by

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s