Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SCHEMA
Posting Yak Master
192 Posts |
 Posted - 2009-05-16 : 01:05:05
|
| We are in the process of buying New Server (64-bit) for our database servers to SQL Server 2005 ENT 64-bit. What are the server specs?1) Quad cores or Dual Cores2) Others things. Please advise if you have already done . |
|
|
nwalter
Starting Member
39 Posts |
Posted - 2009-05-19 : 00:24:06
|
| What are your requirements? SQL server itself really doesn't have any server specs. You could run it on a single core pentium 100 with 128mb of ram if you wanted to. Of course if you put 10,000 users and a 100 gig DB on it it wouldn't run very well.How many users will be connecting concurrently?How big is the database(s)?What is the database structure?How normalized is the database?Are there a lot of triggers?Is the DB using lots of stored procedures or ad-hoc queries?Is it an OLTP db or a dataware house?As a general rule of thumb, you want 5mb of ram for each concurrent connection to the server. Beyond that it is entirely dependent on your workload and data size. You also need to consider storage on this server, is it local attached? SAN? iscsi? Raid 5, raid 10. This is such an open ended question I could go on for days, if you don't know to even ask these types of questions I would recommend that you hire a consultant to size the server for you and probably maintain it, especially if you are going into the scale of server that would require enterprise edition. |
 |
|
|
|
|
|
New Server Specs