My backup and SLEEP_BPOOL

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 →

SQL Server

About the Author

Arun Sirpal

About the Author

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.

About the Author

Arun Sirpal

About the Author

Start the discussion at forums.toadworld.com