Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSDT Very Slow In SSRS/SSIS When Previewing Expand / Collapse
Author
Message
Posted Friday, July 19, 2013 7:19 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:21 AM
Points: 55, Visits: 300
We seem to having an issue with SSDT very slow in previewing reports. We have narrowed down any possible CPU or memory issues. Seems that this is also the case with SSIS.
Has anyone experienced this apparent 'bug' in 2012?
It has made us think of switching back to 2008R2
Post #1475720
Posted Thursday, February 6, 2014 4:26 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:54 AM
Points: 38, Visits: 15
I have got the same issue. Previewing reports in SSDT2012 takes up to 10x longer as in BIDS2005. I can see the "Reporting Service Preview Processing Host (32bits)" is taking 50+% CPU for very all long time. It makes no difference if data is cached in the “Dataset cache files”.

My experience is that reports with (a lot of) expressions in tablixes are the problem. When you report the same dataset 1 on 1 in a tablix performance seems OK.

I altered some reports with dynamic grouping (grouping based on en expression) because these reports timed out in SSDT! I also removed some CDBL() statements. But our reports still they are dramatically slow.

When I upload a report to Sharepoint (integrated), performance is much better (similar to 2005). So I am thinking about previewing report on our test Site.

ps: most of my reports are based on SSAS Multidimensional v11.0.3393.0 (MDX), on a server with OS2012.

Developing/ testing reports is a very frustrating time consuming job now
Please help!








Post #1538570
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse