Monitors RU consumption to maximize short-term usage of MAX RU. #7908
Labels
affects-7.1
affects-7.5
report/customer
Customers have encountered this bug.
severity/minor
The issue's severity is minor.
type/bug
The issue is confirmed as a bug.
type/development
The issue belongs to a development tasks
Projects
Problem
I have a group:
![image](https://private-user-images.githubusercontent.com/6428910/312023812-a59d50b3-58b6-4bf9-bfa2-8fa6d87a54e9.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQxNTUxMDMsIm5iZiI6MTcyNDE1NDgwMywicGF0aCI6Ii82NDI4OTEwLzMxMjAyMzgxMi1hNTlkNTBiMy01OGI2LTRiZjktYmZhMi04ZmE2ZDg3YTU0ZTkucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDgyMCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA4MjBUMTE1MzIzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YzRmMjJlOWE5ODMwMmQ0Y2NiMjZkNzQyZDI4ZjhlNTIwZDk0MWY3YzQzNGEwMWRjMDljODM2ODM0Yzg3NWRjMSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.9CFJVeK_wQ08d6d6nz8AzBNwEUPAE514f_2KjnZpPsM)
When I only run workload A:
RU Avg is OK because the workload is stable.
![image](https://private-user-images.githubusercontent.com/6428910/312023983-250c2ab9-d54c-4ffb-a990-4a55203f83d3.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQxNTUxMDMsIm5iZiI6MTcyNDE1NDgwMywicGF0aCI6Ii82NDI4OTEwLzMxMjAyMzk4My0yNTBjMmFiOS1kNTRjLTRmZmItYTk5MC00YTU1MjAzZjgzZDMucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDgyMCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA4MjBUMTE1MzIzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NjUwMjI1MzZhMDYwMTRjZmJhYzVmZTBmNWM1M2I4YzVhMTc1OTU3NjhmZDI2ZTJmMWE1ODgyOGI1M2I3MTQ3NSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.tHz6YxqWZm0_qFrOOGmfD9VqGG4Sw-1JQyzBuqOwIAQ)
But When I manually run the big query SQL like:
The monitoring was not very accurate(on-avg), which led me to mistakenly believe that I was far away from triggering RC control.
![image](https://private-user-images.githubusercontent.com/6428910/312024646-67e1746c-b596-4cd3-b387-705c5e3af1bc.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQxNTUxMDMsIm5iZiI6MTcyNDE1NDgwMywicGF0aCI6Ii82NDI4OTEwLzMxMjAyNDY0Ni02N2UxNzQ2Yy1iNTk2LTRjZDMtYjM4Ny03MDVjNWUzYWYxYmMucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDgyMCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA4MjBUMTE1MzIzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9ZTliMmVmOTc5M2Y0ZTYyZDM1YmY3MWQyNmNjMzQ3MmUxMGFjYzJmOWUwNWQ4ZmRhOTIxNzUyODUyODg0OTFiZiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.3gaQH0ExwQo2VialaIlyBoMlUCzACXqx-gFkchP-cfU)
But from the slow query:
![image](https://private-user-images.githubusercontent.com/6428910/312022934-04b9e2c2-844e-43b7-a0f1-21ae6a28bcff.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQxNTUxMDMsIm5iZiI6MTcyNDE1NDgwMywicGF0aCI6Ii82NDI4OTEwLzMxMjAyMjkzNC0wNGI5ZTJjMi04NDRlLTQzYjctYTBmMS0yMWFlNmEyOGJjZmYucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDgyMCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA4MjBUMTE1MzIzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9ZjNmOWJkMDc5YzczZjQyMmViOGU5OWU5ZWQ4YmEyY2VhMDYyMDU4N2RiNWE5ODVmNTFkNDBmOGEwMjA2MWZmNSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.Yhkk_uAPozV7ga2hsqm7f36zfgKSkE5W74NDiPurg5w)
it cost 8000+ RU, and which let some query need wait in the RC queue
Development Task
enhance the observability.
The text was updated successfully, but these errors were encountered: