Questions tagged [performance]
An evaluation of whether a system works well enough to be fit for purpose. Normally performance refers to the speed with which a system completes an operation or set of operations over time.
6,487 questions
0 votes
0 answers
29 views
SQL Server replication is in "Performance critical" status persistently
I have multiple publication in the sql server with SQL Server version: 2017 Transactional REplication Distributor and Publisher are in the same server Subscriber is on the different server Also: 9 ...
- 111
0 votes
1 answer
107 views
Unexplained MYSQL memory allocation
I’m running MySQL server on Linux. I have a long-standing issue on my database server — it keeps consuming an excessive amount of memory for no clear reason. As a result, I was forced to periodically ...
0 votes
0 answers
54 views
SQL Server 2022 CU11: Specific CPU Cores Constantly Spiking After Plan Cache Fills
We have observed an unusual CPU behavior on our SQL Server 2022 (Core Edition) starting from a specific date. The issue is that a few specific CPU cores — particularly cores 1, 7, 14, and 21 — ...
0 votes
1 answer
37 views
Improved write performance after restarting Cassandra nodes
I have a 24-node cluster that receives 400k to 600k ops/s at a latency of approximately 15ms-20ms at the 99th percentile. I haven't found the reason why after restarting the nodes, writes increase to ...
0 votes
1 answer
54 views
What happens in MariaDB if an index is dropped from a table while a join is running on that table?
I am running Fedora 42 KDE spin, and the output from mysql -V is mysql Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) using EditLine wrapper I have a script that runs weekly that creates a ...
- 161
-1 votes
1 answer
53 views
Can the NKTg Law analogy help in modeling database performance under variable data loads?
I recently came across the NKTg Law on Varying Inertia in physics, which describes an object’s movement tendency based on its position (x), velocity (v), and mass (m), with m allowed to change over ...
3 votes
2 answers
505 views
Tracking stored procedure performance metrics
I’m trying to track impacts of stored procedure executions - CPU time, execution duration, logical/physical reads, memory grants, etc. - in order to visualize them. In particular, I'm looking for ...
0 votes
1 answer
60 views
MariaDB: Engine-independent statistics are not collected for column
In the course of optimizing my MariaDB database I have tried the following query (found in this blocg post): ANALYZE TABLE <my_table> PERSISTENT FOR ALL; The command runs without an error, ...
- 103