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

SSAS Memory Expand / Collapse
Author
Message
Posted Monday, December 26, 2011 12:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 02, 2012 5:05 AM
Points: 20, Visits: 30
I have the following configuration on my client's production environment:

-------------------------------------------------------------------
SQL SERVER: Microsoft SQL Server Enterprise Edition (64-bit)
OPERATING SYSTEM: Microsoft Windows NT 6.0 (6002)
Platform: NT x64
Version: 10.0.5500.0
Database size : 2 TB
SSAS(2008)cube size:14.4 GB
-------------------------------------------------------------------
PROCESSOR: INTEL(R) XEON(R) CPU X5650 @ 2.67 GHZ 2.67 GHZ (2 PROCESSORS)
MEMORY : 24 GB
SYSTEM TYPE : 64- BIT OPERATING SYSTEM
WINDOWS EDITION : WINDOWS SERVER ENTERPRISE SERVICE PACK2
--------------------------------------------------------------------

I have my sql server(2008) and SSAS(2008) on the same server(Windows Server 2008). Approximately 10 to 12 GB of data is getting increased daily in SQL Server database.
Now I need to migrate my SSAS(2008) on a separate server.So what should be the server configuration ? i.e. How much RAM, Hard disk,Processor is required?
Post #1226619
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse