Re: Counting SQL net connections, tracking logins

Refer to the Zero Impact Sql Monitor at www.sqlpower.com

The product line non-intrusively analyzes the SQL network packet flow to the database server for end-user SQL and service level performance monitoring. The product does NOT have to run on the database server, NOR on client workstations connected to the server.

The products require NO intrusive database server monitors, agents, probes, audits, middleware or proxy servers. NO agents are installed on end user workstations.

The products require NO impact upon the database servers, network or end-users. The products require no connections to the database server and end-users connect directly to the database server (not the monitor). Product installation is a three step process that can be completed in a few minutes.

Mark S. Reichman wrote in message <380cad58.0_at_nntp2.borg.com>...
>Is there away to determine the number of open
>live SQL Net connections by querying a table?
>Can any user do this or only DBAs?
>
>If I am serving up Web Enabled Forms, is there a
>way to determine who is logged in and
>using my forms? I do have a table where I
>insert a record with login name,IP and date everytime
>the first page is accessed. However, I have no
>idea when and if folks are still logged in to the
>Web Server at any given time, or do I?
>
Received on Wed Oct 20 1999 - 07:14:57 CDT