vb.net/sql server speed issue

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

    vb.net/sql server speed issue

    I have a vb.net application running with sql server...
    All calls to the database are hit and drop.... i keep no
    connections open.... there are two timers in the
    application that hit the database to check for new/changed
    information (small hits)... here is the problem...

    this one has be whipped... please help if you can...

    I have only about 80 to 100 users peak... on mondays and
    fridays my users are less and the application runs fine
    but tuesday-thursday my app will run fast as lightning
    unit about 10:00am when the user counts go from 50-60 to
    80-100 and then BAM the entire application on all clients
    machines come to a screeching halt... and will remain that
    way until a few (5-7) users exit the application.... then
    the speed will go back to light speed... Also... it
    appears that on the first day after putting the database
    on a new server it screams regardless of the number of
    users... but on day 2 the problem comes back... I have
    actually had this thing running in the past on a MSDE sql
    server with the same results... DB, Connections, my
    App?????? What the heck is going on help help help...
    Chandler Dickinson
    Tags: None
    • Cor Ligthert
      #2
      Re: vb.net/sql server speed issue

      Hi Chander,

      This is more a language group who does of course also AdoNet, however this
      is more the behaviour of that AdoNet.

      A very good newgroup for that is
      Adonet
      <news://msnews.microsof t.com/microsoft.publi c.dotnet.framew ork.adonet>

      Web interface:

      <http://communities2.microsoft.com/co...s/?dg=microsof
      t.public.dotnet .framework.adon et>

      I hope this helps?

      Cor


        Comment

        • Cor Ligthert
          #3
          Re: vb.net/sql server speed issue

          Hi Chander,

          This is more a language group who does of course also AdoNet, however this
          is more the behaviour of that AdoNet.

          A very good newgroup for that is
          Adonet
          <news://msnews.microsof t.com/microsoft.publi c.dotnet.framew ork.adonet>

          Web interface:

          <http://communities2.microsoft.com/co...s/?dg=microsof
          t.public.dotnet .framework.adon et>

          I hope this helps?

          Cor


            Comment

            • Chandler Dickinson
              #4
              Re: vb.net/sql server speed issue

              thanks... i post this question in that group as well... but i am thinking
              that this issue may not be related to the data calls....?????


                Comment

                • Chandler Dickinson
                  #5
                  Re: vb.net/sql server speed issue

                  thanks... i post this question in that group as well... but i am thinking
                  that this issue may not be related to the data calls....?????


                    Comment

                    Previous template Next
                    Working...