client freezes

NEWBIE...We run a custom application that sends
transactions to an SQL server over a WAN. On busy days, at
peak periods, many of the client work stations lock up and
freeze. If we leave it alone, the clients will resume
activity after 15-20 minutes. If we re-set the SQL
database, it unlocks all of the client pc's and resumes.
It seems like there is too much information being sent to
SQL and it cant handle the volume'
What could cause this and is there a way to adjust?Tom
Blocking, locks,bottlenecks.Have you looked at Performance Monitor?
CPU,Memory usage.
"Tom" <tomcdp@.aol.com> wrote in message
news:a32b01c4794c$8a8e3f30$a501280a@.phx.gbl...
> NEWBIE...We run a custom application that sends
> transactions to an SQL server over a WAN. On busy days, at
> peak periods, many of the client work stations lock up and
> freeze. If we leave it alone, the clients will resume
> activity after 15-20 minutes. If we re-set the SQL
> database, it unlocks all of the client pc's and resumes.
> It seems like there is too much information being sent to
> SQL and it cant handle the volume'
> What could cause this and is there a way to adjust?|||What do you mean by lock up and freeze? Are you saying the entire PC locks
up, or just a SQL Server application running on the client. I can't think of
a server side reason that would cause the entire client PC to lock up like
this. Server side blocking, waits, etc... would not be likley to do it.
If the entire PC is freezing, can you check the CPU utilization as it's
happening? Is it 100%?
--
Brian
"Tom" <tomcdp@.aol.com> wrote in message
news:a32b01c4794c$8a8e3f30$a501280a@.phx.gbl...
> NEWBIE...We run a custom application that sends
> transactions to an SQL server over a WAN. On busy days, at
> peak periods, many of the client work stations lock up and
> freeze. If we leave it alone, the clients will resume
> activity after 15-20 minutes. If we re-set the SQL
> database, it unlocks all of the client pc's and resumes.
> It seems like there is too much information being sent to
> SQL and it cant handle the volume'
> What could cause this and is there a way to adjust?|||"Tom" <tomcdp@.aol.com> wrote in message
news:a32b01c4794c$8a8e3f30$a501280a@.phx.gbl...
> NEWBIE...We run a custom application that sends
> transactions to an SQL server over a WAN. On busy days, at
> peak periods, many of the client work stations lock up and
> freeze. If we leave it alone, the clients will resume
> activity after 15-20 minutes. If we re-set the SQL
> database, it unlocks all of the client pc's and resumes.
> It seems like there is too much information being sent to
> SQL and it cant handle the volume'
> What could cause this and is there a way to adjust?
Do you have database "auto grow" enabled? If so, is the db pausing to expand
the size of either the data or log portion? I've seen this setting cause
some odd client side behavior...
Steve