Hello
Im looking for a way, where i can see detailed statistics, how many transactions,read,write,modify,transactions concurrent Users and so on, a Database has.
does anyone know a tool or something were i can trace the traffic?
The default database usage logs and catalog info is way to unaccurate for that what i need.
thanks
kind regards
Tibor
Subject: Not a whistles and bells tool, but a way to accomplish what you want …
We have done exactly that by setting environment variables eg. $dbname.formname.read on each read and so on for all the events you want to follow. Then when closing the document we check the environment vars again, and create a small log document in a separate database (along with userinfo, machineinfo, serverinfo and what not). Log database then replicates to central hub where an agent moves the log documents to a statistics database (which doesn’t replicate, as this is growing at a tremendous speed). All this data makes us capable of counting users on the system, how many documents has been created, how often documents are read by other users etc etc etc)
It is of course some work settting it up, but its the same for all applications/databases, and you can concentrate on the most interesting document types (forms)
Subject: Activity Logging/Trends
I think Activity Logging will provide the level of detail you’re seeking, particularly Notes.Session Logging. Check out the “Notes session activity logging” Topic in the Lotus Administrator Help Database.