Here is the query you are looking for

SELECT DB_NAME(dbid) as 'Database Name',

COUNT(dbid) as 'Total Connections'

FROM master.dbo.sysprocesses WITH (nolock)

WHERE dbid > 0

GROUP BY dbid