Sqlserver high concurrency and big data storage solution

This article mainly introduces Sqlserver's high concurrency and big data storage solutions. It has some reference value. let's take a look at it below. with the increasing number of users, daily activity and peak value, database processing performance is facing a huge challenge. Next we will share with you the database optimization solution for the platform with over 0.1 million actual peaks. Discuss with everyone and learn from each other!

Case: game platform.

1. high concurrency

When the number of client connections reaches the peak value, the server will not discuss the connection maintenance and handling. When multiple write requests are sent to the database, you need to insert multiple tables. in particular, some tables are stored for more than 10 million RMB per day, the traditional synchronous data writing method is obviously not desirable. after experiment, the asynchronous insertion method has improved a lot, but at the same time, the real-time data reading needs to be sacrificed.

There are many asynchronous methods. The current method is to convert the data in the temporary table to the real table at intervals (5 min, 10 min .. depending on the requirement setting) of the job.

1. the original table A is actually used for reading.

2. create B and C in the same structure as the original table A for data transfer. the synchronization process is C-> B->.

3. create A job Job1 for data synchronization and A table that records the running status of Job1. during data synchronization, it is important to check the current status of Job1. if data of B is being synchronized to, store the data from the server to C, then import the data to B, and then transfer the data to A when the next Job is executed. 1:

You can use the SQL query trace to capture the time-consuming queries, and use the stored procedure sp_lock, dm_tran_locks, and dblockinfo to view the types and granularity of the locks of the current instance.

Find the specific query statement or stored procedure, and then take the right action! Medicine is eliminated!

The above is all the content of this article. I hope this article will help you in your study or work, and I also hope to support PHP!

For more articles about Sqlserver high concurrency and big data storage solutions, please follow the PHP Chinese network!