Databases are getting bigger

Databases are getting bigger and bigger. Is your database too large? Are you thinking of archiving and cleaning data? Don’t know how? Then read on. Do you only want to retain data for 3 years, but do you want to be able to access the data and use the application without error messages? DBA.nl has the experience and working method to archive and clean up data on your database.

Sooner or later, the time will come when the processing of data in the database of an application will take too long. Blockages arise and the operation stagnates. DBA.nl is regularly asked to solve such a problem. In case of performance problems, we do not immediately switch to archiving and deleting data, but first identify the problem and the cause. Sometimes the solution is to ensure better query plans and the problem can be solved quickly on a structural basis. We translate this into a clear report with factual substantiation.

When does cleaning make sense?

Typical environments where cleaning the database makes a lot of sense are:

• environments with data that goes back a long way
• large databases where many users and processes work on the same data
• databases that have become so large that normal maintenance is no longer possible
• databases with few options for migrations to new hardware

When archiving and cleaning data, it is therefore extremely important that table-to-table references remain intact to ensure proper operation of the application. In addition, data (to a certain extent) must remain available in case you, or a third party, want to know something later.

Thanks to years of experience, DBA.nl has developed a standard working method and standard scripts for this. If necessary, we write the code in such a way that the database can continue to be used without hindrance. This is therefore very interesting for databases that are crucial in 24/7 processes such as web shops, logistics, etc. When developing and implementing, we take your specific wishes into account.

DBA.nl is not only an expert in monitoring, implementations, migrations and performance tuning, but we are also your partner for T-SQL development.