Post reply

which one is better 2008 express R2 or 2008 enterprice..?

  • March 22, 2011 at 1:00 am

    #389100

    hi...

    at present i'm working on 2008 enterprice edition

    my reports are rendering very slow ..

    so that's y planned to try on 2008 express R2 ..

    will the reports will render fast.. or slower then the enterprice edition..

    which one to choose ..?

    please guide me..

  • March 22, 2011 at 2:51 am

    #1301721

    Why would you think that moving to express would make things run faster ?

    It will be slower if anything due to express only using 1 cpu.

    As for your report running slow , is it the procedure ? or the SSRS rendering engine itself ?


    Clear Sky SQL
    My Blog[/url]

  • March 22, 2011 at 3:19 am

    #1301741

    Its the ssrs rendering only...

    for 150 records to display..

    stored procedure will take around 2-3 Sec

    and for displaying the records in report

    it will take around 1 minute..

    i have used only one table and no manipulation or expression

    in the report..

  • March 22, 2011 at 3:25 am

    #1301746

    Take a look at the advice given in this link

    http://sqlcat.com/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx

    See if helps you isolate the problem


    Clear Sky SQL
    My Blog[/url]

  • March 24, 2011 at 4:13 am

    #1302848

    Does the query only take that long to execute in SSMS, or did you actually check the ReportServer logs and see how long the time was divided between execution and rendering?

    Because there can be differences between running the exact same query in SSRS and SSMS (look up parameter sniffing, there was another post on it here today).

    If it really is the rendering time, I'd put it down to poor report design, or an overloaded server, or slow network connection. Swapping to R2 won't give you anything except extra features.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply