| Author |
 Topic  |
|
|
ahmeds08
Constraint Violating Yak Guru
India
430 Posts |
 Posted - 09/06/2012 : 03:39:01
|
Dear All,
Need your help.
Please let me know what should be the hardware specification for setting up production environment on sql server 2012.
It is for a banking domain,so the frequency of trnasaction will be very high.
I will be going for Enterprise Edition,will it be ok?
1.Total hardisk space(SAN or RAID which would be better).
2.RAM required
3.Processor.
4.what should be the initial size for primary and secondary files?
Thanks in advance. |
|
|
chadmat
The Chadinator
USA
1961 Posts |
Posted - 09/06/2012 : 03:51:16
|
There is no way to answer this without a lot more information.
-Chad |
 |
|
|
ahmeds08
Constraint Violating Yak Guru
India
430 Posts |
Posted - 09/06/2012 : 03:52:47
|
Hi,
Can you please tell me what more details are required,so that i provide them.
quote:
Originally posted by chadmat
There is no way to answer this without a lot more information.
-Chad
|
|
|
|
chadmat
The Chadinator
USA
1961 Posts |
Posted - 09/06/2012 : 04:00:35
|
It just isn't somethng that you can really acurately determine in a forum. There are so many variables, Database sizes, transactions/sec, expected growth, number of users. It is also very workload dependent, what apps are running, are they in house or 3rd party (If it is 3rd party, they probably have min/recommended server specs)?
The easy answer is get as big a system as you can, but no answer any of us gives you will necessarily be right, it could fall down under load, or it could be complete overkill.
-Chad |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1775 Posts |
Posted - 09/07/2012 : 01:53:59
|
As a starting point , have you created a profile of the requirements , such as IOPs\read write per sec? Throughput rates? Disk Response Rates? Once you have those in place - it is easier to agree on hardware
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
| |
Topic |
|
Hardware required for SQL server 2012 production
