Interbase Performance
Interbase Performance
(OP)
I have an issue with our server pegging from time to time. I have Interbase 5.6. I'm not sure if it is a bad query or process. Does anyone here know of any tools available to monitor logins and their activities so that I can pinpoint the problem.
Your help will be greatly appreciated. Thanks!
Your help will be greatly appreciated. Thanks!
RE: Interbase Performance
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
RE: Interbase Performance
To trace what is causing the cpu to peg is seemingly impossible. I have turned off one thing at a time to see but it does not seem to pin point the problem.
I was wondering if you knew of any utilities or tools to see which user is using up the cpu. Services only shows ibserver as the culprit.
Thanks for your response and appreciate any info.
RE: Interbase Performance
No, you cannot see what seperate users/connections are doing with your IB server...
Version 7 (just announced at borland.com) is able to do this - perhaps it's time to upgrade?
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
RE: Interbase Performance
I appreciate the effort. Version 7 has this capability? Sweet. I better get started on a test environment. Version conflicts maybe a whole can of worms. Thanks again.
RE: Interbase Performance
I have a regular desktop PC with Windows 2000, 128 MB, Pentium 3. The database was initially empty.
If you have any idea about what is the possible cause of the problem, please let me know.
RE: Interbase Performance
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.upscene.com