> > Another question would be how does one log number of
> > concurrent users connected to the DB or as a matter of
> > fact to CF server (if someone wants to restrict number
> > of users at a time)? I am using MS SQL 7.0 server, IIS
> > 4.0.
>
> On WinNT, these stats can be determined with the new CF 4.5
> function "GetMetricData()". The full list of things which this
> function can return are:
>
> InstanceName
> PageHits
> ReqQueued
> DBHits
> ReqRunning
> ReqTimedOut
> BytesIn
> BytesOut
> AvgQueueTime
> AvgReqTime
> AvgDBTime
> CachePops
Unfortunately, you can't get either concurrent database users or concurrent
CF users with GetMetricData, or by browsing the performance counters
directly with Performance Monitor or CFSTAT.EXE. You can find out how many
requests are running, and how many are queued, which together can give you a
rough count of how many concurrent users you have at a given time. If you
really want to know how many concurrent users are connected, you can get
that through the counters exposed by IIS, although I haven't a clue how
you'd get to that from within your CF scripts. DBHits simply exposes how
many database queries are executed.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
