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 |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2012-09-06 : 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 required3.Processor.4.what should be the initial size for primary and secondary files?Thanks in advance. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-06 : 03:51:16
|
| There is no way to answer this without a lot more information.-Chad |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2012-09-06 : 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
1974 Posts |
Posted - 2012-09-06 : 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
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-07 : 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 hardwareJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
Hardware required for SQL server 2012 production