Skip to main content
The 2024 Developer Survey results are live! See the results

Questions tagged [performance-testing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
152 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 ...
Harshita Mishra's user avatar
4 votes
1 answer
590 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 ...
Artashes  Khachatryan's user avatar
0 votes
1 answer
44 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 ...
user avatar
1 vote
3 answers
252 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 ...
C. K.'s user avatar
  • 13
1 vote
1 answer
134 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 ...
Amit Sedai's user avatar
0 votes
1 answer
251 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 ...
André Carvalho's user avatar
0 votes
0 answers
87 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 ...
Sajith P Shetty's user avatar
0 votes
1 answer
254 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 ...
mva's user avatar
  • 101
1 vote
1 answer
39 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 ...
Adam's user avatar
  • 113
0 votes
1 answer
1k views

ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test

I have trying to execute a simple test with jmeter in Oracle 19.7 database. This is my lang configuration in database SQL> select * from nls_database_parameters; ... NLS_NCHAR_CHARACTERSET ...
estonolose's user avatar
1 vote
1 answer
211 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 ...
Trevor Brent's user avatar
1 vote
2 answers
207 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 ...
BeginnerDBA's user avatar
  • 2,180
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 ...
Dimitrios Desyllas's user avatar
2 votes
1 answer
90 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 ...
BeginnerDBA's user avatar
  • 2,180
1 vote
1 answer
168 views

which command to execute to run multiple OLAP queries?

I have 10 sql files that contains different OLAP queries. I want to run them as a batch. Meaning by batch, Postgres will consider each file as a batch and execute the queries at once (depends on its ...
Islacine's user avatar
1 vote
1 answer
427 views

Help using SQL Server Database Experimentation Assistant for performance testing

I am following the guide for capturing a trace in SQL Server Database Experimentation Assistant here: https://learn.microsoft.com/en-us/sql/dea/database-experimentation-assistant-capture-trace?view=...
blizz's user avatar
  • 157
-3 votes
1 answer
44 views

Sql Server benchmarking - Clarifications [closed]

We are in process of enabling both TDE and EFS on our DBs. In process of performance benchmarking to understand how sql server is behaving on current hardware pre and post , we are using perfmon or ...
Learning_Learning's user avatar
0 votes
1 answer
1k views

MySQL vs. MariaDB Binary Logging Difference

I've been doing some testing with both MySQL and MariaDB and I've noticed a big difference with regards to the growth of binary logs - I can't find out much about this online. I have a test database, ...
Molenpad's user avatar
  • 1,784
2 votes
2 answers
4k views

Why is MySQL slow on the Ubuntu dedicated machine while fast on the Ubuntu VM?

I have a dedicated machine with intel i5, 8GB RAM, 7200RPM HDD with Ubuntu 18.04 OS. I have installed only MySQL-5.7.22 in it, see the configuration file's content at the end of this question. I ...
Shuji's user avatar
  • 123
3 votes
2 answers
266 views

MySQL 5.7.21 not releasing memory after writing partition to disk

I've been testing extracting with SELECT * from a partition in a partitioned table in MySQL 5.7.21 and 5.7.22 I'm out of ideas and hitting my head on a wall. The goal is to write the data to S3 for ...
Heidi Schmidt's user avatar
1 vote
2 answers
1k views

How to simulate production workloads on a dummy database?

We are planning to enable Multi AZ on our production database which uses Amazon RDS as a managed service. Our Database is using SQL Server 2012 standard version. Before enabling that, I wanted to ...
Sayantani Nath's user avatar
1 vote
1 answer
314 views

How to make a test Database grow in size by running transactions to test autogrowth factor?

I have created a test Database instance which is currently having zero activity on it. I have set the auto growth parameter for this DB similar to our actual production DB which is 600 MB per day , ...
Sayantani Nath's user avatar
5 votes
0 answers
4k views

PostgreSQL High Disk I/O

I am evaluating PostgreSQL as an alternative to Oracle. I have a database with 533 Tables which contain up to 250,000 entries. For a performance comparison, I built the datbase both on Oracle and ...
tobspr's user avatar
  • 151
2 votes
3 answers
11k views

SQL Server CPU usage is overloaded sometimes

We do have a couple of servers, one is dedicated to the website without SQL and the other server is dedicated to SQL. Now the server running SQL is quite powerful, yet sometimes the server CPU is ...
Web Dev Guy's user avatar
2 votes
2 answers
47 views

Benchmarks for custom database

I am looking for an open source benchmark tool that can easily be extended to custom databases. The reason is I have created a new NoSQL DBMS (called Borrego) that support both JSON queries like ...
Andy's user avatar
  • 131
3 votes
1 answer
5k views

GUID vs Auto Increment Insert performance

I'm testing the performance of inserts between Auto increment integers vs GUIDs (v4) in tables with a lot of data. Following this blog post, i was expecting seeing a difference. But right now with ...
RenkoSmith's user avatar
4 votes
2 answers
9k views

How to find out "InnoDB Write buffer efficiency"?

Is there any way to find out that "InnoDB Write buffer efficiency" without tools like mysqltuner? I can't find it in INNODB STATUS or information_schema.
Heiko's user avatar
  • 43
1 vote
2 answers
3k views

Change compatibility Level on 80 to 100

We are about move all databases from a SQL server 2008r2 (Standard edition) to a 2016 standard edition server. Many databases have its compatibility level set at 80, wich is not supported on the 2016 ...
nunopacheco's user avatar
1 vote
1 answer
386 views

How to determine the root cause of a performance spike during a heavy load on DB2?

I am testing the performance of an application that links to a DB2 database engine at the back end. Looking at the transaction timer logs, I see that on the 37'th minute into the test run, ...
DraxDomax's user avatar
  • 129
1 vote
1 answer
127 views

Considerations for performance comparison with a high fragmented heap?

I am planning to perform some performance comparisons for different structures of one and the same table. The table I want to investigate on is a heap having ~ 1Mio rows and 123 columns. Setup: I ...
Magier's user avatar
  • 4,797
1 vote
1 answer
843 views

Why am I seeing OPTION (MAXDOP 1) in my Actual query plan even though I've not set it in the stored proc?

SQL Server is set with MAXDOP 0 by default. In the stored procedure I'm testing I keep seeing WITH (MAXDOP 1) in the Actual Execution Plans even though I've not specified any hints other than ...
Dante Revealed's user avatar
7 votes
1 answer
19k views

Horizontally scaling SQL Server, distributing the database with sharding

I wanted to know if there is any way to distribute a SQL Server (I'm using 2012 version) database accross multiple nodes. I'm trying to compare READ queries performance between SQL Server and MongoDB. ...
user98851's user avatar
2 votes
1 answer
109 views

How to time SPARQL queries on an Oracle12c database?

I have an Oracle 12c instance setup with an Apache Fuseki endpoint sitting on top of it. I am able to query the database using the Fuseki endpoint. I want to be able to get the execution time of some ...
David Morales's user avatar
3 votes
1 answer
50 views

Isolating a Distributed Replay environment

I'm a little nervous replaying a captured trace/workload for performance analysis... I'm using an isolated service account to run the SQL Services, including the Distributed Replay controller & ...
Johnboy's user avatar
  • 43
0 votes
1 answer
949 views

Generic stored procedure for results sets comparison

Some of the tasks in my team are related to stored procedure optimization. I am mainly a .NET developer, but I thought of writing a generic procedure for data comparison while procedures are being ...
Alexei's user avatar
  • 1,271
2 votes
2 answers
1k views

How to retrieve Oracle Key Performance Indicators in 5 minute intervals within a time range

I have Oracle 11g attached to a Performance Test environment. A performance test runs for two hours. After the run I want to programmatically extract a variety of in key indicators from the database ...
Inquisitor Shm's user avatar
1 vote
1 answer
133 views

Things to keep in mind while editing Mysql "my.cnf" file [closed]

Today I tried to boost mysql's(installed in my system Ubuntu 14.04) performance as I have many sites(PHP/Magento) installed in my system which relies on mysql as database server, but when I edited the ...
Vicky Dev's user avatar
  • 111
1 vote
1 answer
62 views

Statistics needs to be captured for query analysis

What statistics are required to theoretically prove that X query work better than Y query. As per my knowledge I need to look for: Query elapsed time Logical read Logical write Physical read Physical ...
Zerotoinfinity's user avatar
1 vote
0 answers
156 views

Compare Traces with RML Utilities

I am new to RML and am trying to use it to capture a trace, replay it on another server and then compare the two. I have managed to capture a trace using the server side script that comes with it and ...
Tom's user avatar
  • 1,549
10 votes
1 answer
3k views

Reset SQL Server usage

In my development environment, I am playing around with queries. For that I need to reset SQL Server memory, plans, etc. things which can ensure me that my query is the only stress/working process on ...
Zerotoinfinity's user avatar
0 votes
1 answer
709 views

Saving SQL Server DMV's for later use [closed]

Is it possible to save DMV's in SQL server database backup, which can be restored on different server, I mean with master db details( views and all)? If not, what's the best way to maintain 2 ...
Prateek Yadav's user avatar
3 votes
1 answer
7k views

What is the difference between select and fetch time?

In this article MySql vs MongoDB performance benchmark, they defined two measurements: select time run time (select + fetch) I do not understand what the difference is between these two. Can someone ...
user35662's user avatar
0 votes
1 answer
2k views

Mysql Select vs Select SUM performance

I need to check whether the surfer has alrady voted this can be done using Method 1 Select record_num FROM table where etc etc. i.e. SELECT record_num FROM content_votes_tmp WHERE up = 1 AND ip =...
user avatar
0 votes
1 answer
280 views

SQLIOSIM fails to run when using UNC path

I'm trying to run SQLIOSIM on NAS cluster's NTFS shared folder. Here's the command line: sqliosim.com -dir \\c16\vol1cifs -size 512 -d 600 But it repeatedly fails to create files during the setup ...
Samuel's user avatar
  • 101
8 votes
1 answer
243 views

Lower performance on newest servers

We have several db servers on production, 4 of them with very similar hardware configuration. Dell PowerEdge R620, only difference is that 2 newest ones (bought and configured 3 months ago) have RAID ...
Yaroslav's user avatar
  • 2,828
2 votes
1 answer
4k views

How can I measure the number of IOPs for a certain query

I need to estimate the max IOPs for a certain MySQL DB (one that does not exist yet). The OS is Linux and the DB is MySQL 5.1.x (though I don't think the DB brand is important for the asked topic) ...
Michael Ben-Nes's user avatar
2 votes
1 answer
3k views

Sort Warnings, finding out the query behind them

I'm troubleshooting a SQL Server 2012 that has started timing out as of a few weeks ago. The server is filled with thousands of sort warnings, at a rate of about 15 warnings per minute. To get the ...
Reaces's user avatar
  • 2,611
0 votes
1 answer
2k views

MySQL: Use Sysbench on Windows

Sysbench is a tool to analyze the MySQL performance. I downloaded it and extracted but there is no executable file. Files having extensions like .sh or .c or .h are available. I gone through the ...
ursitesion's user avatar
  • 2,071
29 votes
3 answers
6k views

Do natural keys provide higher or lower performance in SQL Server than surrogate integer keys?

I'm a fan of surrogate keys. There is a risk my findings are confirmation biased. Many questions I've seen both here and at http://stackoverflow.com use natural keys instead of surrogate keys ...
Hannah Vernon's user avatar
  • 70.2k
0 votes
1 answer
2k views

How to measure a perfomance of SQL Server database? [closed]

I have the task to improve the performance of a SQL Server 2012 database (one of 4 in an instance) by 60% confirmed by corresponding statistics. So, I need to measure "performance" of the RDBMS ...
Fulproof's user avatar
  • 1,392