vb.net/sql server speed issue

[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

 

[Cor Ligthert]

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
<
Web interface:

<http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsof
t.public.dotnet.framework.adonet>

I hope this helps?

Cor

 

[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....?????