SQL Server新一代的内存管理技术-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

SQL Server新一代的内存管理技术

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 05:54 PM

sql serverMemorymanagement technology

在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 分析引擎的结合将产生极佳的组合效果

现有应用程序完全可从这一新技术中受益，首先通过微软提供的分析工具确定最常用/负荷最重的表和存储过程，然后配置服务器将这些表迁移到系统主内存里（如下）.

SQL Server新一代的内存管理技术

而操作这些表的存储过程可以直接编译成本地代码从而加快执行速度（如下）

SQL Server新一代的内存管理技术

我们的客户测试显示在同一硬件下性能有5 ~ 50倍的提高。实际的性能提高还取决于多种因素，比如你迁移了多少张表到Hekaton等等。

Hekaton现在已经进入预览阶段，已经有一些客户在试运行这个技术。如果你对试运行感兴趣的话，你也可以联系微软。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AM

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AM

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

See all articles