Questions tagged [performance-tuning]
Improving the performance characteristics of a database application or system.
670
questions
0
votes
0
answers
38
views
How do you fix parameter sniffing on an ORM / Entity Framework Query?
We have a problem with plan cache bloat due to unparameterized Entity Framework queries. In cleaning some of these up we've seen dramatic reduction in SQL CPU usage. I'm inclined to go "clean up ...
- 81
1
vote
1
answer
73
views
Trouble with slow stored procedure performance on 35M rows with CTE/Temp table
We recently went through a new feature release to our app that added about 25 new columns to a large table (~35 million rows), and now we're having some major query performance issues. I assume that ...
- 127
0
votes
2
answers
39
views
Making mysql write more to ram and less to SSD
What are some tunning options that could make MySQL (8.0.36) write more to ram memory and less to SSD ? To have less SSD wear not to optimize performance.
Do these two affect amount of bytes written ...
- 194
0
votes
1
answer
76
views
AI Tools for Tuning SQL Server? [closed]
Are there any strong and accurate AI-based utilities out there that can help identify problems with and suggest better-tuned alternatives for deficient queries, and that can analyze and provide useful ...
- 157
0
votes
1
answer
44
views
MariaDB Performance Degradation After Brief 20 Hour Massive Improvement
Problem
On 2024-05-07 20:00:00 we migrated our DB from MariaDB 10.5 on an 8 core 16GB RAM server with a 10GB innodb buffer pool to a MariaDB 10.11 server with 16 cores 32GB RAM and a 20GB buffer pool ...
1
vote
3
answers
162
views
Azure SQL Managed Instance: 1. excessive initial compile times leading to app timeouts and 2. partition maintenance: long-running, bloats data file
We are having a couple of issues preventing us from going live with an on-prem SQL 2016 Std Ed to Azure SQL Managed Instance Business Critical tier re-platform, and I was wondering if anyone had ...
- 316
0
votes
1
answer
78
views
Availability group failover-tempdb
Does anyone know if SQL AG will initiate automatic failover to secondary if tempdb is full in primary ? I believe Database level health detection is only for user database in AG
- 47
1
vote
1
answer
60
views
Index not being used for date predicate [duplicate]
I'm doing abit of self learning on indexes & performance in a SQL Server. I'm using stackoverflow's database as my sample DB for this activities.
For my testing, I'm using the Users table & ...
- 13
0
votes
0
answers
40
views
MySQL 5.7 on Amazon Aurora - how to read the IO Cache vs. Disk Read metric?
I'm trying to determine how often InnoDB is hitting RAM vs. disk.
Does db.Cache.innoDB_buffer_pool_hits.avg mean InnoDB went to the buffer pool?
Does db.Cache.Innodb_buffer_pool_reads.avg mean that ...
- 133
2
votes
1
answer
261
views
MySql Aurora - how often to run ANALYZE TABLE?
I have a database that has existed for about 10 years, with hundreds of tables, many of which have several million rows.
We don't have a DBA and we have an increasing number of slow queries. We're ...
- 133
1
vote
1
answer
141
views
MySQL Amazon Aurora - a few slow queries causing extreme performance issues
I'm a dev, not a DBA, so pardon my ignorance.
I'm running on MySQL Amazon Aurora, single-instance (with a replica for failover).
A few days ago, my application had a handful of extremely slow queries (...
- 133
-1
votes
1
answer
147
views
Optimizing Negative Int/BigInt Ranges in SQL Server: Strategies and Benefits
I am currently delving into the potential applications and advantages of utilizing the negative range of the int or bigint data types within SQL Server, with a particular focus on the range extending ...
2
votes
1
answer
97
views
MySQL abnormal connection peak and page cleaner warnings
I'm running MySql 5.7.42 on Ubuntu 18.04 on VM with 12 Core, 64GB Ram and SSD storage.
This server is dedicated as DB server, some scripts and maintenance (backups) runs nightly but no other services ...
- 21
0
votes
1
answer
82
views
Execution plan - cost of sort
I've got a procedure with a Sort operator of 92%.
Here is the execution plan:
here is the script:
CREATE PROCEDURE [Specification].[GetSpecificationsByPage]
(
@Next int,
@Limit int ...
- 47
2
votes
2
answers
390
views
Execution plan - Not using Index seek due to ISNULL
i've got a procedure that i want to improve that uses
this where clause:
WHERE p.PlatformId = ISNULL(@PlatformId, p.PlatformId)
and p.PayeeStsId = 1
and p.PlatformPayeeId = ISNULL(@...
- 47