Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

How do you tell what SQL Server is doing?

Contents
  1. How do you see what SQL Server is doing?
  2. How do I know if SQL Server is running SQL?
An even simpler approach in many cases is to have a look at SQL Activity Monitor (or execute sp_who2) when you're in one of these periods of 100 .


How do you see what SQL Server is doing?

From the Standard toolbar, select the Activity Monitor icon. It is in the middle, just to the right of the undo/redo buttons. Complete the Connect to Server dialog box if you are not already connected to an instance of SQL Server you want to monitor.

How do I know if SQL Server is running SQL?

As a note, the SQL Server Activity Monitor for SQL Server 2008 can be found by right clicking your current server and going to "Activity Monitor" in the context menu. I found this was easiest way to kill processes if you are using the SQL Server Management Studio. Show activity on this post.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours