eprintid: 64317
rev_number: 1
eprint_status: archive
userid: 1
dir: disk0/00/06/43/17
datestamp: 2026-05-26 15:54:48
lastmod: 2026-05-26 15:54:48
status_changed: 2026-05-26 15:54:48
type: article
metadata_visibility: show
sword_depositor: 1
creators_name: Bobomurod, Baxtiyorov
creators_name: Habibjon, Valiyorov
creators_name: Sanjar, Zokirov
title: DATABASE MONITORING AND OPTIMIZATION TOOLS
ispublished: pub
subjects: Database, monitoring, optimization, performance, query profiling, indexing, DBMS, PostgreSQL, MySQL, SQL Server, Performance Schema, transaction, I/O load, buffer pool.
keywords: Database, monitoring, optimization, performance, query profiling, indexing, DBMS, PostgreSQL, MySQL, SQL Server, Performance Schema, transaction, I/O load, buffer pool.
note: Imported from MJST Journal (OAI id oai:ojs.pkp.sfu.ca:article/6059)
abstract: 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.
date: 2025-12-09
date_type: published
publisher: Center for Tech and Media Research
official_url: https://mjstjournal.com/index.php/mjst/article/view/6059
id_number: oai:ojs.pkp.sfu.ca:article/6059
full_text_status: none
publication: Multidisciplinary Journal of Science and Technology
citation:   Bobomurod, Baxtiyorov, Habibjon, Valiyorov, Sanjar, Zokirov  (2025) DATABASE MONITORING AND OPTIMIZATION TOOLS.  Multidisciplinary Journal of Science and Technology.