Well it seems like there is no easy way of monitoring Intralink user
activities in real time although it seems possible to gather the
information from some Oracle files or sql commands.

Thanks to those that replied.

Mark Dolata
CenterLine (Windsor) Ltd.

---------------------------------------------------
Original Question:

Are there any tools or utilities that can be used to monitor or check for
the current activities on an Intralink server?  Sometimes we get users who
do very vague large searches or delete very large family tables and bog the
server down so I would like to find out who is performing these actions.
Right now all I can see with Windows Task Manager is the Oracle process
using a lot of CPU.  I would like to be able to see who is doing what
inside the Intralink server.  We are running Intralink 2.0 build 2000470 on
Windows NT 4.0 with SP6a.

---------------------------------------------------

Replies:
-------

you might try FreeMeter

---------------------------------------------------

Instead of trying to catch the culprit, why don't you upgrade to 3.2 and
simply speed up the system?

---------------------------------------------------
Do it the old fashioned way - reboot the server in the midst
of it and see who calls :> And, if you haven't heard of it,
look up "BOFH" on Google. There are a lot of hints for dealing
with wayward users.

Actually I only wish I knew what went on in the server.
We have just one admin and he refuses to share any information
with anyone. So, if he were to be hit by a truck, say accidentally,
... well, time will tell.
---------------------------------------------------

Check out the performance monitor.

On WinNT it's under Programs > Administrative Tools.

With this tool you can also graph multiple machines at the same time.
I use it to monitor data server and 3 file servers.

---------------------------------------------------

I am on the same build of Intralink.
What I do is monitor the trace files that the server creates when a user
ends task on the Intralink client. When this happens the dataserver will
not
continue to do any Intralink activities until the trace file is completed.
this will make other people end task, it almost becomes a domino effect.

the user information is in the trace file. I search for my company name in
the trace file and that line  has the user info who ended task on the
client.

the trace files are in the dataserver loadpoint\RDBMS73\TRACE  example:
d:\dataserver\RDBMS73\TRACE

---------------------------------------------------

If you want to now what they are doing, then you can look in
the Oracle tables for the username and/or timestamps.  If I
remember correctly, there are some special tables (not used
by Intralink) that contain recent sql commands run by the
client.  You might be able to decipher these to find out what
the users are doing.

---------------------------------------------------

Use the performance monitor on your server. When the Oracle.exe process is
monitored and sits at 100%, you know some user is  checking out beyond the
Intralink capacity to keep up with it. You need to try to find out what
that
person is doing and simplify the search or checkout. My opinion only from
experience.