Jeff,
I’m on a phone at the moment so I won’t try to make a full response right now.
I’ll just say, in my environment, insert hot spots aren’t a “top 10 problem”... Certainly nothing compared to the massive log growth caused by excessive page splits.
I have been tasked with coming up with a new, enterprise wide, indexing strategy.
If it’s ok with you, I’d like to pick your brain on the matter. I’m especially interested in finding out more about your aversion to doing index reorganize... We do use AOAG/HADR, which means we can’t use Bulk mode for index maintenance... So I was able to convince the people who decide if I keep getting paychecks, that we should stop doing rebuilds on the larger indexes and switch to “multi-session” reorgs instead.
It seems to stand in direct opposition to advise offered by Paul Randall...