Ask the Expert

Using SQL Server and Terminal Services together

I am in the midst of spec-ing out a server to run a SQL Server based auto dealer management system. I plan on using Terminal Services to run the client software. Right now there are only 38 users, and the client software memory usage is quite small(9MB or so per user). There will be no other software run on this server. I know SQL and TS is usually a no-no, but I am trying to keep the costs down. I will not utilize AD (for now), and DHCP is handled by the router. I was thinking along the lines of twin 3.06 ghz Xeons with 8GB of RAM, running W2K Advanced Server. Are there any special tricks, such as processor affinity (SQL using one processor, Windows and TS using the other), or anything else creative that can make this possible and work well?

    Requires Free Membership to View

Honestly, your best bet is to test it and see how it works, but I suspect you may have an overloaded server there if you're planning to maintain both the database and the terminal sessions on the same server.

This was first published in January 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: