Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2001
    Posts
    852

    windows 2000 and mssql

    Does mssql server require to be setup on a separate server than the web server?

  2. #2
    No. You can set it up on the same.
    Stupid, but trying.

  3. #3
    Join Date
    Nov 2001
    Location
    Kansas City, Missouri
    Posts
    265
    You can set it up on the same box, but if it is going to be a busy server, then you might want a seperate box. SQL can be very picky and a major resource hog....
    ICQ:176143736

  4. #4
    Join Date
    Apr 2001
    Location
    St. Louis, MO
    Posts
    2,508
    No. You can set it up on the same.
    Yes, they can but it's not advised. SQL is a resource hog and you will suffer in performance if you keep them on both.
    Mike @ Xiolink.com
    http://www.xiolink.com 1-877-4-XIOLINK
    Advanced Managed Microsoft Hosting
    "Your data... always within reach"

  5. #5
    MS SQL will use every single MB of ram on the server if not configured correctly. If you plan to install it on the same server as a web server make sure you allot a certain amount of resources to it, or it will just use all resources available.
    Alvin Slocombe
    E-Insites - "Web services, simplified."

  6. #6
    Out of 512 MB how much would you allocate to MS SQL?

    Originally posted by alfturtle
    MS SQL will use every single MB of ram on the server if not configured correctly. If you plan to install it on the same server as a web server make sure you allot a certain amount of resources to it, or it will just use all resources available.

  7. #7
    Join Date
    Apr 2001
    Location
    St. Louis, MO
    Posts
    2,508
    MS SQL will use every single MB of ram on the server if not configured correctly.
    Yes it will and it should. Out of 512 MB of RAM, you should alocated it all (MS SQL needs at least 512 MB of RAM to run efficently).
    Mike @ Xiolink.com
    http://www.xiolink.com 1-877-4-XIOLINK
    Advanced Managed Microsoft Hosting
    "Your data... always within reach"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •