Questions tagged [performance-testing]
The performance-testing tag has no summary.
80 questions
0
votes
0
answers
19
views
RML Utilities – DTCTransaction EndTime Column Missing in Trace
While learning RML Utilities, I’m trying to generate an .RML file using ReadTrace. The tool fails because the trace must include the DTCTransaction event and its EndTime column, but EndTime is not ...
2
votes
3
answers
230
views
Best way to test index changes outside of production
We have a massive MS SQL Server production environment with thousands of tables in dire need of index tuning & pruning. Any suggestions on the best ways to test proposed changes outside of ...
- 177
0
votes
1
answer
544
views
Performance impact when querying without partition key on a partitioned table
Assuming I partition a table of large size (say 6TB) by month. We are serving very high traffic of around 300 RPS.
Sample schema
Create table mydata(
id int not null,
date_created not null,
uuid_val ...
5
votes
1
answer
651
views
Compilations/sec high when load testing a simple procedure
I am trying to load test a simple insert stored procedure:
CREATE TABLE _test(ID BIGINT)
GO
CREATE OR ALTER PROCEDURE dbo.test_sp
AS
BEGIN
SET NOCOUNT ON;
BEGIN
INSERT INTO _test
...
- 1,573
0
votes
1
answer
67
views
Can I do distributed stress testing on Amazon rds oracle database?
We have an onpremise production database . We are planning to move it to cloud. What types of Performance testing can be done ?
Is it okay to start with stress testing first?
Shall I start with load ...
Krishnaveni
1
vote
3
answers
352
views
Performance benchmarking numeric parameters of MariaDB with InnoDB using Sybench
I am conducting a performance benchmark of parameters with numeric values (i.e., innodb_buffer_pool_size, max_heap_table_size, query_cache_size, tmp_table_size) on MariaDB (version 10.11.2) using ...
- 13
1
vote
1
answer
182
views
Join with certain tables causes execution time to skyrocket
Database Application: Ver 8.0.30 for Linux on x86_64 (MySQL Community Server - GPL)
Server: Ubuntu 18.04.6
RAM: 32GB
CPUs: 8 core
The underlying application framework is Drupal and it uses a query ...
- 23
0
votes
1
answer
408
views
Best way to run performance tests in a production PostgreSQL 13 database?
First, I'm asking this question because I'm studying to be a DBA. Recently I learned a lot about database locking, and then some questions arouse in my mind.
Suppose I'm a DBA, I'm in charge of a huge ...
- 136
0
votes
0
answers
99
views
execution time increases after turning off read replica in postgres
The task was assigned to me to check the performance of uploads and query execution separately for "read replica" turned on and turned off.
Surprisingly when "read replica" was ...
- 312
0
votes
1
answer
332
views
convert RDS csvlog into pgreplay-go compatible for replaying
Before upgrading AWS RDS PostgreSQL version at production, I want to replay 1-hour recorded logs at the test instance.
Unfortunately pgreplay is single-threaded application, limited by single CPU ...
- 111
1
vote
1
answer
50
views
MySQL Like for Like - 100% accurate Backup/ Restore
I've struggled to find the answer to get a perfect backup and restore for MySQL.
I need to do performance test on a database so I need to make sure that the page files, indexes, fragmentation - the ...
- 113
1
vote
1
answer
251
views
SQL Server Database Experimentation Assistant Analysis Reports
I am using the Database Experimentation Assistant v2.6 to capture a workload using extended events (.xel) on SQL Server 2017 that is installed on an Azure VM. I'm then replaying it on a Azure SQL ...
- 31
1
vote
2
answers
304
views
Measuring the need of Capacity or scaling SQL server
This would be more of General approach question rather than too technical:
I have one of my application reach out to me wandering if we need to scale up SQL server in terms of CPU memory disk or CPU ...
- 2,230
0
votes
1
answer
1k
views
Replication testing is a Materialized view Refresh equivalent of continious update?
In my database I have the following a materialized view named materialized_view_test and the data are being feeded from 3 tables:
select
*
from
a_table join b_table on b_table.a_id=a_table.id
...
2
votes
1
answer
102
views
Breaking point for SQL server database based on connections from app to SQL server [closed]
We have been asked to confirm on some capacity test for one of our SQL server.
Application team is building their new app servers with better infrastructure to connect to SQL server.
Currently with ...
- 2,230