I am trying to fix an issue where an SSRS report is slow for the initial query of the day. I have tried using the solution described here:
...to no avail. I know that it seems to be an SSRS issue, but I am not sure if there is another workaround for this behavior. It uses Microsoft's ServerReport.Render method to render the report and dump it to a PDF.
Clarifications from comments:
I created a script like the one in the blog. I had that script run during off hours prior to the start of the business day. I also manually ran the script line by line in PowerShell and that did seem to alleviate the issue; however, that could have just been a placebo as the slowness was reported again by the QA assigned to this issue.
I have manually run the report and experienced the same level of slowness for the initial report query.
I do have a task that runs just before the start of business every day. I created the scheduler with the following line:
schtasks /create /tn "SSRS Recycle" /ru UserName /rl highest /np /sc daily /sd 08/01/2011 /st 02:00 /tr "powershell.exe -noprofile -executionpolicy RemoteSigned -file c:scriptsSSRSRecycle.ps1"
Is the path case sensitive? My Scripts file was named Scripts. Also, do I need slashes in the path name?