A.7 Monitoring Commands and Tips

A.7.1 SQL Database Monitoring Commands

Table A-1 SQL Monitoring Commands

To Find

Use This

PostgreSQL DB size =

IMPORTANT:This is an important query for tuning the PostgreSQL appliance.

For for tuning the PostgreSQL database, see .

 
SELECT pg_size_pretty(pg_database_size('database_name')) as "Database Size";

Number of Files =

select count(*) from SS_Attachments;

NOTE:This query will take some time. Divide the output number by 2.

Number of Folders =

select count(*) from SS_Forums;

Number of Net Folders (including Home Folders) =

select count(*) from SS_NetFolderConfig;

Number of Net Folder Servers =

Select count(*) from SS_ResourceDriver;

Number of users =

select count(*) from SS_Principals where type='user';

Number of Groups =

select count(*) from SS_Principals where type='group';

A.7.2 Monitoring Net Folder Synchronization

  • If you are running a re-index you can compare the numbers churning in the Administration Console > Search Index > Re-Index UI with the following DB query:

    select count(*) from SS_Forums;

  • During Net Folder synchronization, keep an eye on /vastorage and /var during the sync.

  • If you are running a Net Folder sync you can compare the numbers in the Port 8443: Administration Console > Net Folders > Sync Status icon (click the churning wheel) with the following DB query:

    select count(*) from SS_FolderEntries;

A.7.3 Monitoring the Impact of Your Tuning Changes to the Overall System

  • Monitor all Filrsearch, PostgreSQL and Filr appliances using top, df -h, du -h (on specific directories), using the DB queries listed above.

  • There are 3rd party tools that can be used to specifically monitor the JVM, such as jvmtop.