To stay updated on your favorite discussions, please create an account or log in. Then, click the Bookmark icon to subscribe and receive notifications.

H2 db growing close to 1GB per day

Options
andrzej
andrzej W/ Alumni Posts: 48 Junior Protector

PMS/PMC 12.40 with hotfix1 was installed on Windows 2012R2 on July 20th

Currenlty less than 1000 clients.

Since installing version 12.40 monitoring software reported that free space on the 50GB volume (Drive E:)  where the F-Secure server software is installed, is shrinking rapidly. Indeed the database grows, especially within last couple of weeks roughly 1 GB per day, and reached over 22GB

 

Database was restored from early Aug backup to 8.1 GB size and overnight it grew back to 9.5GB

F-Secure Policy Manager Server service was restarted, which brought DB size back to 8.6GB.

I have not run db-recovery tool yet, not even certain if this is going to have any impact on that 12.40 behaviour. Just checking with others if anyone else noticed similar behaviour.

TIA

Andrzej

 

 

 

 

Comments

  • A_Grinkevitch
    A_Grinkevitch W/ Partner, W/ Staff, W/ Product Leadership Posts: 169 W/ Product Leadership
    Options

    Hello,

    Seems that some hosts flood the PM with scanning reports, alerts etc. Try to figure out why that happens and stop it.

    If you need our assistance to identify the reason, please provide fsdiag via support ticket.

     

    PS: PMS does DB optimization on stop, that is the reason why DB size dropped a bit on restart.

     

    Alexander

  • andrzej
    andrzej W/ Alumni Posts: 48 Junior Protector
    Options

     

     

  • A_Grinkevitch
    A_Grinkevitch W/ Partner, W/ Staff, W/ Product Leadership Posts: 169 W/ Product Leadership
    Options

    Andrzej, if you reverted just the DB and logs are in place, could you please collect fsdiag and provide it to us. It is really interesting, why DB was growing so fast...

     

    Alexander

     

  • andrzej
    andrzej W/ Alumni Posts: 48 Junior Protector
    Options

    Alexander,

    As you suggested (in off the forrum corespondence) running ....\F-Secure\Management Server 5\bin\fspms-db-maintenance-tool.exe is a much better approach than restoring database from backups.

    Through that approach archived information (such as alerts and reports) is not geting discarded

    Database wich grew over last few days from 7.8GB to almost 11GB was shrunk by that tool to barely 2GB 

    Cheers

    Andrzej

     

     

This discussion has been closed.