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
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.
Start the discussion at forums.toadworld.com