SQL Server Performance

About SQL Server Application through T1 lines

Discussion in 'Performance Tuning for Hardware Configurations' started by fredo3000, Jun 9, 2004.

  1. fredo3000 New Member

    It is good practice to run application through T1 lines?
    Lets say,

    1 server, 8 processors, 4gb of ram, 1 tb of space
    running 4 sites conected through T1 lines
    about 500 users,

    all 500 users hitting the server, I once saw a documents from microsoft saying that its no good practice to have applications running from remote sites, and it was better to have a sql server on each site. Now i've been looking for that document and can't find it. If anyway one know's about this plz let me know!
  2. Argyle New Member

    Unless you have really good response time between the sites this setup will be very slow. It doesn't matter how much hardware you put on it since the network speed will be the main issue.

    But it of course it depends on the application as well. If it's not heavily used or doesn't send a lot of data it could work.

    One solution could be to put the applications centrally at the same site as the SQL Server and then let users connect to a terminal server at this site and run the application from there.
  3. derrickleggett New Member

    You might look at Citrix also. It's a good solution for what Argyle suggested.

    --I can't believe I typed Citrus. What a dumbass.


    When life gives you a lemon, fire the DBA.
  4. fredo3000 New Member

    What is Citrus?
  5. satya Moderator

    Its a fruit, as you know.<br /><br />I believe Derrick is working in a nursery farm, as the quote refers to Lemon and now its citrus [<img src='/community/emoticons/emotion-2.gif' alt=':D' />].<br /><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</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.</i></font id="size1"></font id="teal"></center>
  6. derrickleggett New Member

    lol Nice Satya.


    When life gives you a lemon, fire the DBA.

Share This Page