hakan.briggner

SNOW DB, maintenance, increase performance

Discussion created by hakan.briggner on Feb 12, 2020
Latest reply on Feb 25, 2020 by MarcoCambon

Hi everyone.

 

Since 2016 when we implemented SNOW we haven't deleted any inventory or usage data from our database.

 

It seems that this is beginning to impact the performance of SLM and reporting.

 

I would like to export all data from the database for a certain year, to separate databases that, if needed, can be reimported to our system or viewed in some way.

 

My thoughts is to create separate databases for 2016 and 2017 to start with and when the export is done delete the data from those years from the production database.

 

Has this approach been used by anyone?

 

Regards /Håkan

Outcomes