Zurück
-
Titel
Is there a way to determine which collections are taking up most of the space in an OBS_METRIC_AGGREGATE? -
Beschreibung
There are some groups in our organization that have modified the collection settings on the Database agents. Some groups have set the "Working Mode" of the DB agents to high and made other modifications to the collection settings. We noted that the size of the Databases for some Foglight servers have 3-5 times more data than the databases of other Foglight servers. We would like to track down what collections and settings are contributing to the database size. Is there a way to determine which collections are taking up most of the space in an OBS_METRIC_AGGREGATE* table?
-
Lösung
The attached script (obs-row-counts.groovy) will report the number of rows in observation tables by topology type for the last 3 months of tables in the long term generation.The obs-row-counts.groovy script can be run from the command line with the following steps:- Copy the attached script to the FMS host.
- Issue the following command from the $FGLHOME/bin directory:
Unix/Linux:
./fglcmd -usr -pwd -cmd script:run -f > /tmp/row_count_out.txt
Windows:
fglcmd -usr -pwd -cmd script:run -f > c:\tmp\row_count_out.txt
For example if the user is "foglight" with a password of "foglight" and the script is placed in the $FGLHOME/bin directory the command would appear as follows:Unix/Linux:./fglcmd -usr foglight -pwd foglight -cmd script:run -f obs-row-counts.groovy > /tmp/row_count_out.txtWindows:fglcmd -usr foglight -pwd foglight -cmd script:run -f obs-row-counts.groovy > c:\tmp\row_count_out.txt -
Anhänge