Enhancing DWH resilience through backup optimisation in SQL Server
july 27, 2024 Enhancing DWH resilience through backup optimisation in SQL Server Backup is the process of creating a duplicate copy of data on a separate medium (local or remote) to prevent the loss of original data and ensure the possibility of quickly restoring it in case of unforeseen situations, such as damage or loss […]
Automatic statistics update
july 13, 2024 Automatic statistics update SQL Server uses a query optimizer that analyses statistics to determine the most efficient execution plan for a query. Therefore, the relevance of statistics directly affects query speed. This article discusses statistics and the MS SQL Server options that allow for their automatic updating. Statistics are information about the […]
Recommendations for optimising TempDB performance
june 29, 2024 Recommendations for optimising TempDB performance When working with high-load systems, it is essential to address the optimisation of all server processes. One potential cause of performance degradation can be the suboptimal configuration of TempDB, a system database in Microsoft SQL Server. In this article, we will discuss our experience with TempDB and […]
Index Fragmentation Removal
june 27, 2024 Index fragmentation removal Index fragmentation occurs when data that is logically stored sequentially on a disk is actually stored in a random order. Any changes to the data increase fragmentation. In our practice, we encountered a case where the average index fragmentation in a client’s database exceeded 50%, which is significantly higher […]
CPU load optimisation
may 31, 2024 CPU load optimisation In our practice there was a case when incorrectly set parameter resulted in 8% increase of request waiting time, while correct setting increased OLTP requests performance by 10%. In this article we will consider the max worker threads parameter. Parameter definition This parameter is responsible for the size of […]
The importance of a properly drafted ToR
may 15, 2024 The importance of a properly drafted ToR The Terms of Reference (ToR) is a key document that determines the success of any project. Regardless of the scope and specifics of the project being developed, a properly drafted TOR plays a crucial role in achieving the desired result. In this article, we will […]
Description and configuration of backup for transactional databases on MS SQL Server
april 30, 2024 Description and configuration of backup for transactional databases on MS SQL Server Introduction In practice, database administrators often face the situation when it is necessary to restore a database. Such a need may arise either as a result of a server crash or as a result of a trivial error of a […]
Algorithm for calculating the required computational resources for data processing in Kylin
april 21, 2024 Algorithm for calculating the required computational resources for data processing in Kylin Apache Kylin is a distributed repository of precomputed and aggregated data for complex analyses, that is, operational analytical processing (OLAP) cubes. The data pre-aggregation process is performed after initiating a request to build a cube segment that generates a Spark […]
Optimizing SQL Server Disk Space Queries
march 28, 2024 Optimizing SQL Server Disk Space Queries Introduction Managing disk space is key for keeping SQL Server up and running smoothly. How fast and stable your database is can really depend on how many times it’s hitting the disk and how much free space you’ve got in your storage. In this piece, we’re […]
Parallelism settings for query optimization in SQL Server
march 13, 2024 Parallelism settings for query optimization in SQL Server Introduction In our practice, users often need to process a large amount of data. At the same time, the time for data processing is most often limited. SQL Server has a large number of options that affect the parameters of query execution. In this […]