Our colleague Michael shared some stunning landscape photos with the team, which he captured during his trip to Iceland.
Our colleague Michael shared some stunning landscape photos with the team, which he captured during his trip to Iceland.
Often in the process of database operation, some of its objects become very large, which negatively affects performance and maintenance time. Sectionalization can be one of the options to solve this problem.
In the previous two articles, we described in detail how DB-Service diagnoses infrastructure problems on DBMS servers and problems related to SQL logic. Completing the series of publications about the basic analysis of these problems, it is necessary to say a few words about the complex problems that arise due to the intersection of the hardware and DBMS peculiarities.
In the previous publication, we raised the topic of how DB Service diagnoses failures after receiving complaints from customers. We considered the first large group of possible failures - infrastructure problems.
When receiving complaints from a client, such as "everything is slow", "users are complaining", "the process is too slow", etc., «DB Serv» performs a large number of checks to diagnose the problem.