HammerDB database pressure tool using simple steps, hammerdb database pressure

HammerDB database pressure tool using simple steps, hammerdb database pressure

Welcome to reprint, reprint please indicate the source: http://blog.csdn.net/notbaron/article/details/38879681

Simple Steps for using HammerDB database pressure tools

Although there is no graph, the text description is the same!

Toad can only describe the steps through the memory language, this tool is very simple to use, can simulate the TPC-C test model, the unit of the test result is tpm, pay attention to whether it is tpmC.

Tpm indicates the number of transactions per minute. TpmC is the transaction unit of the TPC-C.

The general steps are as follows:

1. Install the operating system on the tested Machine

2. If ASM is used, install grid. skip this step if ASM is not used.

3. Install the database software. The specific steps are skipped. You can search for database versions online, mainly environment variables and RPM package requirements.

4. Use the dbca command to create a database under an ORACLE user. Both the database instance name and Global name are set to hammer, and then the sys and system passwords are changed to a simple one, such as oracle

5. After the database is created, use netca to configure the network listener. Set the listener name to hammer.

6. Create a tablespace. You can create one or two tablespaces. (User tablespace is required for this test.) Here we create two table spaces named tpcc and the other table space named tpcctl. The size is sufficient to GB (the size depends on the size of the database to be tested)

7. Install the hammerDB package (you can download it from the official website and install it directly. You need to install some RPM packages through YUM .) (You can also use a client on a tested machine or a separate machine)

However, if a client is created to put too much pressure on the tested machine, the network will become a bottleneck.

7. Open the hammerDB interface. The first step is to create schema interface (remember to have an options option ). Set necessary parameters, such as SID, name of the tablespace used for testing, system password, number of warehouse, and number of users.

After that, double-click create to import data (based on the number of warehouse sets, the data import time is determined based on the storage media performance ).

8. Set the test script, the Options option, and the number of users. Double-click Load. HammerDB loads the number of users.

9. Set the number of test users and the Options Option. After setting, double-click create and click the green go button on the image interface to perform the test.

10. Before step 1, it is best to set the parameters in transaction so that the performance result value can be displayed visually.

 

Finally, ORACLE optimization:

1. enable large pages of memory

2. Database PFILE parameter settings

3. storage location of major database tablespaces (storage media directly affects database performance) and separate REDO and DATA.

DATA is stored on a medium with good random read performance, such as SSD magnetic arrays, SSD cards, and FusionIO. The smaller the latency, the better. REDO data is placed on the media of sequential writing to ensure the bandwidth size. If REDO has a bottleneck,

DATA storage media is no longer used.

4. If a network exists, you must set network interruption binding.

Bottleneck Analysis:

1. analyze the system layer, check the CPU, MEM, and IO one by one, to ensure that there is no hardware bottleneck. If this problem occurs in advance, change the hardware.

2. If the hardware is OK, but the CPU utilization is not up, output the AWR report for analysis. This analysis requires professional knowledge.

If these two vertices are transparent, well, everything is done. But in fact, either of these two points requires professional analysis tools and analysis levels.

OK. Write it here. The beginning of ORACLE Database.

 

 

 

 

 

 

 

For stress testing, the server used is windows 2008 server and the database sqlserver. Which of the following is the best monitoring tool?

Loadrunner

[Investigation] What tools do you use to perform pressure tests on oracle databases?

If there is data, we can use the SPOT, TOAD Company, and none of the data has been done. It is said that there is a test communication called TCP to view the original post>