The benchmark tag has no wiki summary.
4
votes
1answer
92 views
How can I benchmark a PostgreSQL query?
I want to benchmark a query containing an user-defined function I have written for PostgreSQL. Are there any standard ways to run such a benchmark?
I know that timing can be turned on with \timing ...
1
vote
1answer
77 views
How to generate TPC-DS query for sql-server from templates
I know that dsqgen is used to transform the query templates into executable SQL. But when I type in the command line: "dsqgen /directory query_templates /template query1.tpl /dialect sqlserver /scale ...
2
votes
1answer
59 views
Running a TPC-C Benchmark Without sleep() i.e. key-in + think time
We are running a TPC-C benchmark against a PostgreSQL 9.2 server using JdbcRunner-1.2 implementation. During first few tests we were not getting a smooth (that is, without sudden spikes down to almost ...
0
votes
1answer
59 views
mysqlslap running very slow on a specific computer
I've recently discovered the tool mysqlslap and have run some simple tests with it. I currently have three test environments (2 Win 7, 1 Linux Ubuntu) where I can run these tests. However, running a ...
0
votes
2answers
144 views
MySQL Benchmark on FreeBSD and Ubuntu [closed]
I'd like to benchmark two db servers, one is running Ubuntu the other FreeBSD. Unfortunately we are unable to install SysBench on the FreeBSD OS. Could anyone recommend any alternatives? Or should I ...
0
votes
0answers
52 views
Informix Benchmark select
I'm not very familiar with databases and need your help. We have following case. Informix DB is running and target table contains 1.5 million records. We want to run application which periodically ...
1
vote
2answers
127 views
mysqlslap number in sql statement to change with iteration
I am trying to figure out how to increment a number in a mysqlslap query with every iteratiom.
Let me explain what I exactly mean:
I got a query:
SELECT age FROM member WHERE id = [some number]
...
1
vote
1answer
215 views
SQL Server 2012 Performance Test
I've been given a task to test where an SQL server 2012 can achieve better performances - we have two options:
Use the SQL Server as an On-Premise machine (Standalone server that we have)
Use the ...
2
votes
1answer
986 views
I want to know about the IOPS (I/O Per Second) and How it influences the DB CRUD operation
I want to get a dedicated server for my Database (MySQL) which runs InnoDB Engine.
There is this option in InnoDB capacity that you can define the IOPS in it. Let's say
that I have a SATA 72K-RPM HDD ...
0
votes
1answer
155 views
Why we use low numbers for concurrent in MySQL benchmarks or HTTP_LOAD? [closed]
I've seen so many times that we use numbers like 5,6 or 10 at most. What is this concurrency? Doesn't it refer to number of simultaneous users in bench?
EDIT
I'm not talking about any specific ...
2
votes
1answer
219 views
How to use the 'select benchmark' command on a procedure
I am trying to check which of my procedures is slowest and thus needs optimization.
I currently have around 160 procedures and about 30 functions.
I am using the select benchmark() to check the ...
13
votes
2answers
4k views
How can I time SQL-queries using psql?
I would like to benchmark some SQL-queries agains my PostgreSQL database. Is there any way I can time SQL-queries using psql?
3
votes
1answer
152 views
Establishing Baselines & Benchmarks
When you are hired as a DBA in a new shop, what are the important tools that you would use for establishing baselines and implementing benchmarks for 50+ instances? You advice would be highly ...
5
votes
1answer
290 views
How can I benchmark the performance of UDFs to figure out which one is faster?
Basically I have two scalar UDFs that output the same data, one that uses a cursor and one that uses a recursive CTE. I want to determine which one should be used and discard the other; I'd prefer to ...
8
votes
4answers
3k views
Are there any MySQL Benchmarking tools?
I've heard a long time ago that there is this tool that helps you tweek mysql settings for better performance but i can't seam to find it. I am aware that I can use ab for apache to simulate high ...
