Supercharge Your Innovation With Domain-Expert AI Agents!

Method and device for managing number of processor cores under sql database

A processor core, processor technology, applied in the computer field, can solve problems such as poor performance, the number of processor cores not reaching the maximum value, and the excessive utilization of processor cores, etc., to achieve the effect of improving performance

Active Publication Date: 2022-03-22
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] At present, when the Windows system groups processors with a total core number greater than 64, the automatic grouping generally distributes the NUMA nodes evenly, which often results in the number of cores in a processor group not reaching the maximum value.
If the number of processor cores cannot be utilized as much as possible when starting a single instance of the SQLServer database, resulting in relatively poor performance

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for managing number of processor cores under sql database
  • Method and device for managing number of processor cores under sql database
  • Method and device for managing number of processor cores under sql database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

[0051] Under the Windows 2008 system, the system automatically groups the number of processor cores greater than 64. Generally, when the number of processor cores is greater than 64 but less than 128, the operating system will automatically group the number of processor cores on average. For example, when the system has 80 cores and two NUMA nodes, divide them into two groups of 40+40 cores. In this case, when the sqlserver instance is started under the Windows 2008 system, it will only run on a 40-core group, which cannot give full play to the advantages of the mu...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a method and a device for managing the number of processor cores under an SQL database. The method includes: under the Windows2008 system, after detecting the request to run the SQL server database, obtaining at least two target processor groups in the non-uniform memory access architecture NUMA node that respond to the request of the SQL server database; grouping the at least two The target processor groups are adjusted to processor groups with different total cores; after the processor groups are adjusted, the adjusted processor groups are used to respond to the request of the SQL server database.

Description

technical field [0001] The invention relates to the field of computers, in particular to a method and a device for managing the number of processor cores under an SQL database. Background technique [0002] In the Windows system, when the number of processor cores of the physical server is greater than 64 cores, the system will group the processor cores. When processing grouping, factors of NUMA (Non Uniform Memory Access Architecture, non-uniform memory access architecture) nodes are considered, and processor cores of the same NUMA node are grouped into one group. For example, in a SQL Server database, when a single instance is running, it can only be assigned to a single processor group. [0003] In the course of realizing the present invention, the inventor finds that the prior art has the following problems: [0004] At present, when the Windows system groups processors with a total core number greater than 64, the automatic grouping generally distributes the NUMA node...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F9/50
CPCG06F9/5016G06F9/5027
Inventor 刘丽
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com