Announcement

Collapse
No announcement yet.

I faced slow in Reporting Server

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • I faced slow in Reporting Server

    We face slow in Reporting server:
    Our Config:
    Reporting Server:SQL 2005 x64 SP3 and IIS 6
    DataBase Server: SQL 2005 x64 SP3

    when i am trying to access http://localhost/Reports it's take along time to enter

    the i try by change IIS mode to 32 then i cannt access the reports DB from site or SQL GUI

  • #2
    Re: I faced slow in Reporting Server

    I'll require a little more info before continuing. Can I get the rest of the server specs like memory, cpu, type of disk, etc?

    Also, what else is on that box? Have you done any work on perfmon to determine whether it's SQL causing it or maybe it's having resources taken by another app?

    Sometimes, since it's .net, the first time you load can take a bit of work, but after that it should be fairly responsive. Do you find that to be the case, or is it always unresponsive? How long does it actually take it to come up the first time vs how long it takes to come up in subsequent loads?

    Let's start there and see what shakes out.

    --Sean.
    Sean McCown, SQL Server MVP

    See my FREE SQL Server training videos at:
    http://www.MidnightDBA.com

    Blog Author of:
    Database Underground -- http://infoworld.com/blogs/sean-mccown
    DBA Rant http://dbarant.blogspot.com

    Comment


    • #3
      Re: I faced slow in Reporting Server

      CPU: x64 3GHz (4 CPU)
      RAM: 8 GB
      HDD RAID 1
      IBM x3650 m2 server

      Comment


      • #4
        Re: I faced slow in Reporting Server

        Thanks for the server specs, but you didn't answer any of my other questions.
        Sean McCown, SQL Server MVP

        See my FREE SQL Server training videos at:
        http://www.MidnightDBA.com

        Blog Author of:
        Database Underground -- http://infoworld.com/blogs/sean-mccown
        DBA Rant http://dbarant.blogspot.com

        Comment


        • #5
          Re: I faced slow in Reporting Server

          Welcome to the wonderful world of Petri, where people drip feed you with info, some of it possibly accurate and relevant, while you guess what might be up with their system
          Oh, and they pop up every few days but expect you to be answering their questions within seconds

          I'll add to your questions:
          Since there are two servers, what are the specs of each, and what is the network connectivity between them like?
          Tom Jones
          MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
          PhD, MSc, FIAP, MIITT
          IT Trainer / Consultant
          Ossian Ltd
          Scotland

          ** Remember to give credit where credit is due and leave reputation points where appropriate **

          Comment


          • #6
            Re: I faced slow in Reporting Server

            the problem occur from .net framework i repair it and the reporting servers become normal and latest update from Microsoft for .net 2 make problems

            thx all

            Comment


            • #7
              Re: I faced slow in Reporting Server

              could you tell us specifically which .Net framework update caused the problem, so can evaluate whether or not to implement it on our own systems ?
              Please do show your appreciation to those who assist you by leaving Rep Point https://www.petri.com/forums/core/im.../icon_beer.gif

              Comment


              • #8
                Re: I faced slow in Reporting Server

                bustanji83, READ the Rules at the below link and then post back with ALL the appropriate information that is required to enable us to help you with YOUR problem.
                http://forums.petri.com/announcement.php?f=63

                130 posts you have made so far yet you drip feed the information in the majority of your threads. This stops NOW!!!!!

                1 1 was a racehorse.
                2 2 was 1 2.
                1 1 1 1 race 1 day,
                2 2 1 1 2

                Comment


                • #9
                  Re: I faced slow in Reporting Server

                  Originally posted by tehcamel View Post
                  could you tell us specifically which .Net framework update caused the problem, so can evaluate whether or not to implement it on our own systems ?
                  Microsoft .NET Framework 2.0 Service Pack 2 Security Update for Windows 2000, Windows Server 2003, and Windows XP (KB974417)

                  Comment


                  • #10
                    Re: I faced slow in Reporting Server

                    that's a 9 month old patch. Do you have a regular patching system in place?
                    Please do show your appreciation to those who assist you by leaving Rep Point https://www.petri.com/forums/core/im.../icon_beer.gif

                    Comment


                    • #11
                      Re: I faced slow in Reporting Server

                      Yes I have every week but after uninstall this patch reporting return to normal status

                      Comment

                      Working...
                      X