Geek Answers Handbook

Is there a task manager for SQL Server 2008 onwards?

Is there a task manager for SQL Server 2008 onwards? A way to see what the SQL server is doing, kill runaway queries, etc.

+5
source share
4 answers
select * 
from sys.sysprocesses

Should show running processes. Killing tasks is

KILL <task>

Team

Note that this view ( master.dbo.sysprocesses) is a backward compatible view, so it may not be here in future releases of SQL

+7
source

Activity Monitor: How to open Activity Monitor (SQL Server Management Studio) :

Activity Monitor SQL Server SQL Server.

- , : , , , - . - , Activity Monitor . , . .

, , , - "" :

  • , .
  • , .
  • , , .

SQL Server 2005 SQL Server 2008, .

SQL 2000 Server, SELECT sysprocesses syslocks . .

, sysadmin processadmin .

+6

Management Studio .

+3

, , , . - , , .

Go to Server Manager-> Diagnostics-> Performance. Double-click "Performance", and a sub-screen appears with a blue hyperlink that reads "Open Resource Monitor". This has the same functionality as the task manager.

0
source

More articles:


All Articles