reporting services - Takes several minutes to run SSRS report -

reporting services - Takes several minutes to run SSRS report -

i have pretty simple ssrs report, takes less 1 sec run stored procedure. study works fine when upload on local server. on remote server (sql server 2012) takes 5-7 minutes run report. other reports on remote server work good. can help me? in advance!

you should utilize sql profiler or reportserver db check process slow. can utilize sql checking:

use reportserver select reportpath, requesttype, format, reportaction, timedataretrieval, timeprocessing, timerendering, datediff(s, timestart, timeend) totalseconds executionlog2

where timedataretrieval time of stored procedure execution + sending time reportserver, timeprocessing - it's time spent grouping, sorting etc. in study side , timerendering time spent rendering.

then when know why execution slow - can thinking ways of fixing (fix stored procedure, add together indexes, alter study construction etc.).

i had such problem cause parameters sniffing (about parameters sniffing), prevent shouldn't utilize input parameters in query follows:

create procedure [dbo].[usp_mysp] @inputvalue int begin declare @somevalue int; set @somevalue = @inputvalue; select somecolumn sometable somecolumn = @somevalue end

reporting-services