Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hardware requirement new datawarehouse Expand / Collapse
Author
Message
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: Friday, September 12, 2014 3:47 PM
Points: 42, Visits: 331
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.
Rgds
T.


Post #1594951
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse