Show currently runnig queries on server SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
Selected Database index stats ordered by fragmentation percent use yourdatabase SELECT OBJECT_SCHEMA_NAME ( OBJECT_ID ) as schema_name, OBJECT_NAME(OBJECT_ID) as table_name, index_id, index_type_desc, index_level, avg_fragmentation_in_percent, avg_page_space_used_in_percent, page_count FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) ORDER BY avg_fragmentation_in_percent DESC