https://community.qlik.com/t5/Installing-and-Upgrading/AMC-Tables-question-Best-practices-on-maintaining/m-p/2386196#M5417 <P>The customer should define retention policies on the amount of AMC data they want to keep. &nbsp;Based on those retention policies, you will write a simple DI job to either archive the old records or delete them. &nbsp; This way the AMC tables will not grow beyond control. &nbsp; Yes, for the graph to display fast in AMC, and be quick, you will want to control how much data is in those tables and whether the right indexes are there.</P> <P>&nbsp;</P> <P>The questions to ask are:</P> <P>- What is the value of knowing that a particular task failed 2 years ago with a null pointer exception?</P> <P>- What is the value of knowing that a job that you had 6 months ago took 2 hours longer to run? &nbsp;Nowadays maybe it doesn't because it has been refactored multiple times.</P> <P>- What is the value of knowing that a particular job failed everytime it was run for x number of days 6 months ago?</P> <P>&nbsp;</P> <P>Very often, while these history data may provide some insights, the most important data are usually what happened in the last couple of weeks. &nbsp;And thus, having answers to these questions will help define the retention policy.</P> <P>&nbsp;</P> <P>The customer will need to build jobs to clear down the AMC tables, and should also look at how they want to index the data in those tables. &nbsp;Its is&nbsp;allowed to add additional columns to the AMC tables to capture additional information. &nbsp;Hence,&nbsp;additional indexes will be needed for those additional columns.</P> Sun, 18 Jun 2017 03:07:37 GMT Anonymous 2017-06-18T03:07:37Z https://community.qlik.com/t5/Installing-and-Upgrading/AMC-Tables-question-Best-practices-on-maintaining/m-p/2386195#M5416 <P>It's been observed that when setting up the AMC, it creates and uses some database tables (as relates to this question SQL Server is the database chosen to house). &nbsp;The interaction between AMC and these tables includes creating them and writing to them, but does not include any maintenance - indexes, purging etc.</P><P>&nbsp;</P><P>Are there best practices for maintaining these tables that AMC uses?</P> Sat, 16 Nov 2024 09:37:10 GMT https://community.qlik.com/t5/Installing-and-Upgrading/AMC-Tables-question-Best-practices-on-maintaining/m-p/2386195#M5416 Anonymous 2024-11-16T09:37:10Z https://community.qlik.com/t5/Installing-and-Upgrading/AMC-Tables-question-Best-practices-on-maintaining/m-p/2386196#M5417 <P>The customer should define retention policies on the amount of AMC data they want to keep. &nbsp;Based on those retention policies, you will write a simple DI job to either archive the old records or delete them. &nbsp; This way the AMC tables will not grow beyond control. &nbsp; Yes, for the graph to display fast in AMC, and be quick, you will want to control how much data is in those tables and whether the right indexes are there.</P> <P>&nbsp;</P> <P>The questions to ask are:</P> <P>- What is the value of knowing that a particular task failed 2 years ago with a null pointer exception?</P> <P>- What is the value of knowing that a job that you had 6 months ago took 2 hours longer to run? &nbsp;Nowadays maybe it doesn't because it has been refactored multiple times.</P> <P>- What is the value of knowing that a particular job failed everytime it was run for x number of days 6 months ago?</P> <P>&nbsp;</P> <P>Very often, while these history data may provide some insights, the most important data are usually what happened in the last couple of weeks. &nbsp;And thus, having answers to these questions will help define the retention policy.</P> <P>&nbsp;</P> <P>The customer will need to build jobs to clear down the AMC tables, and should also look at how they want to index the data in those tables. &nbsp;Its is&nbsp;allowed to add additional columns to the AMC tables to capture additional information. &nbsp;Hence,&nbsp;additional indexes will be needed for those additional columns.</P> Sun, 18 Jun 2017 03:07:37 GMT https://community.qlik.com/t5/Installing-and-Upgrading/AMC-Tables-question-Best-practices-on-maintaining/m-p/2386196#M5417 Anonymous 2017-06-18T03:07:37Z