Slow performance
Posted: Wed May 18, 2011 2:43 pm
Many of us might have heard complains from users that Their jobs are running extremely slow in production and how do we make it finish,Since this is production so we can't make any changes to the job but Yes we start looking around other things like CPU,Memory,Network,Job design,DB locks etc...
I do face this issue continuously and trying to make a checklist on what all need to be checked and tweaked.
So I am trying to compile opinions from the experts,Please throw some light on Slow running jobs and It will definitely help me and others as well.
Any best practices documents,write-ups,little notes,one-liners on this topic will be highly appreciated.
Cheers
Etler
I do face this issue continuously and trying to make a checklist on what all need to be checked and tweaked.
So I am trying to compile opinions from the experts,Please throw some light on Slow running jobs and It will definitely help me and others as well.
Any best practices documents,write-ups,little notes,one-liners on this topic will be highly appreciated.
Cheers
Etler