What are the ways to tune Reporting Services? 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.