Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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


Group: General Forum Members
Last Login: Thursday, February 4, 2016 8:06 AM
Points: 184, Visits: 363
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, February 5, 2016 5:36 AM
Points: 3,484, Visits: 856
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:


Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
Post #1592568
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse