SQL Server Performance

SQL 2005 and Terminal Services

Discussion in 'Getting Started' started by jrgraham, May 18, 2007.

  1. jrgraham New Member

    Is it possible to have SQl 2005 and Terminal services to work together on the same server in a non clustered environment for about 2 to 3 users?
    If so are there any special tweaks that should be done to make them work together?

    John
  2. khtan New Member

    This will work. No special tweaks required


    KH
  3. satya Moderator

    RDP is an internal component for XP & Windows 2003 and Terminal Services is a part of Operating System where you have to install SQL too [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br />What is the userbase on your SQL Server?<br />If it is a development server then no need to worry.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  4. jrgraham New Member

    It is a production server and SQL is used for transaction logging. We are also considering placing Citrix on top of terminal server. Again total number of users logging directly to the server is 2 to 5 and actually hitting the server <30

    John
  5. satya Moderator

    I presume the server will have a minimum 2gb RAM then I don't see any issues, but in any case it is better to test the implications before taking it on live.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page