SQLBase 7.5.1 analyze process

[jipsi]

Hello

We have a base with 40 users who works together.
Sometime a user use all the power of the processor, but we don't know which it is. The consequence is time-out for the other users.
Is some program exist to analyze how all the cursors occupe the SQLBase engine?

regard's

jipsi

 

[willdancer]

WE HAVE RECENTLY EXPERIENCED THE SAME PROBLEM. THERE IS A PROGRAM ON YOUR SQLBASE INSTALLATION CD CALLED "SQL CONSOLE" BY INSTALLING THIS CONSOLE TO YOUR DESK TOP YOU CAN DETECT "X-LOCKS" ON YOUR SYSTEM AND IDENTIFY THE USER CAUSING THE PROBLEM. WE FOUND THAT ONE OF OUR USERS WAS LEAVING A REPORT OPEN ON THEIR CLIENT. THIS CAUSED THE LOCK. ONCE WE MADE THEM AWARE OF THE PROBLEM AND THEY PRINTED THE REPORT THEN CLOSED IT, THE LOCKS CEASED. IF YOU HAVE PROBLEMS INSTALLING THE SQL CONSOLE, CONTACT CENTURA SOFTWARE VIA THE INTERNET.