SQLServer2014新功能.PDF

SQL Server 2014鏂板姛鑳 鏁版嵁搴撶鐞嗛儴鍏充簬SQL Server 2014鏁版嵁寮曟搸鐨勭爺绌 瀹嬫矂鍓 careyson@163.com 鐩綍 OLTP鐩稿叧鏂板鍔熻兘 HA/DR鐩稿叧鏂板鍔熻兘 OLAP鍦ㄦ暟鎹紩鎿庣浉鍏虫柊澧炲姛鑳 鏉傞」 OLTP鐩稿叧鏂板鍔熻兘 鍐呭瓨鏁版嵁搴擄紙浠ｅ彿Hekaton 锛 浠€涔堟槸Hekaton 闆嗘垚鍏QL Server鐨勫彟涓€濂楀唴瀛樻暟鎹簱寮曟搸 锛岄伒寰簨鍔＄殑 ACID鍘熷垯 锛堝彲浠ラ€氳繃閫夐」涓嶆敮鎸丏 锛夈€傛湁濡備笅鐗圭偣锛 鈥 闆嗘垚鍦⊿QL Server寮曟搸涓 鈥 鏁版嵁鐨勭粨鏋勯拡瀵瑰唴瀛樹紭鍖 锛圚ash Index 锛 鈥 鍒╃敤澶氱増鏈鎺у埗鍘婚櫎閿 锛堝寘鎷琹ock銆乴atch銆乻pinlock 锛 鈥 鏈湴缂栬瘧瀛樺偍杩囩▼鍙互灏員-SQL缂栬瘧鎴愭満鍣ㄧ紪鐮 Hekaton閫傜敤鍦烘櫙 搴斿瓨鍦ㄥぇ閲忛攣绛夊緟 楂樺苟鍙戯紝灏忎簨鍔 瀛樺偍杩囩▼涓ぇ閲忓鏉傞€昏緫闇€瑕佷紭鍖 Summary锛氬吀鍨婳LTP鍦烘櫙 鎵€鏀寔鐨勯殧绂荤骇鍒 蹇収锛堥粯璁わ紝鎵€璇荤殑鏁版嵁鏄簨鍔″紑濮嬫椂鐨勬暟鎹級 鍙噸澶嶈 搴忓垪鍖 Hekaton浣跨敤鐩稿叧鍙樺寲 琛ㄧ浉鍏 鈥 琛ㄧ粨鏋勪笉鑳芥敼锛屾病鏈堿lter Table 锛屾敼琛ㄧ粨鏋勫繀椤婚噸寤烘柊琛 鈥 娌℃湁LOB鏁版嵁绫诲瀷锛圱ext 锛寁archar(max)锛夛紝琛屽ぇ灏忎笉鑳借秴杩?060 鈥 闄や富閿锛屼笉鏀寔浠讳綍绾︽潫 鈥 鏃犺嚜澧炲拰璁＄畻鍒楋紝涓嶆敮鎸丆LR绫诲瀷 DBA鐩稿叧闇€瑕佽€冭檻 鈥 鎸佷箙鍜岄潪鎸佷箙锛圫CHEMA_ONLY vs. SCHEMA_AND_DATA 锛 鈥 鍐呭瓨琛ㄥ繀椤绘斁鍏ュ唴瀛樹紭鍖栨枃浠剁粍 鈥 浜嬪姟鏃ュ織鍑忓皯 鍐呭瓨鏁版嵁搴擄紙浠ｅ彿Hekaton锛 寮€鍙戜汉鍛橀渶瑕佽€冭檻 骞跺彂鍐欏啿绐 锛屽叾涓悗鍐欎細澶辫触銆傛墍浠ョ▼搴忛噷蹇呴』鏈塕etry鐨 鏈哄埗 锛堝洜姝ら伩鍏嶈繍琛屾椂闂撮暱鐨勪簨鍔 锛 鍐呭瓨浼樺寲琛ㄥ垱寤烘柟寮 鏈湴缂栬瘧瀛樺偍杩囩▼閫傜敤鍦烘櫙鍜屽眬闄 閫傜敤鍦烘櫙 鈥 OLTP寮忔煡璇 鈥 瀛樺偍杩囩▼涓寘鍚奖鍝嶆€ц兘鐨勫鏉備笟鍔￠€昏緫 灞€闄愭€ 鈥 鍙兘璁块棶鍐呭瓨浼樺寲琛ㄦ暟鎹 鈥 浣跨敤璇ョ被瀛樺偍杩囩▼涓煇浜涜鍙ユ棤娉曢€傜敤锛堝弬鑰 锛歨ttp:///en- us/library/dn452279.aspx#qsancsp 锛 鍙兘鐨勬姤閿 鍐呭瓨涓嶅 鈥 浜嬪姟澶辫触 Recover 鍐呭瓨浼樺寲琛ㄦ椂鍐呭瓨涓嶈冻 鈥 鎶ラ敊 闈炲唴瀛樹紭鍖栬〃鍐呭瓨琚唴瀛樹紭鍖栬〃鎸ゅ崰鍐呭瓨杩囧 鈥 鏈敤鍒板唴瀛樹紭鍖栬〃鐨勪簨鍔″紑濮嬪け璐 鎬ц兘娴嬭瘯 浜嬪姟寤惰繜鍐 鍑虹幇鑳屾櫙 鈥 浼犵粺鍏崇郴鏁版嵁搴撲负浜嗕繚鎸丄CID 涓殑D锛岄渶瑕乄rite Ahead Log鏉ュ疄 鐜帮紝鍗充负浜嬪姟鍦ㄦ彁浜や箣鍓嶏紝蹇呴』鍏堝啓鍏ユ棩蹇椼€傚洜姝ゅ湪鏌愪簺鎯呭喌涓嬶紝 鍐欐棩蹇楃殑IO鍙兘鎴愪负鎬ц兘鐡堕锛堝彲浠ヨ娴嬬瓑寰呯被鍨嬬殑WriteLog绛 寰咃級 SQL Server 2014涓湪鏁版嵁搴撶