• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1669
  • Last Modified:

SSRS Report very slow with added parameters

I have created and SSRS report which was working great and quite responsive.  I've added two multi-value parameters and specified them as filter criteria on the dataset and performance has tanked.

Selecting all the parameters  is set as the default which I had hoped would be as fast as the original non-parameterised version but no luck.
0
canuckconsulting
Asked:
canuckconsulting
  • 4
  • 3
1 Solution
 
ValentinoVBI ConsultantCommented:
First you need to figure out what part is slow.  How long does the parameterized query take when executed in Management Studio?
0
 
canuckconsultingAuthor Commented:
Turned out it only seem to be  a problem in the preview!  When I deployed it the thing ran great.

Any thoughts on why preview is so unworkable compared to production?
0
 
ValentinoVBI ConsultantCommented:
There can be a lot of reasons.  Different hardware, different data, ...  But as long as your query is fast in SSMS and you're not returning hundreds of thousands of records to the report, the report itself should be fast too, even preview...
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
canuckconsultingAuthor Commented:
Yes, this is what is frustrating me.  These are not large record sets and the report takes just a few seconds to run when deployed to by DB.

As I am developing on my laptop everything is the same!  Identical hardware hitting the same data source which consists of less than 2000 rows.  Any thoughts on how to work out what is wrong with my preview?
0
 
ValentinoVBI ConsultantCommented:
No idea to be honest, so far I've always encountered the opposite!  Do you have the latest service packs for both Visual Studio and SQL Server installed?  If not, that might be good to try.  It's always interesting to have the latest version of those installed anyway...
0
 
canuckconsultingAuthor Commented:
That could be my problem...the last sql sp is not installed and I am having trouble getting it installed.  I'll persevere with that and let you know if it resolves the issue.
0
 
canuckconsultingAuthor Commented:
ok...installed sql server 2012 sp and performance seems to be better. I'll give this a try and open a new issue if it recurs.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now