Alwayson2016 AG 可以提供企業
Always Encrypted功能將資料庫一些敏感資料永遠加密,
SQL2012和SQL2014永遠只會讀取read-only routing list中第一個可用複本,
SQL2016 In-Memory OLTP,現在可以讓我們很方便將資料存放至Memory table。
Disk Base我們會切多個data file在不同Disk drives來提高I/O效能(也分散I/O),
Memory table將所有資料都存放到記憶體,內部針對每一筆資料建立multiple versions避免blocking情況
善用交易效能分析報表,預估資料表或SP移轉至In-Memory效益
SQL2014 提供 ARM(Analysis Migration and Reporting) Tool1.Configure Data Warehouse2.Configuration Data collection3.Generate transaction performance analysis reports to identify performance-critical tables and stored procedures
SQL2016 AG開始支援MSDTC,MSDTC幫我們保證分散式交易的一致性,
These were the top 10 stories published by RiCosNote in 2017. You can also dive into monthly archives for 2017 by using the calendar at the top of this page.