Optimization of database system performance under shock load

The thesis describes the issue of load and query processing speed in database systems that serve as data sources for multiple applications and web services. These systems often handle many transactions in a short period of time, which can lead to a backlog of queries and slow down the entire process - and thus the entire application for the end user. The aim of this thesis is to identify problems and propose possible solutions to this issue. The practical part of the thesis will be addressed as a case study for a specific database system that needs to be optimized. The state of the database will be monitored using collected data that indicates system slowdowns based on its overload. The solution selected in the practical part will be based on the findings in the theoretical part so that it is most effective for the given case while respecting the given limitations. Keywords: Database optimalization, TSQL Database, Relational database, Data replication, Indexation, Efficiency