title: SSRS runs report for 30 sec however it takes only 3 sec in SQL Studio
body: <p>SSRS report calls sproc from SQL 2008 and it takes 30 sec to render it.</p>
  
  <p>If I call the same sproc with the same params it takes 3 sec to finish.</p>
  
  <p>SQL server and SSRS are on the same box.</p>
  
  <p>What can I do about it? </p>