Current Process

Active Sessions

Kill Sessions

Blocking Sessions

SELECT *

  FROM sys.dm_exec_requests

 WHERE blocking_session_id <> 0;

GO

Last Activity

DECLARE @last_boot DATETIME

SET @last_boot = (SELECT[sqlserver_start_time] FROM sys.dm_os_sys_info)

SELECT @@servername AS [ServerName],

       'last_boot' = @last_boot,

       'days_since_last_boot' = DATEDIFF(d, @last_boot, getdate())

IF OBJECT_ID('tempdb..##Table_usage_data') IS NOT NULL

   DROP TABLE ##Table_usage_data

CREATE TABLE ##Table_usage_data (ID int identity (1,1),

                                 [database] VARCHAR(255),

                                 [last_user_seek] DATETIME,

                                 [last_user_scan] DATETIME,

                                 [last_update] DATETIME)

DECLARE @get_last_user_activity_timestamp VARCHAR(MAX)

SET @get_last_user_activity_timestamp = '' SELECT @get_last_user_activity_timestamp = @get_last_user_activity_timestamp + 'SELECT db_name([database_id]), MAX(last_user_seek), MAX(last_user_scan), MAX([last_user_update]) FROM sys.dm_db_index_usage_stats WHERE DB_NAME([database_id]) = ''' + [name] + ''' GROUP BY [database_id];' + CHAR(10) FROM sys.databases WHERE [database_id] > 4 AND [state_desc] = 'online'

INSERT INTO ##Table_usage_data ([database],

                                [last_user_seek],

                                [last_user_scan],

                                [last_update])

  EXEC (@get_last_user_activity_timestamp)

SELECT [database],

       last_user_scan,

       last_user_seek,

       last_update

  FROM ##Table_usage_data 

Bibliography