The tag has no usage guidance.

learn more… | top users | synonyms

5
votes
2answers
730 views

Multi-threaded replay of master activity for load/performance testing

Does anyone know of any existing tools/products that accomplish what I'm trying to do? After searching around for a bit the only thing I could find surrounding what I'm trying to accomplish is ...
2
votes
2answers
1k views

How to compare performances of two databases

There are two database servers and I want to compare their performances. Both have Windows operating system and and Oracle (10.2.0.4 and 11.0.2) database. Both are OLAP databases with 15-20 users ...
4
votes
2answers
7k views

Generate sample data for an Oracle database [closed]

Good morning, What free [or trial] software can I use to generate sample data for an Oracle database? I've been trying with various tools, but none work. Thanks for all suggestions, Alec Taylor
1
vote
1answer
79 views

Any general reasonable performance tests for DBs on application server and DBs on separate server?

My company are planning to move the DBs (SQL Server 2008 R2) from the application server to another server (random distance). All servers are Windows 2003 x86. Are there any general performance tests ...
22
votes
2answers
7k views

How do I properly perform a MySQL bake-off?

I want to performance test (aka bake-off) MySQL server rpm against some other forks such as Percona server, MariaDB, and possibly some others. I'm hoping that by asking this question I can better ...
10
votes
3answers
3k views

Testing stored procedure scalability

I have an email application that will be called upon to deliver to the UI the number of new messages for a given user on each page load. I have a few variations of things I am testing on the DB level ...
20
votes
5answers
934 views

Should Query Tuning be Proactive or Reactive?

As a software developer and an aspiring DBA, I try to encorporate best practices when I design my SQL Server databases (99% of the time my software sits on top of SQL Server). I make the best ...
3
votes
3answers
1k views

Database Performance Tuning

I have a MySQL backend, MS Aaccess front-end system that is nice and responsive over a local network but becomes sluggish over a broadband connection. I haven't done any performance tuning as of yet. ...
4
votes
2answers
299 views

How to compare performance of two versions of a function?

I just saw this function definition: create function dbo.f (@a int, @b int) returns integer as begin return case when not exists (Select * from t1 where t1.col1 = @a) AND @b &...