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.
Typical environments where cleaning the database makes a lot of sense are:
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.
DBA.nl is the all-round database expert specialized in setting up, maintaining and monitoring database environments. In addition, we provide advice and remove performance problems.
In almost every organization the most important and most structured data is located in a few critical tables within your...
CVE-2015-0235 aka “The GHOST Vulnerability” On January 27, a vulnerability was discovered in the Linux glibc library...
"Oracle counts all servers when using VMware vSphere from version 5.1" Several sources on the internet report that Oracl...