Total active Connections  
Author Message
nofear451-techie





PostPosted: Wed Nov 23 00:37:02 CST 2005 Top

SQL Server >> Total active Connections

Hi:

How can you quickly find out Total Active Connections per database?

Thanks

SQL Server117  
 
 
peter





PostPosted: Wed Nov 23 00:37:02 CST 2005 Top

SQL Server >> Total active Connections Mike

The TSQL script below will list the number of database connections per
database:

SELECT DB_NAME(dbid), COUNT(*) AS Connections
FROM master.dbo.sysprocesses
GROUP BY dbid


- Peter Ward
WARDY IT Solutions




> Hi:
>
> How can you quickly find out Total Active Connections per database?
>
> Thanks
 
 
Mike





PostPosted: Wed Nov 23 05:21:09 CST 2005 Top

SQL Server >> Total active Connections Thanks



> Mike
>
> The TSQL script below will list the number of database connections per
> database:
>
> SELECT DB_NAME(dbid), COUNT(*) AS Connections
> FROM master.dbo.sysprocesses
> GROUP BY dbid
>
>
> - Peter Ward
> WARDY IT Solutions
>
>

>
> > Hi:
> >
> > How can you quickly find out Total Active Connections per database?
> >
> > Thanks