How do I plan and select a database server? (1. principles to be considered when selecting a database server)

After a new business system is developed, You Need To promote the application software in a region or even nationwide. How can you choose server configuration, internal and external disk size, and network bandwidth based on the business scale, it is a complicated task.

The most authentic evaluation is to establish an operating environment close to the actual business application, conduct various stress tests, and calculate the response time and throughput of the system under different user numbers, the utilization of various Server resources at that time was obtained. The following three aspects should be taken into account for the complete evaluation of hardware resources:

Server Performance Evaluation

Client workstation or front-end desktop Evaluation

Evaluation of communication network card and network bandwidth

If an accurate stress testing environment cannot be established, evaluate the server based on industry benchmark and calculate the server configurations that meet the business scale, at the same time, we should consider the resources consumed during system management, such as backup, recovery, problem diagnosis, performance analysis, and software maintenance, important resources should be considered to leave room for upgrading and scalability in the future. The following are general principles:

Processor:Consider the processor capabilities during peak hours and reserve some buffer to ensure that the system has room for expansion when the business grows. If you want to maintain a fast response capability, you should keep 20% to 40% of the CPU surplus.

Memory:To consider memory for all applications running on this server, the memory is mainly dependent on the number of users, application types, processes, and applications.ProgramThe amount of data processed is determined.

Disk:Evaluate the actual user data volume of the business to calculate the minimum number of disks. Do not forget to select a backup device (such as a tape drive ).

Io slot:Keep more Io slots as much as possible to prevent more PCIe cards from being inserted in the future.

Network:Select an appropriate Nic to ensure that the network is not the bottleneck of the system.

When evaluating database server performance, the most difficult thing is how to grasp the Accuracy Problem and what factors should be taken into consideration. Ideally, the following elements should be taken into account:

Transaction complexity

Transaction Rate

Data read/write Ratio

Number of concurrent connections

Concurrent transaction count

Maximum database table size

Performance measurement goals

Based on various benchmark test results and detection of various production systems, the following table summarizes the utilization of CPU, disk, Memory Page, network, and virtual storage page switching, it can be seen that a server is an ideal mode if its utilization is kept within the range indicated by good.

Trackback: http://biz.chinabyte.com/462/2293962.shtml