"Piotr" <hokah@wp.pl> wrote in message
news:1156491355.198100.285940@i3g2000cwc.googlegroups.com...
> Hi,
> I wonder how can I diagnose where is the bootleneck of my system.
> DTS are running very slow as there is CPU usage about 20% and Avg. disk
> queue about 100% all the time.
> Is this mean that disks are too slow ?
> Is there any possibility to do some memory tuning ?
>
> regards
> Peter
>

"Jéjé" <willgart_A_@hotmail_A_.com> wrote in message
news:OaAudGFyGHA.4232@TK2MSFTNGP05.phx.gbl...
>I presume you talk about a bulk insert data movement?
> if yes, do you have indexes in the target table?
> how many disks have you and what is the Raid level (if any)?
> how many rows and memory do you have?
> how many rows by seconds are inserted? (bulk insert performance counter)
>
> "Piotr" <hokah@wp.pl> wrote in message
> news:1156491355.198100.285940@i3g2000cwc.googlegroups.com...
>> Hi,
>> I wonder how can I diagnose where is the bootleneck of my system.
>> DTS are running very slow as there is CPU usage about 20% and Avg. disk
>> queue about 100% all the time.
>> Is this mean that disks are too slow ?
>> Is there any possibility to do some memory tuning ?
>>
>> regards
>> Peter
>>
>
>

Piotr wrote:
> Hi,
> I wonder how can I diagnose where is the bootleneck of my system.
> DTS are running very slow as there is CPU usage about 20% and Avg. disk
> queue about 100% all the time.

> Is this mean that disks are too slow ?

> Is there any possibility to do some memory tuning ?