Terminal Services - MS Access Frequently "Not Responding"

Posted by jonfhancock on Server Fault See other posts from Server Fault or by jonfhancock
Published on 2010-01-07T17:18:30Z Indexed on 2010/03/24 9:43 UTC
Read the original article Hit count: 397

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:

  1. Any suggestions for improving performance and reducing hangs?
  2. Is it possible to disable the dialog (always wait) and screen graying?

© Server Fault or respective owner

Related posts about terminal-server

Related posts about terminal-services