MS SQL Server - Time out problem

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Time out problem

PhilPeak

2005-11-29, 9:23 am

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

Andy Thompson

2005-11-29, 11:23 am

Its a common misconception that a CPU has to run at 100% to be running at
its fastest. There are other factors that mean that the CPU is in fact
waiting most of the time for the data.

The data retrieval to memory isn't usually handled by the CPU, as its
handled by the UDMA controller, and as hard drives are extremely slow
compared to the CPU and memory operating speeds, the CPU can't use all of
its clock cycles to perform the operations.

If in fact the CPU is only performing at 4%, its that it can't access the
data fast enough. One way to combat this is to install a RAID system, which
allows for faster data retrieval.

Andy

Sponsored Links