Intermittently our Single store DB CPU utilization is 100%. We need to identify what exactly is taking high CPU how can we identify it?

Welcome (Start Here)
1

Intermittently our Single store DB CPU utilization is 100%. We need to identify what exactly is taking high CPU how can we identify it ?PU when pipeline running

2

Good starting point is to check Workload Monitoring to see if any query takes up CPU. If there is a query you can profile it to check which operation is the bottleneck.
Otherwise it’s only possible to give advice if you share the DDL of the table + pipeline (you can anonymize it)