I am trying to understand the following scenario:
There is a Report that uses 2 stored procedures to retrieve data.
The Stored Procedures when run in SSMS , with params values supplied execute and completes in under one minute.
But the same Report when Run in SSRS Report Manager takes nearly one hour or more.
Here are sample data retrieval times 4202160 , 4078955 , 3499796 in milli seconds
And worse , when you try to access the same report embedded in a Wweb Applicaiton page accessed via a menu takes another 50% more time than Native SSRS Report execution time.
What shaould I do to troubleshoot this. ? Any hints or guidance is sincerely appreciated.