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

Recommend Specs for Reporting Server Expand / Collapse
Author
Message
Posted Wednesday, April 17, 2013 3:49 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 11:27 AM
Points: 75, Visits: 286
I've been tasked to figure out the specs for the reporting server. I was thinking of loosely basing it off our production server, which has the following specs

Processor: Intel Xeon X7350 @ 2.93 GHz (2 Processors)
Memory: 32 GB
Operating System: Windows Server 2008 R2 Server Standard (64 Bit).
Storage: 1.3 TB

Any suggestions would be great. The reporting database is going to be pretty small, but I want a copy of production database, in case I ever have to do ad hoc reporting.
Post #1443519
Posted Monday, June 10, 2013 6:13 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 5:39 PM
Points: 40, Visits: 79
It depends on a large number of variabls,

Number of reports
number of users
Subscriptions
Cache
Parametrized reports etc.
web, hardcopy, interactive etc

If you are already have a working system working that as the basis would be a good starting point.
Post #1461827
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse