Terminal Services - MS Access Frequently "Not Responding"
- by jonfhancock
Exposition:
We use a program built in MS Access that I serve via Terminal Services. I just installed a new TS Server with a Quad Core 2.6GHz Xeon, 8GB RAM, and 4 SATA drives in a RAID 0. In installed Server 2008 R2 (64bit obviously). It's only role is TS.
The problem:
With just a few sessions (under 10), I start getting frequent Not Responding messages in each session. When it happens, the users aren't doing anything particularly taxing, just form navigation and simple insert queries.
I can live with some stalls, but it is visually jarring in WS08 because the screen goes gray, and it presents a dialog offering to wait or close with some other options.
Questions:
Any suggestions for improving performance and reducing hangs?
Is it possible to disable the dialog (always wait) and screen graying?