Server uzerindeki sessionlar ve db uzerindeki processes islemler
Definition Description
SELECT * FROM sys.dm_exec_sessions WHERE host_name IS NOT NULL
SELECT hostname,program_name,[status],waittime as waittimeMS,memusage as MemNumOfPage,open_tran, loginame,net_address,memusage,DATEDIFF(n, login_time, GETDATE()) AS SessionTime FROM master.dbo.sysprocesses WITH (nolock) WHERE dbid =5 --AND [program_name] NOT LIKE '%NebimV3POS%' ORDER BY SessionTime DESC