Should I install on its on server

[jonastremor]

Can someone please tell me the benefits of installing sql on its own server as opposed to sharing with any other services. Are there any issues with running sql on a DC in a WIN2K environment. Any info is appreciated.

Thanks

 

[SQLBill]

The biggest issue is that SQL Server is set up to 'grab' as much memory (RAM) as it possibly can. SQL Server can slow down (sometimes drastically) other applications/processes running on the same server.

You can manually set SQL Server to use only a specified amount of memory.


-SQLBill