Illustrates the ways to tune Reporting Services

Question

Illustrates the ways to tune Reporting Services?

Answer 1

Following types of ways are uses to tune-up the Reporting Services, as follows:

• Enlarge the Server or utilizing the reporting services of other database server. For good embedding of report contents, report application’s characteristics and logic can have a duplicate copy of certain data.
• Replication of data incessantly: By using nolock, the matters of locking can well be resolved and the presentation of the query can be enhanced. It can be done by using dirty read at the time of duplicating that data is unavailable.