TY  - JOUR
AV  - none
UR  - https://mjstjournal.com/index.php/mjst/article/view/6059
Y1  - 2025/12/09/
KW  - Database
KW  -  monitoring
KW  -  optimization
KW  -  performance
KW  -  query profiling
KW  -  indexing
KW  -  DBMS
KW  -  PostgreSQL
KW  -  MySQL
KW  -  SQL Server
KW  -  Performance Schema
KW  -  transaction
KW  -  I/O load
KW  -  buffer pool.
ID  - arxiv64317
A1  - Bobomurod, Baxtiyorov
A1  - Habibjon, Valiyorov
A1  - Sanjar, Zokirov
PB  - Center for Tech and Media Research
N2  - This article provides an in-depth analysis of modern database monitoring and optimization tools, their functional capabilities, and their role in improving performance. The monitoring process covers real-time indicators, resource utilization, slow queries, blocking, and error detection mechanisms. It also compares the advantages of professional monitoring platforms used in various DBMS systems ? PostgreSQL, MySQL, SQL Server, and others. The article also presents advanced practical methods for query optimization, indexing, data structure, and server resource tuning. As a result, the article highlights a comprehensive approach to improving the stability, speed, and overall performance of databases and serves as a guide for practicing specialists.
TI  - DATABASE MONITORING AND OPTIMIZATION TOOLS
N1  - Imported from MJST Journal (OAI id oai:ojs.pkp.sfu.ca:article/6059)
JF  - Multidisciplinary Journal of Science and Technology
ER  -