SQL Server Reporting Services Question:
What are the ways to tune Reporting Services?
Answer:
To tune-up the Reporting Services, follow the below mentioned ways:
- Expand the Server or utilizing the reporting services of another database server. For better embedding of report contents, report application’s logic and characteristics can have a duplicate copy of data.
- Replication of data continuously. Using nolock, the issues of locking can well be resolved and the performance of the query can be improved. This can be done by using dirty read at the time of duplicating the data is unavailable.
- Expand the Server or utilizing the reporting services of another database server. For better embedding of report contents, report application’s logic and characteristics can have a duplicate copy of data.
- Replication of data continuously. Using nolock, the issues of locking can well be resolved and the performance of the query can be improved. This can be done by using dirty read at the time of duplicating the data is unavailable.
| Previous Question | Next Question |
| Describe Reporting Lifecycle? | How to schedule SSAS Database backup. |