What are the ways to tune Reporting Services?

Answer 1

Following are a few ways you can tune up Reporting Services:

You can expand your current Server or avail the reporting service database on another server. Depending on report characteristics and application logic, it is sometimes better to have a copy of data separate to improve the performance.

You can also use continuous replication for reporting. With this there wouldn’t be any interference with the OLTP environment.

The locking problems can be solved by using ‘nolock’ and the query performance can be improved using ‘dirty read’ when a copy of the data is not available. This can be accomplished only if the database design and application logic permit dirty reads.