mssql – open sessions (select)

CREATE TABLE #sp_who2 
(
   SPID			INT,  
   Status		VARCHAR(1000)	NULL,  
   Login		SYSNAME			NULL,  
   HostName		SYSNAME			NULL,  
   BlkBy		SYSNAME			NULL,  
   DBName		SYSNAME			NULL,  
   Command		VARCHAR(1000)	NULL,  
   CPUTime		INT				NULL,  
   DiskIO		INT				NULL,  
   LastBatch	VARCHAR(1000)	NULL,  
   ProgramName	VARCHAR(1000)	NULL,  
   SPID2		INT,  
   REQUESTID	INT
) 
GO

INSERT INTO #sp_who2
  EXEC sp_who2
GO

--SELECT	*
--  FROM	#sp_who2
--  WHERE dbname like '%VCENTER%'
--GO

select dbname,count(*)
  from #sp_who2
  group by dbname
  order by 1 desc