Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
Previously fast EDB suddenly very slow |
Tue, Nov 15 2011 6:30 AM | Permanent Link |
Adam Brett Orixa Systems | I have a small LAN, with only 4 client PCs running EDB. It has always been lovely & quick. Suddenly it is taking 13+ seconds to open a simple
SELECT * FROM SomeTable WHERE ID = 1234 query. Previously such a query executed almost instantly. I'm pretty sure something network-ish is to blame, but I can't see anything that has changed! No Firewall / Anti-virus is in place or has been added. ... how can I check where the bottleneck is in this process? Is there an application I can run to test which parts of the process are slow? |
Tue, Nov 15 2011 7:12 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
>I have a small LAN, with only 4 client PCs running EDB. It has always been lovely & quick. Suddenly it is taking 13+ seconds to open a simple > >SELECT * FROM SomeTable WHERE ID = 1234 > >query. Previously such a query executed almost instantly. > >I'm pretty sure something network-ish is to blame, but I can't see anything that has changed! No Firewall / Anti-virus is in place or has been added. > > ... how can I check where the bottleneck is in this process? Is there an application I can run to test which parts of the process are slow? If you're running c/s there should either be a log or you can ask the server to create one. Don't ask me where cos I'm f/s However, my first thought would be repair the table, making sure the index files are regenerated. Four questions: 1. you mention 4 PCs - is one of those the server? 2. is this f/s or c/s? 3. is the 13 seconds on all PCs or just one? 4. what happens if you try the query in single user mode from the server? Roy Lambert [Team Elevate] |
Tue, Nov 15 2011 12:31 PM | Permanent Link |
Adam Brett Orixa Systems | Thanks for the speedy response Roy!
>>1. you mention 4 PCs - is one of those the server? No. >>2. is this f/s or c/s? All c/s, I will try accessing f/s & report back >>3. is the 13 seconds on all PCs or just one? All of them (which makes me think the problem is with the network). >>4. what happens if you try the query in single user mode from the server? Reasonably quick. -- OK: It is tricky to actually get to this server, so I hadn't actually gone to it & logged on until this point. It is a Windows 7 machine which is more or less just used for EDB (plus some file-sharing). Once I got to the I found it was virtually out of memory & was really running super slow. A set of Windows updates had just been installed, but the computer had not been restarted ... so there were 42 separate windows update elements pending (!) now I have restarted with all those pending updates installed the system is running OK again. I think probably all I needed to do was switch it off & on again ... sorry -- HOWEVER: I could really use a remote tool that allowed me to check on the performance of the server from another machine on the LAN, does anyone know of one? Its bloody slow too. Roy Lambert [Team Elevate] |
Wed, Nov 16 2011 3:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
>I think probably all I needed to do was switch it off & on again ... sorry I think MS should apologise to all of us rather than you apologising here. >HOWEVER: I could really use a remote tool that allowed me to check on the performance of the server from another machine on the LAN, does anyone know of one? No - but I'm interested to! >Its bloody slow too. What is? Roy Lambert [Team Elevate] |
Wed, Nov 16 2011 4:23 AM | Permanent Link |
Adam Brett Orixa Systems | >>Its bloody slow too.
>What is? >Roy Lambert [Team Elevate] ... posted accidentally early ... my mega MS Windows update on my server has taken me about 8 hours so far, of staring at the "Please do not power off or unplug your machine Installing update XX of YY" I think because the servers memory is jammed solid with updates (2 gig worth!) it is having a hard time doing the install/update. This is a real lesson for me: As the server was only running EDB I never bothered to switch it off, EDB never needed it. However I forgot about regular Windows updates & the fact that these often need a restart. I think I'm probably installing at least 1 major MS service pack pus who knows what else ... and all the while my server is off-line From now on I'll build in a weekly restart to the server ... so this never happens again. |
Wed, Nov 16 2011 4:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
If its not being used to connect to the outside world (apart from EDB) I'd suggest disabling Windows Update - most of the stuff is security patches which won't apply to what the server is doing or wonderful things like a dictionary update that need a quarter gig download. Roy Lambert |
Wed, Nov 16 2011 4:07 PM | Permanent Link |
Adam Brett Orixa Systems | You're right Roy, most of the updates are probably useless ... but I think its probably safer to enable them & get the useful ones, even if they are few & far between.
|
Thu, Nov 17 2011 4:13 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
>You're right Roy, most of the updates are probably useless ... but I think its probably safer to enable them & get the useful ones, even if they are few & far between. I must disagree. Some Windows updates screw up the system so its unusable! Roy Lambert |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |