SQL Server新一代的内存管理技术
在2012年度的SQL Server(PASS)峰会(SQL Server专业人士的技术会议)上,微软发布了代码名为Hekaton的新功能,一个完全针对事务处理(TP)的内存数据管理系统。Hekaton 的技术主要适合于那些对事务处理要求极其苛刻的应用,比如金融服务公司、在线游戏等等。
在2012年度的SQL Server(PASS)峰会(SQL Server专业人士的技术会议)上,微软发布了代码名为”Hekaton”的新功能,一个完全针对事务处理(TP)的内存数据管理系统。Hekaton 的技术主要适合于那些对事务处理要求极其苛刻的应用,比如金融服务公司、在线游戏等等。对于 Hekaton 最令人印象深刻的是它不是一个单独的数据管理产品或者一个需要新的编程模型来实现 TP 能力突破性提高的系统, 它仍是 SQL !
目前为止,大部分基于内存中的数据管理系统都是围绕列存储技术为核心的分析负载。SQL Server 在2012的版本里面也已经发布了基于同样技术的xVelocity 分析引擎和 xVelocity列存储索引。而Hekaton则是一项基于行的技术,完全集中在事务处理 (TP) 的工作负载。而且更令人兴奋的时这两种技术并不相互排斥。Hekaton 和 SQL Server 现有 xVelocity 列存储索引与 xVelocity 分析引擎的结合将产生极佳的组合效果
现有应用程序完全可从这一新技术中受益,首先通过微软提供的分析工具确定最常用/负荷最重的表和存储过程,然后配置服务器将这些表迁移到系统主内存里(如下).
而操作这些表的存储过程可以直接编译成本地代码从而加快执行速度(如下)
我们的客户测试显示在同一硬件下性能有5 ~ 50倍的提高。 实际的性能提高还取决于多种因素,比如你迁移了多少张表到Hekaton等等。
Hekaton现在已经进入预览阶段,已经有一些客户在试运行这个技术。如果你对试运行感兴趣的话,你也可以联系微软。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

If you encounter the problem of insufficient printer memory when printing Excel worksheets or PowerPoint presentations, this article may be helpful to you. You may receive a similar error message stating that the printer does not have enough memory to print the page. However, there are some suggestions you can follow to resolve this issue. Why is printer memory unavailable when printing? Insufficient printer memory may cause a memory not available error. Sometimes it's because the printer driver settings are too low, but it can also be for other reasons. Large file size Printer driver Outdated or corrupt Interruption from installed add-ons Misconfiguration of printer settings This issue may also occur because of low memory settings on the Microsoft Windows printer driver. Repair printing

For mechanical hard drives or SATA solid-state drives, you will feel the increase in software running speed. If it is an NVME hard drive, you may not feel it. 1. Import the registry into the desktop and create a new text document, copy and paste the following content, save it as 1.reg, then right-click to merge and restart the computer. WindowsRegistryEditorVersion5.00[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager\MemoryManagement]"DisablePagingExecutive"=d

Recently, Xiaomi released a powerful high-end smartphone Xiaomi 14Pro, which not only has a stylish design, but also has internal and external black technology. The phone has top performance and excellent multitasking capabilities, allowing users to enjoy a fast and smooth mobile phone experience. However, performance will also be affected by memory. Many users want to know how to check the memory usage of Xiaomi 14Pro, so let’s take a look. How to check memory usage on Xiaomi Mi 14Pro? Introduction to how to check the memory usage of Xiaomi 14Pro. Open the [Application Management] button in [Settings] of Xiaomi 14Pro phone. To view the list of all installed apps, browse the list and find the app you want to view, click on it to enter the app details page. In the application details page
![Windows input encounters hang or high memory usage [Fix]](https://img.php.cn/upload/article/000/887/227/170835409686241.jpg?x-oss-process=image/resize,m_fill,h_207,w_330)
The Windows input experience is a key system service responsible for processing user input from various human interface devices. It starts automatically at system startup and runs in the background. However, sometimes this service may automatically hang or occupy too much memory, resulting in reduced system performance. Therefore, it is crucial to monitor and manage this process in a timely manner to ensure system efficiency and stability. In this article, we will share how to fix issues where the Windows input experience hangs or causes high memory usage. The Windows Input Experience Service does not have a user interface, but it is closely related to handling basic system tasks and functions related to input devices. Its role is to help the Windows system understand every input entered by the user.

When novice users buy a computer, they will be curious about the difference between 8g and 16g computer memory? Should I choose 8g or 16g? In response to this problem, today the editor will explain it to you in detail. Is there a big difference between 8g and 16g of computer memory? 1. For ordinary families or ordinary work, 8G running memory can meet the requirements, so there is not much difference between 8g and 16g during use. 2. When used by game enthusiasts, currently large-scale games basically start at 6g, and 8g is the minimum standard. Currently, when the screen is 2k, higher resolution will not bring higher frame rate performance, so there is no big difference between 8g and 16g. 3. For audio and video editing users, there will be obvious differences between 8g and 16g.

According to the report, Samsung Electronics executive Dae Woo Kim said that at the 2024 Korean Microelectronics and Packaging Society Annual Meeting, Samsung Electronics will complete the verification of the 16-layer hybrid bonding HBM memory technology. It is reported that this technology has passed technical verification. The report also stated that this technical verification will lay the foundation for the development of the memory market in the next few years. DaeWooKim said that Samsung Electronics has successfully manufactured a 16-layer stacked HBM3 memory based on hybrid bonding technology. The memory sample works normally. In the future, the 16-layer stacked hybrid bonding technology will be used for mass production of HBM4 memory. ▲Image source TheElec, same as below. Compared with the existing bonding process, hybrid bonding does not need to add bumps between DRAM memory layers, but directly connects the upper and lower layers copper to copper.

This site reported on March 21 that Micron held a conference call after releasing its quarterly financial report. At the conference, Micron CEO Sanjay Mehrotra said that compared to traditional memory, HBM consumes significantly more wafers. Micron said that when producing the same capacity at the same node, the current most advanced HBM3E memory consumes three times more wafers than standard DDR5, and it is expected that as performance improves and packaging complexity intensifies, in the future HBM4 This ratio will further increase. Referring to previous reports on this site, this high ratio is partly due to HBM’s low yield rate. HBM memory is stacked with multi-layer DRAM memory TSV connections. A problem with one layer means that the entire

According to news from this website on May 6, Lexar launched the Ares Wings of War series DDR57600CL36 overclocking memory. The 16GBx2 set will be available for pre-sale at 0:00 on May 7 with a deposit of 50 yuan, and the price is 1,299 yuan. Lexar Wings of War memory uses Hynix A-die memory chips, supports Intel XMP3.0, and provides the following two overclocking presets: 7600MT/s: CL36-46-46-961.4V8000MT/s: CL38-48-49 -1001.45V In terms of heat dissipation, this memory set is equipped with a 1.8mm thick all-aluminum heat dissipation vest and is equipped with PMIC's exclusive thermal conductive silicone grease pad. The memory uses 8 high-brightness LED beads and supports 13 RGB lighting modes.
