sp_monitor, @@connections, etc...

[susanl.]

What is the best way to check the number of connections at
an existing point and time?

Below are a few commands I though about using:

sp_monitor

select @@connections

But wanted to make sure there wasn't a better way.

Our goal is to confirm that we are not running out of
connections during a certain point and timeframe.

Thanx,

Susan

[Rob V [Sybase]]

If you mean the number of active connections, then run sp_who.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

<Susan L.> wrote in message news:49df4c00.71c...@sybase.com...

[Sherlock, Kevin [TeamSybase]]

select count(*) from master..sysprocesses where fid = 0

or

sp_monitorconfig 'number of user connections'

<Susan L.> wrote in message news:49df4c00.71c...@sybase.com...