chris.o.smith
SSCommitted
Points: 1674
More actions
April 10, 2018 at 12:14 pm
#1986200
FWIW, if you are writing to clustered columnstore indexes while you see a spike in the RESERVED_MEMORY_ALLOCATION_EXT wait type, it could be an issue described here: https://orderbyselectnull.com/2018/03/06/large-cci-etls-cannot-scale-without-tf-834/
jobbish
SSC Journeyman
Points: 81
May 31, 2018 at 5:51 pm
#1992586
I've seen that wait type be a problem with concurrent queries that use HASHBYTES. Some details here: https://orderbyselectnull.com/2018/05/31/hashbytes-scalability/
Otherwise, I haven't been able to attribute it to a specific cause.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply