Recommend Specs for Reporting Server

• DVSQL

  Hall of Fame

  Points: 3108

  More actions

  April 17, 2013 at 3:49 pm

  #276669

  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.

• mysorian

  Ten Centuries

  Points: 1048

  More actions

  June 10, 2013 at 6:13 pm

  #1622674

  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.