report is run slowly first time
The steps are described in that ScriptCenter article: Take the SQL script, modify the report server URL, then may add a proxy account and then simply run the SQL statement in SSMS, it contains every necessary for it.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing
May 26th, 2012 12:24pm

Hi, Why is it the report always runs very slowly the first time the user runs it. But all the next runs are much quicker? Is there a way to reduce the time the report is run for the user the first time? Thanks
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2012 4:51am

Hello, After some time of inactivity (~15 min) the web engine of SSRS shut down and on the next access the engine have to startup again and this takes some time. You can change the time in the config files of SSRS or see http://gallery.technet.microsoft.com/scriptcenter/SSRS-Wake-Up-Call-b2026b2cOlaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing
May 27th, 2012 4:59am

Hello, After some time of inactivity (~15 min) the web engine of SSRS shut down and on the next access the engine have to startup again and this takes some time. You can change the time in the config files of SSRS or see http://gallery.technet.microsoft.com/scriptcenter/SSRS-Wake-Up-Call-b2026b2c Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing Where and how do I change the time in config file? This seems to be easier solution than setting the powershell and sql job. Thanks
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2012 5:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics