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

Hello Here is my setup I am using IBM Netapp and SQL Server 2005

I have two servers my primary is connected to the san and acts as a principle...