SQL Server 2000 Set up
-
Can anyone point me in the right direction? We are wanting to create some web apps that generates the data from queries from the SQL backend. Will the standard edition be sufficient? Also, would one processor be enough to handle a medium sized database? One last question, are you able to set up multiple databases on this one server?
-
Simple answers: yes, yes, yes.
Not so simple answer: It depends.
For the last question the answer is definately yes, you can set up multiple databases on any SQL Server edition.
Standard edition will almost certainly be alright if you don't need the specific feaures available in Enterprise Edition, and a single processor is often enough. Size of database doesn't really say to much about CPU needed, expected traffic is much more important. And as always, even though SQL of course likes as much CPU as possible it likes RAM even more.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
-
quote:
Also, would one processor be enough to handle a medium sized database?Define "medium sized"? Our reporting database used to run satisfactorily on a single-CPU server. This DB held about 25 tables and up to 6 GB of data.
quote:
One last question, are you able to set up multiple databases on this one server?Yes. There are limits, and lots of RAM and a good disk subsystem are essential. The SQL2k Books On Line has a useful section called "Maximum Capacity Specifications". The maximum number of databases that SQL2k will support, per instance of SQL2k, is 32767.
Thomas Rushton
blog: https://thelonedba.wordpress.com
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply