[AccessD] A 2003 on VM Ware

Jurgen Welz jwelz at hotmail.com
Thu Mar 4 12:30:46 CST 2010


There is a script that runs at login that sets up the envrionment and shortcuts for each user.  The shortcut that launches the application gets a fresh copy of the front end into each user folder and then launches it.  There is an 'If Exists' clause in the shortcut script that provides for launching multiple instances for each user.  This allows someone to open another application when they run invoicing, which generates a couple hundred Word docs and requires intensive processing that effectively ties up the application for that user.

 

It's not the number of users and it's not the horsepower.  Access is not playing nice.  I have more servers with more processors and more ram per user than I've ever had.  The system was designed from ground up to kick serious butt.  I have specialized high speed disks for the most intensive file work, and multi channel fibre optic connections to SQL Server.  Sure its still only ODBC, but, other things being pretty much constant, I've had nothing but performance upgrades.

 

The new environment has some Windows upgrades to what had remained pretty static for the last few years while we operated in an environment pretty much isolated from parent company systems.  They've been getting upgrades on a bank of servers while maintainining a rollback bank until everything is proved to be working.  We pretty much inherited their base environment and bank of servers concepts and tacked on our specialty software that includes things like Pervasive database services, Pervasive ODBC that were also running in our old environment.  Until this latest deployment, our division was operating on 4 VM terminal servers with the same OS and MS Office install.

 

>From the tools they have to monitor resources, Access is intermittently behaving like a pig even when it is simply statically displaying a form that is open behind another application.  When it acts up, other people on a bogged down server are unable to do things as simple as closing an Acrobat Reader file.


Ciao Jürgen Welz 

Edmonton, Alberta jwelz at hotmail.com


 
> From: dwaters at usinternet.com
> To: accessd at databaseadvisors.com
> Date: Thu, 4 Mar 2010 10:35:19 -0600
> Subject: Re: [AccessD] A 2003 on VM Ware
> 
> Are you using a single .mdw file for everyone? If so, that could cause a
> slowdown with 65 users.
> 
> Does everyone have their own 'User Directory' on the server? I have one
> system on a Citrix server, and their each person is running a distinct FE
> file.
> 
> Good Luck!
> Dan

 		 	   		  
_________________________________________________________________
Take your contacts everywhere
http://go.microsoft.com/?linkid=9712959


More information about the AccessD mailing list