Azure Database Watcher has fantastic metrics but is unusable.
On a 200 DTU pool, ADW consumed 100% of CPU watching only 71 idle databases.
Its own queries occupy every top consumer list, until I turned it off.
Such a shame. Build it, don’t test it, don’t monitor it, just chuck it over the wall.
On a 200 DTU pool, ADW consumed 100% of CPU watching only 71 idle databases.
Its own queries occupy every top consumer list, until I turned it off.
Such a shame. Build it, don’t test it, don’t monitor it, just chuck it over the wall.
Comments
A 6 core 32GB server should be enough to do basic monitoring. I took one query they use; it ran 20 minutes before I stopped it 🤦♂️