Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Interbase Performance

Status
Not open for further replies.
shmo

shmo

IS-IT--Management
Joined
Nov 25, 2002
Messages
18
Location
US
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!


 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Hi,

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
 
Upvote 0 Downvote
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.

 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DBMyself
  • Locked
  • Question Question
Interbase user connection limit
Replies
0
Views
697
DBMyself
DBMyself
RFBCAN
  • Locked
  • Question Question
Recursivity (Interbase).
Replies
0
Views
513
RFBCAN
RFBCAN
Tman60
  • Locked
  • Question Question
Remotely accesing interbase applications
Replies
0
Views
565
Tman60
Tman60
tirf
  • Locked
  • Question Question
help on interbase database
Replies
0
Views
531
tirf
tirf
ale2
  • Locked
  • Question Question
Interbase Server did not start within the expected time_any solution
Replies
0
Views
479
ale2
ale2

Part and Inventory Search

Sponsor

Back
Top