[AccessD] CPU and locks

Jim Lawrence accessd at shaw.ca
Thu Aug 31 16:44:27 CDT 2006


Hi Steve:

You hit the answer right on:

<Steve>
This is normal for Access.  It grabs as much resources as it can get to
perform data access requests.  And I've never heard of a server blowing up
from too many simultaneous requests.  Windows is designed to handle process
threading reasonably well, putting things in order, assigning priorities,
reserving some CPU for critical processes, etc
</Steve>

We had 65 users hitting a Server (only 512 MGs, held the BE Access and a MS
SQL 2000 that actually held the data). Thought the connection was not
through Citrix when one person hit utilization would jump to 100% and there
were as many as 20 on at any one. No one ever complained that they could not
get on or that the system is too slow. 

I am sure if you had 8GB of RAM, on a box and started up one copy of Access
it would show 100% utilization.

HTH
Jim




More information about the AccessD mailing list