Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Weird application slow down |
Fri, Jan 31 2014 4:31 AM | Permanent Link |
Adam Brett Orixa Systems | 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 |
Fri, Jan 31 2014 11:07 AM | Permanent Link |
Barry | 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 |
Fri, Jan 31 2014 1:09 PM | Permanent Link |
Raul Team Elevate | 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 |
Fri, Jan 31 2014 6:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |