I have specified ‘resource_governor_cpu_limit_mode’ value as hard . When I run the user db_ui he need to use only 30% resources pools. I have seen my cpu spike 70%. Why this is happening it. How to control it.
For resource governor, percentages can get rounded up to the nearest fraction of whole cores, so with few cores, 30% could round to 50%. But I don’t know why it would go over 50%. What kind of workload were you running (kinds of SQL, number of connections)?
I have multiple pipelines. I am running them one after other. Due to this my pipeline is stopping. Please guide me how to over come.