Clustered Columnstore Indexes – part 44 (“Monitoring with Extended Events”)

Clustered Columnstore Indexes – part 44 (“Monitoring with Extended Events”)

Continuation from the previous 43 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is dedicated to the monitoring aspects of the Columnstore Indexes, which should help you understanding what is going on with your production system. Columnstore Monitoring Options First of all…

Clustered Columnstore Indexes – part 43 (“Transaction Log Basics”)

Clustered Columnstore Indexes – part 43 (“Transaction Log Basics”)

Continuation from the previous 42 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is dedicated to the Transaction Log behaviour, which might explain some of the behaviours of the Columnstore Indexes, observed in the earlier posts in the series. I decided to…