Alexander-Weurding
commented
5 years ago Hello Rradtke,
I would go for a fresh install to make sure no old relations are in the DB. Also i would recommend only to use the DynamicsPerf when you are doing troubleshooting on the environment. It's costing some resources to run it.
Best regards Alexander
On Tue, Oct 8, 2019 at 7:55 PM rradtke notifications@github.com wrote:
I inherited this database and it is 500 gig in Query_plans table. We don't need performance information from 3 years ago and I want to purge this table. Can I just delete from this table? DATABASES_2_COLLECT table says retain for 13 months yet this table has retained for 3 years. What am I missing? Where is the user guide, I can only find an installation guide.
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/PFEDynamics/DynamicsPerf/issues/14?email_source=notifications&email_token=ABNOLJBL65EIB4XTEGEMARDQNTCRFA5CNFSM4I6VFIT2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HQNKJOQ, or mute the thread https://github.com/notifications/unsubscribe-auth/ABNOLJERJMMJPZXDW4FVGOLQNTCRFANCNFSM4I6VFITQ .
-- Groeten Alexander
I inherited this database and it is 500 gig in Query_plans table. We don't need performance information from 3 years ago and I want to purge this table. Can I just delete from this table? DATABASES_2_COLLECT table says retain for 13 months yet this table has retained for 3 years. What am I missing? Where is the user guide, I can only find an installation guide.