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?

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]

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]

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]

>>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.

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

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.

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