Ways to tune SQL Server Reporting Services

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.
How to schedule SSAS Database backup
How to schedule SSAS Database backup - SSAS database backups can be taken using SQL Server Management Studio (SSMS)....
How to generate an auto incremental number in a SSIS package
How to generate an auto incremental number in a SSIS package - Auto incremental numbers in a SSIS package can be provided using script components..
SQL Server Integration Services - purposes of lookup
SSIS 2008 has the ability of cache lookup data in to a local file. Lookup data thus needs to be retrieved once, and then cached and reused....
Post your comment