Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Hardware requirement new datawarehouse Expand / Collapse
Posted Tuesday, July 22, 2014 1:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, November 20, 2016 9:02 AM
Points: 44, Visits: 345
Hello all,

for our new datawarehouse I am trying to put together a hardware config. I understand this is not an easy task, but maybe with your recommendations and comments I know the setup is ok or not.
Our datawarehouse will consist of about 2TB of data, running on SQL2012, preferably Ent. Ed, on M$ cluster. From the M$ Best practices I have read the I/O reduces dramatically if mem can hold about 20% of data. So around 400Mb MEM per cluster node.

For performance reasons I prefer having SSAS on a separate server (same config as above).
I would use Windows 2012 Ent. Ed & SQL Ent. Edition. I don't see any plus on the datacenter editions.

Again, thanks for any input or learning points.

Post #1594951
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse