Hi All,

Sorry for a really weird problem.

I have a DB-heavy business application running at a client's offices. Mid-day Wednesday all operations on the application slowed down by a factor of about 100.

I have done a lot of work trying to figure out why this might happen.
* Cleaned up the server.
* Switched off controls like anti-virus & firewall in case updates to these had caused issues.
* Repaired the Db.
* Reinstalled from an earlier backup of the Db.
* Run with earlier versions of the EXE.

... the error persists.

I have now set up a totally new server machine as a test, with the Db and EXE and it is displaying the same slow behaviour.

Anyone with similar experiences or ideas as to what may have happened??

I am running EDB 2.14

Have you checked your network cable or network card?

Do any of the following commands reveal anything?
select * from configuration.serversessions;
select * from configuration.serversessionlocks;
select * from configuration.logevents;
select * from configuration.serversessionstatistics

It would be ideal if we had a background program collecting this information so it could be plotted so we can see the demand on the server over time. Monyog has done this for MySQL.

Barry

Adam Brett wrote:
<<
I have a DB-heavy business application running at a client's offices. Mid-day Wednesday all operations on the application slowed down by a factor of about 100.

I have done a lot of work trying to figure out why this might happen.
* Cleaned up the server.
* Switched off controls like anti-virus & firewall in case updates to these had caused issues.
* Repaired the Db.
* Reinstalled from an earlier backup of the Db.
* Run with earlier versions of the EXE.

... the error persists.
>>

Is there an actual error or is it just slow ?

Obvious question is whether anything has changed - software/hardware/windows patches? AntiVirus is always a prime suspect.

Have you been able to determine where the slowdown is coming from - server side or something else. On client side there is a OnRemoteTrace event i the session component if you want to trace the traffic coming/going.

Bad hardware does not seem to be the case since you had the same issue on different server but is there anything in the event logs.

Are the OS and other aspects same with the servers like windows patching.

Raul

Adam,

<< I have now set up a totally new server machine as a test, with the Db and
EXE and it is displaying the same slow behaviour. >>

Without any changes to any of the .exes involved, such a slowdown can only
be caused by an environmental issue in some way.

However, if you can reproduce the behavior, then feel free to send me the
setup/database via email and I'll see if I can reproduce it here.

Tim Young
Elevate Software
www.elevatesoft.com