How to upgrade SQL Server database system _ MySQL

How to upgrade SQL Server database system bitsCN.com

What do you do when the database server becomes very busy and causes performance degradation? Purchase more hardware to upgrade your server, or re-consider the database server design so that the database platform can be upgraded well? If you have worked in a very large store, you may have encountered these problems occasionally. Sometimes the answer is to simply look at the current application and improve some designs to improve performance.

Analysis phase

Before you decide to upgrade your database environment, you should set a performance standard and then modify the query and mode to check whether the performance has improved against the standards you have set, once your current system can work efficiently, you should re-evaluate whether you still need to upgrade the system.

Increase VS decrease

Expansion and reduction are two ways you can use to change your database environment to improve performance. Next we will compare the advantages and disadvantages of the two methods.

Expand

In this way, you need to purchase new or improved hardware for the database system. The added hardware may include a fast controller, a fast hard disk subsystem, more memory, and more processors.

Advantage: adding new hardware to the machine will undoubtedly accelerate the execution of your application. In most environments, simply expanding the server will mention enough performance to be satisfactory. You can use the 64-bit New SQL Server version to greatly improve performance. this version requires more memory and greater processing capabilities.

Disadvantage: hardware on enterprise-level servers is expensive, which may be a high cost of prohibition. If you have enough capacity to expand, it may be time to decrease.

Decrease

This method is to break down the database and store different parts of data on separate database servers. this method usually requires a large number of changes to the application layer and database layer to be successfully implemented.

Advantage: This method allows your design to be more upgradeable, because if your current structure is causing a bottleneck, you can further break down the design and use more machines to process data separately. A typical decomposition mode is to break down logical tables into different servers or break down your tables in parallel so that each database server has a part of all the datasets. You can also combine these two methods.

Another advantage of the reduction method is that it can potentially handle large transaction loads, and you can use common hardware, which is much cheaper than the hardware to be purchased for an extended upgrade. In addition, it usually does not need to purchase enterprise-level servers like an extended upgrade.

Disadvantage: This upgrade is much more difficult than the expansion method. In fact, it is recommended to use this method only in the following scenarios: when your current system has processed N transactions per minute on average, it cannot process more. This upgrade method is difficult because it is difficult to maintain and has a large number of movable parts, and it is difficult to logically split data or tables. Therefore, the processing is evenly distributed to a separate server.

BitsCN.com