Users, Applications and DBs Using SQL Server Now?

To verify who and what applications are hitting which databases on your MS SQL Server now:

  • Open SSMS and connect to the desired SQL instance

  • Right-click the instance name → New Query

  • Copy and paste the code below on the right panel:

SELECT HostName, Loginame, Login_Time, Program_Name, DB_NAME(dbid) [DB_Name], right(convert(varchar, dateadd(ms, datediff(ms, last_batch, getdate()), '1900-01-01'), 121), 12) as 'Duration', CPU as CPU_Time, Status, Cmd, SpID FROM master.dbo.sysprocesses WHERE spid > 50 AND status not in ('background', 'sleeping') -- AND Loginame LIKE '%UserName%' -- <--- Filter by Username ORDER BY Duration DESC
  • Click Execute of F5 (multiple times as needed).




Keywords: Query, Queries, Performance, MS SQL Server, Doing Now, Frozen