Priority scheduler- query milestones


Priority scheduler- query milestones

1)How do we know that a query got demoted due to query miles stones? i mean if it gets demoted to next allocation group with lower priority, si there any place it stores this info? I need to keep track of how many quesries getting demoted due to query milestones.

2) Is weaight assigned to allocation group in Priority scheduler impacts the IO allocation also?

3) what exactly schmonnode table will contain?

Thanks in advance