vb.net/sql server speed issue

  • Thread starter Thread starter Chandler Dickinson
  • Start date Start date
C

Chandler Dickinson

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
 
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....?????
 
Back
Top