Movatterモバイル変換

Question 1

0votes

0answers

32views

SQL Server replication is in "Performance critical" status persistently

I have multiple publication in the sql server withSQL Server version: 2017Transactional REplicationDistributor and Publisher are in the same serverSubscriber is on the different serverAlso:9 ...

Dmitriy Ryabin

111

askedNov 13 at 19:33

Question 2

1vote

0answers

83views

Under what circumstances will a memory optimized table variable with a hash index outperform other temporary tabular structures?

ContextAside from victims of latch contention, everybody gave up on memory-optimized table variables pretty quickly. Probably around the time they realised that they still don't have statistics. Yet, ...

J. Mini

1,360

askedOct 17 at 20:38

Question 3

0votes

1answer

112views

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 ...

n0whereman

1

askedOct 12 at 21:17

Question 4

3votes

1answer

128views

Postgres Temp table performance

We are converting a database from SQL Server 2022 to Postgres 18.Our system has a lot of code in the database and a lot of queries that use local temp tables a lot more than CTE's. This is due to the ...

Mark Gibson

31

askedOct 9 at 9:04

Question 5

0votes

0answers

54views

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 — ...

Mohammad Safyar

1

askedOct 7 at 2:28

Question 6

-2votes

1answer

259views

SQL Server process priority affects delete query performance

I have SQL Server running on my local machine. I write integration tests in c# and I need to clean up data after each test run. Only I have access to the server, and it does pretty much nothing ...

Irdis

200

askedSep 8 at 18:03

Question 7

0votes

1answer

37views

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 ...

Enrique Alcocer

1

askedAug 30 at 18:54

Question 8

0votes

0answers

127views

On Sybase ASE 16, why is a simple query using a prepared statement 37 % slower than an equivalent stored procedure?

I am using Sybase Adaptive Server Enterprise (ASE) 16. I am using jConnect 4 in version 7.07.I have a stored procedure that contains a rather simple query, equivalent to this one (I have changed the ...

Harold L. Brown

101

askedAug 28 at 11:36

Question 9

0votes

1answer

54views

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 ismysql Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) usingEditLine wrapperI have a script that runs weekly that creates a ...

Jeff

161

askedAug 25 at 16:38

Question 10

0votes

2answers

93views

Can I get data from an estimated Execution Plan in my C# code?

After years of growth, some reports now take minutes to extract from our database, and in some cases fail due to excess resource consumption. This depends on the parameters that our customers choose ...

Henrik R Clausen

1

askedAug 23 at 8:34

Question 11

-1votes

1answer

53views

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 ...

TheNKTLaw

1

askedAug 11 at 9:39

Question 12

1vote

2answers

71views

Dynamically Adjusting max server memory Between Two Instances

I’ve got one server with two SQL instances. The server has 128 GB RAM.Instance 1 has peak load from 08:00–10:00Instance 2 has peak load from 14:00–17:00Currently:Instance 1 has max server ...

Jonasstadi

21

askedAug 7 at 15:04

Question 13

3votes

2answers

514views

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 ...

Kaaniche Emna

31

askedJul 24 at 14:51

Question 14

0votes

0answers

76views

Do you know about a triple store that performs well under frequent CRUD operations?

I'm working with RDF data in real-world applications that require frequent create, update, and delete operations — classic CRUD behavior. However, I’ve noticed that many triple stores seem heavily ...

Fox1994

1

askedJul 24 at 8:59

Question 15

0votes

1answer

60views

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, ...

comodoro

103

askedJul 18 at 13:24

Movatterモバイル変換

Stack Exchange Network

Questions tagged [performance]

SQL Server replication is in "Performance critical" status persistently

Under what circumstances will a memory optimized table variable with a hash index outperform other temporary tabular structures?

Unexplained MYSQL memory allocation

Postgres Temp table performance

SQL Server 2022 CU11: Specific CPU Cores Constantly Spiking After Plan Cache Fills

SQL Server process priority affects delete query performance

Improved write performance after restarting Cassandra nodes

On Sybase ASE 16, why is a simple query using a prepared statement 37 % slower than an equivalent stored procedure?

What happens in MariaDB if an index is dropped from a table while a join is running on that table?

Can I get data from an estimated Execution Plan in my C# code?

Can the NKTg Law analogy help in modeling database performance under variable data loads?

Dynamically Adjusting max server memory Between Two Instances

Tracking stored procedure performance metrics

Do you know about a triple store that performs well under frequent CRUD operations?

MariaDB: Engine-independent statistics are not collected for column

Hot Network Questions

Subscribe to RSS