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.