Here is a SQL script to  revoke sysdba role and grant minimal needed permission to DPA monitoring SQL login/account:

-- Run this script below on the both Primary and Secondary in...

must be there (somewhere), assuming you connected only to one SQL Server instance during the install process  … check if it is named something like ignite or confio or dpa (perhaps...

Please note, you will need a DB to store DPA performance related historical data as well. Our DBAs use an Oracle DB instance for it but we tested SQL Server...

No agent on SQL server (back-end) side only  Ignite PI service on Windows app server side (web portal) .

The Ignite PI server (service) is not consuming much resources (CPU/memory)

You account that...

We've been using DPA (former Ignite/Confio) for last 5-6 years and monitoring a dozen of SQL Server (2016 and 2017) DB instances.

It work well for us … after initial setup...

Agree fully Steve that “unfortunately, too many managers aren't willing to perform that self-evaluation”

Seems the toadying and inefficiency phenomenon is much bigger than we like to see or admit. I've...

Steve, your spending logic makes sense, only, my personal preference is slightly different.

Investing in people, knowledge and quality seems much better, especially in long run than spending money...