Banco de Dados (restaurando / restoring)
RESTORE DATABASE [database_name] WITH RECOVERY Referencia: https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/...
Categoria: SqlServer
SQLServer liberar memoria/cache
DBCC DROPCLEANBUFFERSDBCC FREEPROCCACHE...
lock
SELECT session_id, wait_duration_ms, wait_type, blocking_session_id FROM sys.dm_os_waiting_tasks WHERE blocking_session_id <> 0...
trace
SELECT sqltext.TEXT,req.session_id,req.status,req.command,req.cpu_time,req.total_elapsed_time,start_time,right(convert(varchar,dateadd(ms, datediff(ms, start_time, getdate()), ‘1900-01-01’),121), 12) as ‘batch_duration1’,wait_timeFROM sys.dm_exec_requests reqCROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext...