goodness0001
11-02-2002, 03:13 PM
Does mssql server require to be setup on a separate server than the web server?
 | View Full Version : windows 2000 and mssql WonderMonkey 11-02-2002, 05:09 PM No. You can set it up on the same. NodeHost 11-02-2002, 05:42 PM 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.... RackMy.com 11-02-2002, 10:08 PM 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. E-Insites 11-03-2002, 05:34 AM 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. Fahd 11-03-2002, 07:17 AM 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. RackMy.com 11-03-2002, 09:23 AM 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). |