Subject Re: [firebird-support] Who's guilty?
Author Marcin Medelski-Guz
Windows. SS. Originally IB 5.6, then converted to IB 6.0.
100+ users is a total - it's 5 IB-server WAN system connected by a self-made 2-way replication system.
Running for 3 years now,
The sustem is busy 6 days a week from 6:00 am to 22:00 pm, which basicly means that a backup/restore requires staying the night or sacryfying a weekend. :-)

----- Original Message -----
From: Alan McDonald
Sent: Monday, December 01, 2003 11:15 PM
Subject: RE: [firebird-support] Who's guilty?

> I'm running a quite big (over 1GB) database. There are several
> programs and more than 100 users connected to that DB.
> My problem is the database started to work really, really slow (%
> processor usage maxed out throughout the day)
> This obviously looks like an unoptimized query got through to one of
> the client programs (I am doing a large refactoring of the programs
> recently)
> My question is: are there any ways to identify what user or query is
> hammering an Interbase DB down? I mean *anything* that could give
> even a slightest trace. Users are totally upset with the performance
> and I'm stuck. Help! :-)))
> Thanks,
> Marcin

100+ simultaneous connections, no middleware... I would have thought this is
testing the limits anyway.. is it win or *nix? is it SS or classic?


Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]