Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Diagnosing Slow Interbase Performance - XE3 64 Bit


This question is answered.


Permlink Replies: 1 - Last Post: Oct 17, 2016 10:35 AM Last Post By: Jeff Overcash (...
Jeff Cope

Posts: 88
Registered: 1/27/01
Diagnosing Slow Interbase Performance - XE3 64 Bit  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 17, 2016 5:17 AM
We have a customer that has been experiencing extremely slow performance with Interbase. We are inclined to think it has something to do with their setup rather than an issue with Interbase itself. Some of our other customers with similar sized databases do not have any performance issues and we cannot duplicate it in-house.

We've analyzed our queries and everything is optimized.

What would be the best way to go about proving this is a hardware/setup issue rather than Interbase itself? Is there a way to use performance monitor to show slow disk access?
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Diagnosing Slow Interbase Performance - XE3 64 Bit
Correct
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 17, 2016 10:35 AM   in response to: Jeff Cope in response to: Jeff Cope
Jeff Cope wrote:
We have a customer that has been experiencing extremely slow performance with Interbase. We are inclined to think it has something to do with their setup rather than an issue with Interbase itself. Some of our other customers with similar sized databases do not have any performance issues and we cannot duplicate it in-house.

We've analyzed our queries and everything is optimized.

What would be the best way to go about proving this is a hardware/setup issue rather than Interbase itself? Is there a way to use performance monitor to show slow disk access?

I use a freeware bench32 to benchmark disk throughput. It can do both buffered
and direct io benchmarking.

https://www.techpowerup.com/downloads/1749/atto-disk-benchmark-v2-46

If it is a gradual slowdown start with the usual culprit, look for long running
transactions on the transactions page of the performance monitor.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02