Sudden growth of DPA repository, which instance caused the growth?

Hi

Regardless from the database system used as the repository you should be able to identify which tables are taking up the most space.

As soon as you have collected the information you can go a step further.

Most of the repository table names does looks like <table_name>_<id>.

E.g. CONACT_1

You can then query the repository table COND which contains the monitored instance name plus the id. The id column is matching the id in the table name.

SELECT id, name from COND;

regards

Fabian

Hi Fabian,

Thanks, I'm able to see all the tables by issuing: 

SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

I can also see the instances being monitored by issuing:

SELECT id, name from COND;

Which of my monitored instances relate to the growth of the transaction logs of the repository?  which of these tables can I query?  

Dennis

Hi Dennis

You could check now the size of the tables. There are a few options to get this. One of the option is via the DPA GUI:

"Options" / "Support" / "DPA diagnostics" / "Tables". 

Then you can sort by size or rows to get the biggest table.

Link the ID in the table name with the ID column from the table COND. At least you know then which of the four monitored instances is related with the biggest table(s).

Or are you looking for something else?

regards

fabian

Hi Fabian, 

I’m able to see [CONV_METRIC_DETAIL_545] and it's 23 gb in size and 540 million rows

 Queried [CONV_METRIC_DETAIL_545] and it has the below:

 I've attached a word do but were did it go? this has the screenshots.  Sorry, I'm new to THWACK.

I issued:

  SELECT id, name from COND;

 And it has ID and name of instances being monitored

How do you link this  [CONV_METRIC_DETAIL_545]?  Where is the common column so I can join it?

Dennis

Hi Fabian, 

I’m able to see [CONV_METRIC_DETAIL_545] and it's 23 gb in size and 540 million rows

 Queried [CONV_METRIC_DETAIL_545] and it has the below:

 I've attached a word do but were did it go? this has the screenshots.  Sorry, I'm new to THWACK.

I issued:

  SELECT id, name from COND;

 And it has ID and name of instances being monitored

How do you link this  [CONV_METRIC_DETAIL_545]?  Where is the common column so I can join it?

Dennis