Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How can i calculate recommended hardware for a sql server ? How can i implement hardware plan for sql server ?

After Edit:

My Application is Designed By Silverlight. I 30 table in my database and i store picture or pdf files in some tables. I have 1000 user. I have 500 concurrent sessions.

share|improve this question

closed as not a real question by squillman, ConcernedOfTunbridgeWells, Holocryptic, Scott Pack, gbn Jul 1 '11 at 16:51

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

4  
This is hopelessly vague. Do some research based on what your needs will be. We can't give you any semblance of help without any semblance of requirements. What kind of application is it? What kind of data will you be storing? How many users will you have? How many concurrent sessions will you be running? Is it OLTP? Is it data warehousing? Throw us a bone. –  squillman Jul 1 '11 at 14:29
1  
Once you've calculated it (or estimated it), you "implement hardware plan" via the process of buying the hardware. What are you actually asking? –  mfinni Jul 1 '11 at 14:58
    
@hosseinsinohe, do no moderator alert requesting for poorly written questions to be reopened simply because you've actually added a tiny and insignificant amount of 'detail'. –  Chopper3 Jul 2 '11 at 12:44

2 Answers 2

A two links you may find helpful:

Hardware Sizing Microsoft SQL Server http://www.sqlcoffee.com/Tips0012.htm

Server Sizing Tool http://www.sizinglounge.com/

share|improve this answer

In the absence of any other information

  1. Plenty of fast RAID 10 disks. Or SSDs
  2. 64 bit
  3. As much RAM as you can afford. And add some more

Note: if it runs slow, your design and code is probably wrong

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.