• Hi All,

    its just same like above mentioned issue but i am asking to get more clarity on this

    anyone Could you please let me know whether the following statistics will impact the system performance or not.

    The following are the wait times for respective wait types. This is the report i got from a dev server. As per my conversation with the DEV team 'they ran some script on the server so the wait times got increased like this'.

    Now my question is if i ran the same on the production server will it effect the perfomance.

    waittime lastwaittype

    2875692330ONDEMAND_TASK_QUEUE

    2875659216BROKER_TRANSMITTER

    2875659216BROKER_TRANSMITTER

    2875659199KSOURCE_WAKEUP

    288366960XE_DISPATCHER_WAIT

    10602506BROKER_EVENTHANDLER

    4613707LAZYWRITER_SLEEP

    4613656LAZYWRITER_SLEEP

    4613654LAZYWRITER_SLEEP

    4613646CHECKPOINT_QUEUE

    447861FT_IFTSHC_MUTEX

    390142FT_IFTS_SCHEDULER_IDLE_WAIT

    29701XE_TIMER_EVENT

    24375FT_IFTS_SCHEDULER_IDLE_WAIT

    3086SQLTRACE_INCREMENTAL_FLUSH_SLEEP

    2313REQUEST_FOR_DEADLOCK_SEARCH

    608LAZYWRITER_SLEEP

    I am new to this forum If any descrepency in my mail excuse me. If any details i have to mention please let me know.