What would be a good way to calculate the recommended minimum hardware configuration for a Windows 2008 R2 64bit that will be running SQL Server 2008 R2 Analysis and Reporting Services? The database server is on another machine.
The current configuration is :
Virtual Machine running on a vmware7 host
2 vCPUs
4GB of RAM
80GB of Hard Disk space.
4GB of RAM appears to be insufficent.
No one has the answer to this question? Perhaps I need to provide more information? Is there a white paper on minimum requirement for SSAS and SSRS?
What started this question was essentially the customer saying, hay the RAM on my machine is all used up. I checked out the processes and noticed owstimer.exe. After a quick search I found that owstimer.exe is a sharepoint component. I say that with some doubt because I have not verified that information.
So I have a Windows 2008 R2 64bit, 4Gb of Ram, 4vCPUs on a machine with SSAS and SSRS. Among the processes I find one called owstimer.exe which might belong to sharepoint. I read somewhere that sharepoint should be installed on a system with a minimum of 8Gb of RAM.
http://technet.microsoft.com/en-us/library/cc262485.aspx
But sharepoint isn't on this machine just SSAS and SSRS.
The databases for this client are stored on a dedicated SQL Server 2008 R2.
More information. I can at limit SSRS and SSAS via their configuration files.
For SSRS
Control SSRS according to memory pressure
http://msdn.microsoft.com/en-us/library/ms159206.aspx
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config.
MemorySafetyMargin 80 /MemorySafetyMargin -- % of memory reserved for
the system
MemoryThreshold 90 /MemoryThreshold -- If Report server memory use
reaches this value, the report server slows down request processing
and changes the amount of memory allocated to different server
applications
Min and Max Memory control in SSRS
WorkingSetMaximum 2097152 WorkingSetMaximum>
WorkingSetMinimum 1048576 WorkingSetMinimum>
So we're going to try this out on SSRS and see how it goes.