SQL Server -MS Access with Terminal Services (20-30) Users

By gil ·
I'm trying to determine if one machine can handle the following configuration of MS-SQL Server 2003 using ODBC to connect with client MS-Access for input/reporting. At the same time, there are 20-30 users who use terminal services at the same time.

Does anyone have experience with this architectural configuration in terms of impact on performance?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

In general, that does not sound too strenuous

by robo_dev In reply to SQL Server -MS Access wit ...

How many concurrent SQL users, and how intensive is the database access?

Are the TS users all on the local LAN?

What type of app is running under TS?

In general TS is very bandwidth-efficient since it's generally run over a slow WAN or VPN connection.

The two concerns I see would be if the SQL database is something very I/O intensive with huge tables and a lot of complexity, then the server would need sufficient RAM and processor to handle that.

The other issue would be if the database or TS applications had very strict latency expectations/requirements. Then it may be necessary to implement QOS and also engineer the LAN to meet your throughput/latency requirements.

Related Discussions

Related Forums