|
Home > Archive > MS Access Multiuser > August 2005 > Very slow performance with 2 copies of db running on Terminal Services
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Very slow performance with 2 copies of db running on Terminal Services
|
|
|
| I have a pc setup as a Termial Services box (win2003). Each user has the
ability to run a completely distinct mde file. The mdb backend data file
is on the same computer. What puzzles me is that the 2nd mde that is
started has seriously degraded performance, at least with some queries.
One form that normally opens with data in hand more or less instantly
takes a minute to open (only on the 2nd instance of the mde). I've
opened taskmanager, and what I see is MSAccess.exe briefly using 2% of
cpu every couple of seconds, then none, then 2% again, then none, for
the entire minute. If I close the first-opened mde, the 2nd instance
which has been battling to see the light of day suddenly springs to
life.
The queries behing the form being opened are simple, and there are only
a couple thousand records in the tables. What is this resource
contention all about? I'd expected nothing like this with Access on TS.
Thanks
| |
| Paul Overway 2005-08-08, 9:24 am |
| See http://www.granite.ab.ca/access/ pe...kin
g.htm for possible
cause.
--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com
"kiln" <kiln@brick-like.com> wrote in message
news:MPG. 1d608fa04b2cd6249899
54@msnews.microsoft.com...
>I have a pc setup as a Termial Services box (win2003). Each user has the
> ability to run a completely distinct mde file. The mdb backend data file
> is on the same computer. What puzzles me is that the 2nd mde that is
> started has seriously degraded performance, at least with some queries.
> One form that normally opens with data in hand more or less instantly
> takes a minute to open (only on the 2nd instance of the mde). I've
> opened taskmanager, and what I see is MSAccess.exe briefly using 2% of
> cpu every couple of seconds, then none, then 2% again, then none, for
> the entire minute. If I close the first-opened mde, the 2nd instance
> which has been battling to see the light of day suddenly springs to
> life.
>
> The queries behing the form being opened are simple, and there are only
> a couple thousand records in the tables. What is this resource
> contention all about? I'd expected nothing like this with Access on TS.
>
> Thanks
| |
|
| In article <e#QB$5BnFHA.4028@TK2MSFTNGP10.phx.gbl>,
paul@I.hate.spam.logico-solutions.com says...
> See http://www.granite.ab.ca/access/ pe...kin
g.htm for possible
> cause.
>
>
Hi Paul
No kidding did that ever make a difference! Thanks for the pointer.
| |
| Tony Toews 2005-08-10, 3:25 am |
| kiln <kiln@brick-like.com> wrote:
>I have a pc setup as a Termial Services box (win2003). Each user has the
>ability to run a completely distinct mde file.
And each user *should* run their own completely distinct MDE.
See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
| |
| Tony Toews 2005-08-10, 3:25 am |
| kiln <kiln@brick-like.com> wrote:
>No kidding did that ever make a difference! Thanks for the pointer.
Thanks for the comments. They make the effort worthwhile.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
|
|
|
|
|