 <p>Right click the server name and choose Activity Montior.</p> <p>Alternatively, you can query the process list with:</p> <pre><code>select * from sys.dm_exec_requests </code></pre> <p>An even better solution is <a href="http://sqlblog.com/files/default.aspx" rel="nofollow"><code>sp_WhoIsActive</code></a> from Adam Machanic, but that might be overkill for your situation.</p>