Terminal Services Server Sizing

I intend to deploy a terminal server for 20 concurrent users.  At this moment in time I am not concerned about the bandwidth coming into the server for the remote users, as this is a separate questions.

This server will be Windows Sever 2008 R2 64 Bit, 8 Gigabyte RAM, dual-core Xeon 1.86GHz CPU.  SQL Server Express 2008 R2 64 bit will be running and users will be given MS Word and Excel (No Outlook).  A Microsoft Office 2010 Access front end database will be given to each user, which connects via an ODBC connection to the SQL Server database, in which there will be a contact database with about 10,000 records.

Would this server spec be OK to serve these 20 concurrent users?, and is there an easily understandable set of benchmark calculations that can be used, or a tool somewhere?

Thanks
Paul BarrettMDAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GeodashCommented:
I think your bottleneck will be RAM. 8 GB of RAM divided between 20 users and SQL...BUMP THE RAM!

Take a look at this EE discussion-

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/Q_23881726.html
Michael W. KroutCEO/PresidentCommented:
Here are some documents from Microsoft.   The information provided about the hardware is pretty on Spec.   I would recommend some more memory on the server.   As you know Microsoft products love memory.  The more memory will provide more cached memory so the program will reside in memory and not have to go to the hard drive (pagefile.sys).    

If you get more users then I would recommend going with more CPU power, say Quad Core.

http://msdn.microsoft.com/en-us/library/windows/desktop/aa383052(v=vs.85).aspx

Idea Dudes
wasiftoorCommented:
In my opinion, CPU power would be adequate but your main problem will be RAM.

Lets do some simple maths:

Each Terminal Session by Default Consumes around 128 Mb to start off with.
On Average With Multiple Documents being opened up in MS Word and Excel plus the Access Front End you should atleast think of around 300 Mb of additional RAM consumed. Thats a total of around 428 Mb per user. With 20 users this alone will go above 8 GB leaving not enough RAM for the OS, SQL Server or other background services.

You definitely need more RAM. Another 2 - 4 GB module should do the job for the specified capacity and requirements.

Good Luck!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Darius GhassemCommented:
You need to make sure you have enough bandwidth as well make sure you team network cards together to get more bandwidth you need to have at least a quad core processor.
Paul BarrettMDAuthor Commented:
Thanks for comments so far.  You say:

1.  Each terminal session consumes around 128 Mb
2.  With Word, Excel etc. add another 300

This is exactly the sort of answer I am looking for, but where is this documented?
Darius GhassemCommented:
Not documented this is why it is hard for someone to recommend the exact configuration for a TS server. Usually this is a best effort configuration recommendation
GeodashCommented:
IN simple words, when building a TS - Install as much CPU and RAM in the Host as your budget allows, without overkill. If you have more RAM available, the sessions will use it. If you have less RAM, the sessions will suffer.
Paul BarrettMDAuthor Commented:
Thanks all for your comments, always a tricky one to award points when multiple people have had a positive impact. 125 points to people who pointed me in the direction of some good material.  250 points for the person who put some figures on it.  Having done a lot of research, a good rule of thumb for  MS-Office users on a ts is to have 450 MB per user if there are 20 or more as there will always be periods of non activity from some, allowing spiky RAM grabs from others going unoticed.  Putting on SQL Server Express 2008 R2 64 bit means it will not grab more than 1 Gbyte RAM, and I allowed 2 Gbyte for OS use and services, leaving 5 Gbyte for users, currently 250 MByte RAM each if all 20 users are on.  Have managed to get 12 Gbyte RAM, so approx 450 MByte RAM per user.
Cannot do anything about processor, but again SQL Server Express can only see one processor, and I have my own sql server express back up utility.  Well that's my plan anyway.  Thanks all
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.