Viewing 7 posts - 1 through 7 (of 7 total)
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...
June 3, 2020 at 2:24 pm
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...
June 2, 2020 at 5:58 pm
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...
June 2, 2020 at 5:48 pm
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...
June 2, 2020 at 5:29 pm
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...
June 2, 2020 at 3:13 pm
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...
June 1, 2020 at 8:31 pm
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...
May 20, 2020 at 1:04 pm
Viewing 7 posts - 1 through 7 (of 7 total)