CODEWITHSUNDEEP
sql-serverperformancesql-server-2008reporting-servicessql-server-2012
Henrov
Henrov

Reputation: 1610

best practice: reportservers and sql servers

we have three SQL servers serving a variety of applications on different webservers. Each application is using reporting services functionality. The average load per server per month is about 40.000 reports, taking an average of 3.1 secs to deliver a report.

At this moment the the situation is as follows:

We have just bought a new server, runnning SQL 2012. Would it be wise to move all reporting to the Reporting Server 2012? My idea is that there would be a significant performance-gain. Also, There would be only one reporting server to manage. But is that so? Are there penalties when running reports on one server while the database feeding the reports is on another server? Is it a problem if the Reporting Services version is different then that of the database server?

I would like very much to hear your thoughts on this. Performance and manageability are two key-components.

Greetings and thanks for thinking with me,

Henro

Upvotes: 1

Views: 575

Answers (1)

Lynn Langit
Lynn Langit

Reputation: 4060

Are you using the Enterprise Edition of SSRS 2012 (so that could take advantage of scale out via deploying parts of the SSRS implementation on different servers)? Here's a SSRS 2012 feature list by edition. Also, are you using any scheduled (i.e. snapshot or scheduled delivery) of reports to balance the load requests?

Upvotes: 1

Related Questions