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

optimal server placement Expand / Collapse
Author
Message
Posted Thursday, June 26, 2014 1:02 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 11:44 AM
Points: 68, Visits: 121
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.
Post #1586623
Posted Tuesday, July 15, 2014 7:47 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, December 5, 2014 2:57 PM
Points: 3,175, Visits: 795
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, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1592568
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse