SSRS Çözümlerimiz için kullanışlı bir çözüm. Özellikle SQL Agent Job ve PowerShell ile ilgili çözümü şahsen kullanıyorum.
Recently we started building up a separate reporting server based on SQL Server 2012 and got into grumpy employees complaining over slowly loading reports every morning. To be more specific, only the first call to the Reporting Service is slow. Luckily there are soft solutions before pointing to your sysadmin demanding him to build a new and faster server. 😉 To get started solving the slowness you can use two approaches.
Scan through the configuration files (RsReportServer.config) on the report server and do some stretching and tweaking of parameters. There are mainly two configuration parameters that will affect the slow startup; Recycle time (<RecycleTime>) and/or setting SSRS memory management options (<WorkingSetMinimum>). Use the following articles as your guidance:
- Technet – “RSReportServer Configuration File” – http://technet.microsoft.com/en-us/library/ms157273.aspx
- MSSQL Tips – “Prevent SQL Server Reporting Services Slow Startup” – http://www.mssqltips.com/sqlservertip/2735/prevent-sql-server-reporting-services-slow-startup/
Schedule a job that will handle a report call…
View original post 381 kelime daha