|
|
| PhilPeak 2005-11-29, 6:55 pm |
| VB Application performs a large number of queries to an SQL server in all the
process takes around 6 hours to complete. Why should the CPU show only 4%
activity for this process.
Regards
Phil
| |
|
|
"PhilPeak" <PhilPeak@discussions.microsoft.com> wrote in message
news:EE1C6F2B-CD84-4413-97AE-75DD2F10FD11@microsoft.com...
> VB Application performs a large number of queries to an SQL server in all
the
> process takes around 6 hours to complete. Why should the CPU show only 4%
> activity for this process.
>
> Regards
>
> Phil
What's this have to do with "Time-Out" or "VB"?
There is an amazing amount of "wait" associated with network I/O. It can
depend to some degree on how many services you have running that are getting
'a time slice' (although they may not in fact be doing anything). It can
depend on your hardware, server, etc. ....
Do a little tracing/performance monitoring and see where your application is
spending its time. It is possible you are being 'chatty' not 'chunky'.
-ralph
| |
| Jeff Johnson [MVP: VB] 2005-11-29, 6:55 pm |
|
"PhilPeak" <PhilPeak@discussions.microsoft.com> wrote in message
news:EE1C6F2B-CD84-4413-97AE-75DD2F10FD11@microsoft.com...
> VB Application performs a large number of queries to an SQL server in all
> the
> process takes around 6 hours to complete. Why should the CPU show only 4%
> activity for this process.
Because much of the processing may be happening on the SQL Server box itself
and not your workstation.
| |
| J French 2005-11-29, 6:55 pm |
| On Tue, 29 Nov 2005 06:51:37 -0800, "=?Utf-8?B?UGhpbFBlYWs=?="
<PhilPeak@discussions.microsoft.com> wrote:
>VB Application performs a large number of queries to an SQL server in all the
>process takes around 6 hours to complete. Why should the CPU show only 4%
>activity for this process.
Slow server
- smart client
Maybe a sleepey client
|
|
|
|