Re: Access Database Application has began running slow on Workstations.
From: Henry Craven [SBS-MVP] (IUnknown_at_Dot.Nyet)
Date: 02/15/05
- Next message: Merv Porter [SBS-MVP]: "Re: Forwarding Mail with Unresolved Recipients in Exch2000"
- Previous message: Henry Craven [SBS-MVP]: "Re: Administrator.[server name].001"
- In reply to: Doug B -db-: "Re: Access Database Application has began running slow on Workstations."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 14:13:21 +1100
Unlike SQL Server where you can run Stored Procedures and Triggers on
the Server, the actual processing in MS Access is done on the front end,
so that is where the Processor Load is. The server is just Data Serving.
Depending upon how well (or badly) the app has been written, Access will
fetch only the indexes, process the queries and then fetch the minimal
dataset that results from jet across the wire, Or it may be that it
fetches the Complete Datatable each time.
e.g. I've seen dozens of Customer Dropdown Listbox, that weren't pre
filtered nor limited to the just the Index and Name, and so dragged the
whole customer table across the wire each time instead of just the few
pertinent Names and PKs, and then bringing over the Address and other
related data for just -that- record.
I'd be 98% sure it's a design issue.
( Check the net traffic using Perfmon. - if logging don't forget to turn
it off .)
Disk I/O, Switching and LAN quality will have an effect on the handling
the data throughput so you can tweak that somewhat if you can't get the
Application properly optimised ( p.s. MS Access comes with a
Analyser/Optimiser wizard, and there are basic optimisations like
turning off Autocorrect etc you can apply at the non Code/design level
also.. )
The guys at comp.databases.ms-access can help you with a lot of that.
--
Henry Craven {SBS-MVP}
CI Information Technology
----------------------------------------------------
Melbourne SBS Users Group
http://groups.yahoo.com/group/melb-SBSusers/
"Doug B -db-" <dburrows_nospam-@dbnational.com> wrote in message
news:vWbQd.58058$sr1.43477@fe2.texas.rr.com...
> There is a front-end on the workstations. I pretty sure the slowdown
> began
> suddenly but at the same time the users say it's degrading as more
> data it
> added.
>
> I was monitoring the processor usage for a while today and while there
> was a
> few spikes up around 90% and some moderate usage around 50-60% much of
> it
> was below that.
>
> I'll be meeting with the client to try and get more specific info
> about when
> it began in relation to when the users began to use this db.
>
> Thanks so much
> db
>
>
>
- Next message: Merv Porter [SBS-MVP]: "Re: Forwarding Mail with Unresolved Recipients in Exch2000"
- Previous message: Henry Craven [SBS-MVP]: "Re: Administrator.[server name].001"
- In reply to: Doug B -db-: "Re: Access Database Application has began running slow on Workstations."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
