Toad World Blog

My backup and SLEEP_BPOOL_FLUSH

Jan 31, 2017 10:05:03 PM by Arun Sirpal

I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more specifically Physical disk:Avg sec/read(orange/yellow line) and Physical disk:Avg sec/write(blue line), yes it was very busy, much busier than normal. Waits … Continue reading

Tags: SQL Server

Arun Sirpal

Written by Arun Sirpal

Mentored by Paul Randal - MVP (SQLskills) during 2015 finally completed my training in Internals and performance tuning with SQLskills during 2016. I have written online articles, created a centralised SQL Server dashboard project on CodePlex, iTunesU Podcasts and I have helped with data collection for SQLskills waits and latches library.