Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Interbase Performance

Interbase Performance

Interbase Performance

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!

RE: Interbase Performance

What do you mean - "pegging" - getting slow? Can you send the "gfix" statistics for transaction counters (Check the "operations guide" for information). It might indicate a problem there...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

RE: Interbase Performance

Sorry, "pegging" meaning the cpu usage is at 100% in the performance monitor on NT and "getting slow".  I have ibreplicator pulling data on another server, I have a telephony system and a  web based reporting tool running queries, and 150 clients doing updates and inserts.  

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

RE: Interbase Performance

Thanks MartijnTonies!
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 similar problem with the performance of Interbase 6.5. I repeatedly (every 3 seconds) start and commit a transaction. Every transaction creates about 100 records and updates about 40. The performance of the Interbase degradates with time. After having commited over 700 transactions, the system is effectively dead. Interbase consumes 100% of the CPU time.
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

What are your transaction statistics? Use gfix to check them...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close