ASP + SQL loads really slow over intranet

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Shawn H
    #1

    ASP + SQL loads really slow over intranet

    Hi guys,

    I've created a web application using ASP together with SQL Server as
    our db source, running through IIS 6 on a Winows Server 2003 platform.

    This application retrieves a list of customer codes from our db, so
    records returned could be as many as 2000+ for any single transaction.

    The application runs fine for users from the same state. However, our
    interstate colleagues have notice that it takes more than 3-4mins for
    the page to load, while it only takes me < 2secs to load.

    Our intranet server is located in the same state as I, so anyone from
    within this state has no problems loading the page. All other states
    are finding it unbearable.

    I've done some debugging, and it appears to be a server factor.
    I saved the page with the longest list to a local drive and opened it
    locally in IE and it loads quickly.

    Does anyone have any suggestions as to how to speed this application up
    for our interstate users?
    Any ideas would appreciated.

    Thanks,
    Shawn

    Tags: None
    • Simon Hayes
      #2
      Re: ASP + SQL loads really slow over intranet

      I would start by trying to identify the bottleneck - from what you've
      said, it's not clear if this is an MSSQL issue. If I understand you,
      both you and the other users are hitting the same IIS server, and
      issuing the same queries, but they get the results slowly and you
      don't. That could suggest that the delay is in serving the pages to the
      remote users, not in retrieving the data from the database.

      You can use the MSSQL Profiler to check the duration and execution plan
      of your queries, to see if there's any difference depending on the user
      requesting the data. If there is a difference, then hopefully the
      execution plan will give you a clue as to where the problem is.

      You might also want to post in an ASP/IIS group, if you haven't already
      done so - many performance problems aren't due to only one issue, so
      getting some ideas about how to investigate the other components of the
      system would probably be useful.

      Simon

        Comment

        • Shawn H
          #3
          Re: ASP + SQL loads really slow over intranet

          Hi Simon,

          I did some debugging, and it took SQL Server the same about of time to
          do complete the query for both local and interstate, and it's the
          serving of the page that is definitely taking much longer on our
          interstate servers.

          Usually, most users would do a query that should return about 1000+
          records, and than these records gets displayed into a table on the asp
          page. The page (file size) itself is roughly around 110+kB, so it's not
          exactly a BIG file to be tranferred. But then why the slow down?

          Any advices/ideas on how to by-pass this problem?

          Regards,
          Shawn


          Simon Hayes wrote:[color=blue]
          > I would start by trying to identify the bottleneck - from what you've
          > said, it's not clear if this is an MSSQL issue. If I understand you,
          > both you and the other users are hitting the same IIS server, and
          > issuing the same queries, but they get the results slowly and you
          > don't. That could suggest that the delay is in serving the pages to[/color]
          the[color=blue]
          > remote users, not in retrieving the data from the database.
          >
          > You can use the MSSQL Profiler to check the duration and execution[/color]
          plan[color=blue]
          > of your queries, to see if there's any difference depending on the[/color]
          user[color=blue]
          > requesting the data. If there is a difference, then hopefully the
          > execution plan will give you a clue as to where the problem is.
          >
          > You might also want to post in an ASP/IIS group, if you haven't[/color]
          already[color=blue]
          > done so - many performance problems aren't due to only one issue, so
          > getting some ideas about how to investigate the other components of[/color]
          the[color=blue]
          > system would probably be useful.
          >
          > Simon[/color]

            Comment

            • Simon Hayes
              #4
              Re: ASP + SQL loads really slow over intranet


              "Shawn H" <ShawnStyler@gm ail.com> wrote in message
              news:1112975388 .441101.9010@z1 4g2000cwz.googl egroups.com...[color=blue]
              > Hi Simon,
              >
              > I did some debugging, and it took SQL Server the same about of time to
              > do complete the query for both local and interstate, and it's the
              > serving of the page that is definitely taking much longer on our
              > interstate servers.
              >
              > Usually, most users would do a query that should return about 1000+
              > records, and than these records gets displayed into a table on the asp
              > page. The page (file size) itself is roughly around 110+kB, so it's not
              > exactly a BIG file to be tranferred. But then why the slow down?
              >
              > Any advices/ideas on how to by-pass this problem?
              >
              > Regards,
              > Shawn
              >
              >[/color]

              <snip>

              No idea, unfortunately. Since the problem seems to be serving the pages,
              you'll probably get better assistance in an IIS/ASP group.

              Simon


                Comment

                Previous template Next
                Working...