Re: [GENERAL] Blocked updates and background writer performance

2016-01-13 Thread Cory Tucker
On Wed, Jan 13, 2016 at 9:48 AM Vick Khera wrote: > That was my intuition too. Not enough I/O available from the hardware for > the workload requested. > > As recommended, log your checkpoints and try tuning them to spread the > load. > Thanks guys, will turn on checkpoint logging and try to sni

Re: [GENERAL] Blocked updates and background writer performance

2016-01-13 Thread Vick Khera
On Wed, Jan 13, 2016 at 11:51 AM, Jeff Janes wrote: > Anyway, it looks to me like you have a checkpoint problem. The checkpoint > overwhelms your IO system. The overwhelmed IO system then backs up into > the bgwriter. What you see in the bgwriter is just a symptom, not the > cause. The backgr