Housing SQL Server 2000

[nimarii]

Hello,

My very small company is upgrading to SQL Server 2000. My question is how should I go about housing SQL Server? Our current server is pretty small (less than 100 GB), and don't most people house SQL Server 2000 on a separate server?

If anyone can provide any information, or tell me where I can find some more information, I'd greatly appreciate it.

Thanks!
nimarii

 

[SQLBill]

There are two forums for MS SQL Server. One is Setup and Administration (Forum962) and the other is Programming (Forum183). Check those out.

But to answer your question, Microsoft recommends that SQL Server be on a separate server. Why? SQL Server is designed to 'grab' all of the available memory for it's own use.

-SQLBill

 

[pweegar]

Generally, it's a good idea to install SQL Server on a seperate machine. There are several reasons including:
1)performance (depending on how much data you generate)

2) reliability - what else is running on your current server along with your DB? IF that server goes down, you lose the ability to use SQL.

3) storage capacity - how much data are you generating? Databases can eat up storage pretty fast. Here where I work, I support a departmental system. My SQL DB runs about 7-8 gig. Backups are about 4.5 gig and are backed up every night. Storage is a problem, as I currently have a partition that is only 17 gig. Means I off load every couple of days. Not only is this time consuming, but expensive, as I could be doing many other things.

4) I would suggest putting your SQL 200 server on it own machine with the following: Standard edition SQL Server supports 2 Gigs of ram and 2 processors. I'd would maximize both those. The more memory, the better the performance.