June 26, 2014 at 1:02 pm
Just took new job, we have one server that has a read-only log shipped copy of major database, it also has SSRS, and Analysis Service on it. This is all sql 2008 r2. I get this is probably not the best way of doing things. The read-only copy is used for reporting purposes for the end user always a day behind and loading data warehouse. My goal is to get them to 2012 Always on and push this read-only database on it's own server. They seem hesitant because they think the reports and ETL loads going from server to server will be slow (no laughing here please). If I can convince them of this route, for a small company is run SSRS and Analysis server on the same box reasonable.
July 15, 2014 at 7:47 am
You are going to need an adequate amount of RAM and CPUs to run the reporting on this machine.
Read about Max Server Memory for you instance of data, then about memery settings for SSAS and SSRS so not to use Page Filing when memory runs out.
Here is a good start to a conversation about this topic on a forumn: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/40e7737a-4f20-41d3-8f95-ad5e9ee21986/confused-about-ssas-memory-usage?forum=sqlanalysisservices
Thomas
Thomas LeBlanc, MVP Data Platform Consultant
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply