<div>
you need to check CPU\RAM \utilization\errors on the server - you may need to add some extras, patch server, update IE explorer, etc<br />
if it is manual printing -- print from your (user) PC
</div>


you need to check CPU\RAM \utilization\errors on the server - you may need to add some extras, patch server, update IE explorer, etc
if it is manual printing -- print from your (user) PC

<div>
<div class="content wysiwyg-content">
We have a sql cluster using 2008R2. When running on one node of the cluster, our SSRS reports are fine. When running on the other node, the reports are extremely slow. For example, we have a 350 page report that the first node can print to pdf in about 30 seconds. The same report take at least an hour on the second node. As a test, I installed sql server and SSRS on my laptop. I can print the same large report also in under a minute.<br />
So what could be happening on the second server that slows printing down so much? It doesn't matter whether we are printing to paper, pdf, etc. Also, it happens with any of our reports. It is not limited to this one large one. It also happens whether there are images &nbsp;on the report or not.
</div>
</div>


We have a sql cluster using 2008R2. When running on one node of the cluster, our SSRS reports are fine. When running on the other node, the reports are extremely slow. For example, we have a 350 page report that the first node can print to pdf in about 30 seconds. The same report take at least an hour on the second node. As a test, I installed sql server and SSRS on my laptop. I can print the same large report also in under a minute.
So what could be happening on the second server that slows printing down so much? It doesn't matter whether we are printing to paper, pdf, etc. Also, it happens with any of our reports. It is not limited to this one large one. It also happens whether there are images  on the report or not.

SSRS Very Slow Printing

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.