Originally Posted by ng12345
Thanks for your reply,

My terminal server is a separate computer.

Originally Posted by ng12345
The terminal server is a separate server with 32gb ram and a 1gb connection

I would start with going to SQL Express 64bit. This will free the RAM footprint some as SQL consumes some memory for each user. If SQL memory then balloons beyond 6-8G, your next option is full SQL.


Indy
"Boss"

Indy's Blog

www.BestForYourPractice.com
Our Name is Our Creed