Swingbench – Database stress test

Já devem conhecer uma ferramenta chamada Swingbench, certo?

Esta ferramenta espetacular permite que realizemos stress tests a base de dados e assim nos permite  entender o comportamento da nossa infraestrutura, mediante a carga, além de permitir conhecer o limite da arquitetura.

Os testes de carga, é uma fase, extremamente importante de um projeto, na qual permite visualizarmos ajustes/melhorias para um desempenho melhor para futuros sistemas e utilizadores.

O Swingbench é uma ferramenta desenvolvida por Dominic Giles, que gentilmente respondeu algumas perguntas 🙂

M04m: What is the big challenge for you this year?

Dominic: Its Hadoop… Im working with some of Oracle’s customers to see if they can take advantage of some of its large scale data processing features. Also catching up on documentation.

M04m: How do you see the change of behavior in the performance of databases, due to the large volume of data that you see today, such as Twitter and Facebook? And with the strong patterns of increasing NoSQL, Oracle itself has innovated with Big Data.

Dominic: Its hard… Big Data means different things to different organisations. I work with some customers that are pushing towards 1PB in a single Oracle database. Im also working with customers that process 10s of thousands of transactions a second in an Oracle database. So for them the emergence of Big Data will probably do little to change their behaviour. Others will definitely look towards noSQL databases and Hadoop as an alternative or partner to the relational database. After 20 years in the industry the one thing I’ve learned is never assume one technology will solve all your problems. My believe is that noSQL,Hadoop, and Relational databases will play happily for a long time to come with each doing what they excel at.

M04m: Where did the idea to create the SwingBench?

Dominic: To be honest “Money”… Not for my benefit but at the time it was hard to get load testing tools that didn’t cost the earth and didn’t need a degree in rocket science to get working. Swingbench is designed to be simple to use and flexible enough to allow users do just enough testing or benchmarking.

M04m: What is the biggest stage you know where a SwingBench was used? I saw some presentations with a Exadata stress tested with a SwingBench.

Dominic: Its hard to tell but I get a lot of emails from most of the big companies either asking for help or asking for enhancements. Its used extensively in side of Oracle for testing new features. Its also used by Oracle and our partners at product launches (usually not explicitly). I also see it used and quoted inside of white papers and research documents.

M04m: What can we expect in the future of SwingBench?

Dominic: I’ll be reworking ClusterOverview shortly because its a little tired and harder to use than I’d like. Datagenerator will be getting Hadoop support (as a generator target) and CPUMonitor will be getting a large cluster overview capability (100’s per screen)

M04m: I saw your other tools like Database Time Viewer, CPU Monitor and Trace Analyzer and I was very impressed. Do you have some plan to develop a new tool or that you developing now?

Dominic: Hadoop will be my main target moving forward so we’ll see what that brings (keep an eye out)

M04m: Do you have any message or tip you would like to convey to the DBA?

Dominic: Always test your backup 😉

Thanks Dominic Giles…

O Dominic também disponibilizou outras ferramentas bem interessantes, basta ir ao site: http://dominicgiles.com/

Saudações Vascaínas ….

Um comentário em “Swingbench – Database stress test

  1. muito massa essa ferramenta… estou realizando uma pesquisa para minha monografia e encontrei esse benchmark e queria saber se é possivel fazer com que eu possar executa-lo em cima do meu banco da dados, ou seja, se é possivel adaptar esses teste para um banco que ja tenho criado?

Deixe um comentário

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair /  Alterar )

Foto do Google

Você está comentando utilizando sua conta Google. Sair /  Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair /  Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair /  Alterar )

Conectando a %s