Prev: Multi-select parameter default?
Next: chart options
From: Thanh Nguyen on 28 Apr 2010 12:06
Recently I ran into a strange behavior:
the stored proc that makes up the report, runs much slower in sql mgmt
studio than the report itself from ReportManager. Usually it's the other way
around.

We have sql 2008 server egine w/ RS 2008.

Anyone runs into this before?

Thanks,

From: Uri Dimant on 29 Apr 2010 01:43
Thanh Nguyen

I would compare an executuion plans of both


"Thanh Nguyen" <ThanhNguyen(a)discussions.microsoft.com> wrote in message
news:7D679721-FE76-4AEC-94AC-CA48EE5D9131(a)microsoft.com...
> Recently I ran into a strange behavior:
> the stored proc that makes up the report, runs much slower in sql mgmt
> studio than the report itself from ReportManager. Usually it's the other
> way
> around.
>
> We have sql 2008 server egine w/ RS 2008.
>
> Anyone runs into this before?
>
> Thanks,
>


From: Bruce L-C [MVP] on 29 Apr 2010 09:35
What usually happens is that for some reason a stored procedure gets a
different plan when run from Reporting Services versus SSMS. However, I have
never seen or heard of a time where it is slower in SSMS. Seems like it
doesn't matter if it is slower there. However, the solution would be the
same. Add the statement With Recompile to your stored procedure.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Uri Dimant" <urid(a)iscar.co.il> wrote in message
news:edIwD715KHA.5848(a)TK2MSFTNGP06.phx.gbl...
> Thanh Nguyen
>
> I would compare an executuion plans of both
>
>
> "Thanh Nguyen" <ThanhNguyen(a)discussions.microsoft.com> wrote in message
> news:7D679721-FE76-4AEC-94AC-CA48EE5D9131(a)microsoft.com...
>> Recently I ran into a strange behavior:
>> the stored proc that makes up the report, runs much slower in sql mgmt
>> studio than the report itself from ReportManager. Usually it's the other
>> way
>> around.
>>
>> We have sql 2008 server egine w/ RS 2008.
>>
>> Anyone runs into this before?
>>
>> Thanks,
>>
>
>
 | 
Pages: 1
Prev: Multi-select parameter default?
Next: chart options