microsoft sql server 2014ÊÇÒ»¿î΢ÈíÖйúµÄÊý¾Ý¹ÜÀíרÓù¤¾ß£¬Õâ¶ùÎÒÒѾ½«32λºÍ64λϵͳÈí¼þ¿ÉÓõÄsql server 2014´«µ½°Ù¶ÈÔÆÍøÅÌ£¬Óë´ËͬʱҲ±£Ö¤ÁË¿ª·¢°æ¡¢±êÅä¡¢ÆóÒµ°æѸÀ×ÔÚÏßÏÂÔصÄÏêϸµØÖ·£¬±ã½Ý´ó»ï¶ùËæʱÔÚÏßÏÂÔØ¡£
sql server 2014²úÉúÁË¿ª´´ÐÔµÄÐÔÄܺÍÈ«ÐÂÉý¼¶µÄin-memoryÌá¸ß¼¼ÊõÐÔ£¬ÒÔÐÖú¹Ë¿Í¼Ó¿ìÒµÎñÁ÷³ÌºÍÏòÈ«ÐÂÉý¼¶µÄÓ¦Óó¡¾°¿ªÕ¹×ª»»¡±¡£
SQL Server 2014£º×öΪȫÊÀ½ç²¼Êð×îÆÕ±éµÄÊý¾Ý¿â²éѯ£¬¸Ãȫа汾ƒÈ½¨µÄin-memory¼¼ÊõÐÔ£¬¿É²úÉú¼´Ê±µÄÐÔÄܸÄÉÆ£»¶øMicrosoft AzureÔƼÆËãƽ̨£¬Òà´øÀ´Á˳öÉ«µÄµ¯ÐÔºÍÔÖ»öÐÞ¸´ÐÔÄÜ¡£
Microsoft Azure¡°ÖÇÄÜ¿ØÖÆϵͳ·þÎñÏîÄ¿¡±µÄ¡°±È½ÏÓÐÏÞ¹«¹²ÐÔä¯ÀÀ¡±£ºÕâÒ²ÊÇÒ»ÏîеÄAzure·þÎñÏîÄ¿£¬ÖÂÁ¦ÓÚÐÖú¹Ë¿ÍÓÀ´ÎïÁªÍø¼¼ÊõµÄÀ´ÁÙ£¬°²È«ÐÔµØÁª½Ó¡¢¹ÜÀí·½·¨ºÍËѼ¯À´Ô´ÓÚ¸ÐÓ¦Æ÷Óë»úÆ÷É豸µÄ¡°É豸ת»¯³ÉÊý¾ÝÐÅÏ¢¡±£¬¶øÎÞ¹ÜÆäÑ¡ÓõÄÄÄÒ»ÖÖµçÄÔ²Ù×÷ϵͳ¡£
ÆÊÎö·þÎñƽ̨ϵͳÈí¼þ(Analytics Platform System)£ºAPSÒԳɱ¾µÍµÄ·½·¨£¬ÈÚºÏÁË΢Èí¹«Ë¾×îºÃµÄSQL ServerÊý¾Ý¿â²éѯ¡¢¼°ÆäHadoop¼¼ÊõÐÔ£¬¸øÓèÁËÍ걸µÄ»¥ÁªÍø´óÊý¾Ý½â¾ö·½·¨(big data in a box)¡£
SQL Server 2014Òý½øµÄin-memory×÷Ó㬲úÉúÁËÔÚ½â¾ö¸÷ÖÖ¸÷ÑùÊý¾ÝÐÅϢʱµÄÐÔÄÜÌáÉý¡¢»õÔËÁ¿Ìá¸ß¡¢¼°ÆäÑӳٵĸĽø¡£¸Ã¼¼ÊõÐÔ¿ÉÒÔ·É¿ì½â¾öÊýÒÔ°ÙÍòÌõµÄ¼Í¼£¬ÄËÖÁ¸ù¾ÝSQL ServerÆÊÎö·þÎñÏîÄ¿£¬ÇáÇáËÉËÉÍØÕ¹ÖÁÊýÒÔ¼¸Ê®ÒڼƵÄÂ߼˼άÄÜÁ¦¡£
ÊÊÓÃOLTPµÄin-memory Êý¾Ý¿âÒýÇ棬¾ÝÎÒÕÆÎÕ£¬HekatonµÄstorage engine´¦ÀíʼþµÄ·½·¨¸ú´«Í³Ê½µÄÄ£¿éÓкܴóµÄ²î±ð£¬¾Ý΢Èí¹«Ë¾³Æ£¬¹Ë¿ÍÓ¦ÓÃÒÔºó£¬ÔÚûÓÐÐ޸ıàÂë/ºÜСÐ޸ĵÄÇéÐÎÏ£¬ÐÔÄÜÌá¸ßÁË10¼¸±¶¡£
µ«¾ÝÖйúһЩMVP·´Ó³£¬ËýÃÇÓ¦ÓÃȲ¿°æ±¾µÄ¼ì²â×´¿öÀ´¿´£¬ÐÔÄÜ›]ÓÐÌá¸ßµÄÄÇô¶à¡£
microsoft sql server 2014ͼÎIJ¢Ã¯°²×°ÊµÀý½Ì³Ì
ÌáÐÑ£º¶àÌØÈí¼þÕ¾ÎÒÕâ¶ù¸øÓèµÄÊÇsql2014ººÓï°²×°°ü£¬Óеã¶ù´ó£¬Çë´ó»ï¶ùϸÐÄÔÚÏßÏÂÔØ£¡ÔÚÏßÏÂÔØ»º½âѹÁ¦ºó£¬»á»ñµÃÈçÏÂËùʾÎĵµ£¬ÈçÏÂͼ£ºÔË×÷¡°setup.exe¡±
ÌáÐÑ£ºÕâÒ»°²×°Ò³Ãæ³öÈ¥ºÃÏñÓеã¶ùÂý£¬Çë´ó»ï¶ùϸÐÄÕâЩÏ£¡
µãÒ»ÏÂ×ó±ßµÄ¡°°²×°¡±£¬ÌôÑ¡¡°È«ÐÂÉý¼¶SQL Server 2014 °²×°...¡±£¨Õâһȫ¹ý³ÌÓÖÓеã¶ùÓƳ¤£¬ÄÍÐĵȴýÒ»»á¶ù£©
Ëæºó»áµ¯³öÀ´ÕâÒ»Ò³Ã棺ĬÈÏÉèÖÃÊÇÁ¢¼´ÓÐÃÜÔ¿µÄ£¬²»ÓÃÄãÊÖ¶¯Ê½¼üÈ룬µãһϡ°ÏÂÒ»²½¡±
Õâ¶ù¾Í·Ç³£¼òµ¥ÁË£¬Á¢¼´ÌôÑ¡¡°ÎÒ½ÓÄÉ...¡±£¬ÏÂÒ»²½
±ê×¼²éÑ飬ÉÔµÈÒ»»á¶ùÓ´
updateÉý¼¶¾Í²»ÏëÒªÁË£¬¼áÐźܶàÈ˶¼Á¢¼´½ûֹʹÓÃÁËÕâÒ»Éý¼¶£¬µãһϡ°ÏÂÒ»²½¡±
É趨ÈËÎï½ÇÉ«Ò³Ã棺µÚÒ»¸öÊÇ×Ô¶¨£¬µÚ¶þ¸öÊÇ»ù±¾×÷Óð²×°£¬µÚÈý¸öÊdz¹µ×°²×°£¨¼´È»ÎÒÃǶ¼ÊÇSQL Server 2014ÉÌÒµ°æ£¬¾Íû±ØҪѡµÚ¶þ¸ö£¬Òª²»ÊǶ๦ÄÜ£¬Òª²»ÊÇÒÀ¾Ý×ÔÉíµÄ±ØÐëÀ´ÌôÑ¡×÷Óã©
ÎÒÕâ¶ùÌôÑ¡Á˵ÚÒ»¸ö£¬°²×°¶à¹¦Äܵû°£¬±ØÐëÕ¼ÓÐ6GBµÄ´ÅÅ̿ռ䣬Ïà¶ÔÐÔÓÚÈç½ñ¶¯ÔòºÃ¶à¸öTµÄµçÄÔÓ²ÅÌ£¬Õⶼ²»ÊÇʶù°É...£¨ËæºóϱߵݲװÎļþĿ¼×ÔÉí½ç¶¨£¬¿ÉÊÇÈý¸öÎļþĿ¼ǧÍò±ð·Åµ½²»Ò»ÑùµÄÅÌ·û£¡£©
ÌôÑ¡°²×°°¸Àý£¬ÎÒÕâ¶ù¾ÍÁ¢¼´Ä¬ÈÏÉèÖÃÁË...
·þÎñÆ÷µÄÅäÖãºÕâÒ»ºóÃæ¿ÉÒԸģ¬×ÔÈ»£¬ÄãÈç½ñÏë¼òÒ×µÄÅ䱸ÏÂÒ²ÊÇ¿ÉÒÔµÄ
Êý¾Ý¿âÒýÇæÅ䱸£º×îÏȼÓÉÏÒ»¸ö¹ÜÀíÈËÔ±£¬¸öÈ˼ÆËã»úµÃ»°Á¢¼´¼ÓÉϵ±½ñ¿Í»§£¬¹«¹²µÃ»°×ÔÖ÷É趨
ËæºóÅ䱸Éí·ÝÈÏÖ¤·½Ê½£¬¿ÉÒÔ²»ÐèÒªµÇ½ÃÜÂ룬»¹¿ÉÒÔÉ趨»ìºÏģʽ£¬Ò²¾ÍÊǵ±½ñµÄ¹ÜÀíÈËÔ±»òÊÇÓõǽÃÜÂ붼Äܹ»Ò»ÇÐÕý³£µÇ¼
ÕâÒ»²½»¹Äܹ»Å䱸Êý¾ÝÐÅÏ¢ÎļþĿ¼£¬ÖкóÆÚÒ²ÊÇ¿ÉÒÔËæÒâµ÷½ÚµÄ
Analysis ServicesÅ䱸£ºÕâ¸öÊÇÊý¾Ý¿â²éѯÆÊÎö×÷Ó㬼ÓÉϸö¹ÜÀíÈËÔ±½øÈ¥£¬Ëæºó¡°ÏÂÒ»²½¡±
Reporting Services Å䱸£ºÕâ¸öÊÇÊý¾Ý¿â²éѯ²ÆÎñ±¨±í£¬Ç¿ÁÒÍƼö¡°°²×°ºÍÅ䱸¡±£¬¼òÒ×±ã½Ý
Distributed Replay¿ØÖư壺ÕâһͬÑù£¬¼ÓÉϹÜÀíÈËÔ±£¬¡°ÏÂÒ»²½¡±
É趨Distributed ReplayÊÖ»ú¿Í»§¶ËµÄÃû×ÖºÍÎļþĿ¼£¬¡°ÏÂÒ»²½¡±
È·¶¨ÏÂÄãÐèÒª°²×°µÄÐÅÏ¢ÄÚÈÝ£¬È·¶¨×¼È·ÎÞÎóºó£¬µãһϡ°°²×°¡±
°²×°ing...¾²¾²µÄµÈ´ý£¬ÎҵĵçÄÔÉÏÒ²¾Í×°ÁËÒ»¸ö¶à¶àÖÓÍ·°É...
ºÃÀ²£¬µÈºòÁËÄÇô¾Ã×ÜËãÈ¡µÃ³É¹¦°²×°SQL Server 201£¬µÈºòÊǷdz£ÖµµÃµÄ...Èç½ñ¾Í¿ÉÒÔÃâ·ÑÊÔÓÃSQL2014ÏÂÔØÀ²
sql server 2014µÄÌØÐÔ
1£¬HekatonÑ¡ÓÃoptimistic multiversion concurrency control (MVCC)ÌåÖÆ£¬Ò²¾ÍÊÇÑ¡ÓÃHekatonµÄÊÂÎñ¹ÜÀí²»»áÔÙ±ØÐëLOCK/latch£¬³ÆΪÎÞblocking£¨ÒÀ¾ÝÎҹ۲飬blocking»òÊÇÓеģ¬ÀýÈçÔÚconflict²éÑéµÄÇé¿öÏ£¬¿ÉÊÇûÁËLOCK/latch£¬blockingºÁÎÞÒÉÎÊ´ó´ó¼õÉÙ£©,ÎÞdeadlock¡£
2£¬Hekaton½â¾öµÄÊý¾ÝÐÅÏ¢ÊÂÏÈËùÓд¢´æÔÚÔËÐÐÄÚ´æÖУ¬Òò´Ë·ÀÖ¹ÁË physical io.
3£¬Transaction LoggingÊÂÎñ¹ÜÀí¸ú´«Í³Ê½Êý¾Ý¿âÒýÇæÓַdz£´óµÄ²î±ð¡£
´«Í³Ê½Êý¾Ý¿â²éѯֻÓдÎÐòдÈÕÖ¾£¬¶øHekaton¿ÉÒÔ²¢Ðд¦ÀíдºÃ¼¸¸öÈÕÖ¾Á÷ÁË£¡
£¬¶øÇÒ²»Ó¦ÓÃwrite-ahead logging £¬Hekatonʲôʱºò×ölogging?»Ø´ðÊǽöÓÐÔÚÈÏÖ¤ÊÂÎñ¹ÜÀí¿ÉÒÔÈ¡µÃ³É¹¦µÝ½»£¨ºÜÞÖ¿Ú°É£¬Ê²Ã´ÊÇÈÏÖ¤ÊÂÎñ¹ÜÀí¿ÉÒÔÈ¡µÃ³É¹¦µÝ½»£¿ÕâÒ²ÊÇMVCC¶¨Ò壬ÓÐʱ¼äÏ꾡½²£©µÄÇéÐÎÏÂÄÜÖð½¥×ölogging£¬ÅóÓÑHekaton›]ÓÐUNDOµÄ¶¨Ò壬Ϊʲô›]ÓÐUNDO£¬ÒòΪËü›]ÓÐдÔàÒ³µÄ¶¨Òå¡£
4,»á½«T-SQL±àÒë³ÌÐòΪnative code£¬¾Ý΢Èí¹«Ë¾¼ì²â£¬Óм¸±¶µÄÐÔÄÜÌá¸ß¡£
Òò´ËÎÒ¾õµÃÌÈÈôÄãµÄ×ÓϵͳÓÐÉϱßÕâÖֶ̰壬ÀýÈçLOCK/latch£¬Transaction LoggingµÄдµÈÎÊÌ⣬ÄÇôÄãµÄÔöÇ¿ÊǺÜÏÔÈ»µÄ¡£
¶þ£©resource governorÔçÒÑÊÊÓöÔIO ²Ù×Ý¡£
Èý£©Buffer pool ¶ÔSSDµÄÔËÓü«´óµØÌáÉýÁËÐÔÄÜ£¨ÕâÒ»²¢²»ÊÇƽ³£Ëµ¼òÒ׵ĸü»»µçÄÔÓ²ÅÌÊÇSSD£¬µ«ÊÇÏ꾡µÄÎÒ¶¼Ã»ÓпÆѧÑо¿¹ý£º-£©£©
ËÄ£©Query-processing²ãÃæµÄÔÙ´ÎÉè¼Æ·½°¸¡£
Cardinality EstimatorµÄÓÅ»¯Ëã·¨ÔçÒѵ÷ÓÃÁË£¬¸üΪ¾«È·µÄcardinality estimates.
Î壩ColumnStore IndexÔçÒÑÈç½ñ¿ÉÉý¼¶ÁË
µ«ÊÇÕâÒ»´óÁ¿Ó¦µ±ÒýÈëÔÚBI²ãÃæ
SQL Server 2014°²×°±íÃ÷
ÔÚÏßÏÂÔØ°²×°ÒÔÇ°Îñ±ØÏÈÕÆÎÕÏÂÁÐÊÂÒË£º
²»¼æÈÝÔÚÒÑ°²×°±ðµÄ°æ±¾µÄÉ豸ÉÏ°²×° SQL Server 2014
²»¼æÈÝ´Ó±ðµÄ°æ±¾ÉϸüÐÂ
Ö»ÓÐÓ¦Óà SQL Server Management Studio À´¹ÜÀí·½·¨¸Ã°æ±¾
²»¼æÈÝÔÚÅäÓÐ visual studio 2012 »òÊǸüÔç°æ±¾µÄ Visual Studio ÉÏ°²×°
¼ÙÈçÄãÔçÒÑÅäÓÐ SQL Server »òÊÇ Visual Studio £¬ÄÇüN°²×°±ã»áÅ׳öÈ¥²éÑé²»ÕýÈ·¶øÇÒÖÕÖ¹°²×°£¬ÄãÄÜÓ¦ÓÃvmÐéÄâ»úÀ´°²×°¡£
ÔË×÷ @@version ¿ÉÄÜ»ñµÃÈçÏÂËùʾÐÅÏ¢ÄÚÈÝ£º
Microsoft SQL Server 2014 (CTP1) - 11.0.9120.5 (X64)
Jun 10 2013 20:09:10
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows NT 6.2
SQL Server 2014 ¹Ù·½Íø×îа汾µç¿ÏÂÔØ¡¢Ñ¸À×ÖÖ×ÓÏÂÔØ£º
ed2k://|file|en_sql_server_2014_ctp1_x64_dvd_2361912.iso|3527368704|778C550337A31386FF42C5F71F4D5555|/
SQL Server 2014 Web°æϵÁкÅÃÜÔ¿£º J9MBB-R8PMP-R8WTW-8JJRD-C6GGW
SQL Server 2014 Standard±êÅäϵÁкÅÃÜÔ¿£º P7FRV-Y6X6Y-Y8C6Q-TB4QR-DMTTK
SQL Server 2014 Developer¿ª·¢°æϵÁкÅÃÜÔ¿£º 82YJF-9RP6B-YQV9M-VXQFR-YJBGX
SQL Server 2014 EnterpriseÉÌÒµ°æϵÁкÅÃÜÔ¿£º 27HMJ-GH7P9-X2TTB-WPHQC-RG79R
SQL Server 2014 Enterprise Core¹«Ë¾¹Ø¼ü°æϵÁкÅÃÜÔ¿£º TJYBJ-8YGH6-QK2JJ-M9DFB-D7M9D
SQL Server 2014 Business IntelligenceÉÌÎñÖÇÄÜ°æϵÁкÅÃÜÔ¿£º GJPF4-7PTW4-BB9JH-BVP6M-WFTMJ
¶àÌØÈí¼þרÌâΪÄúÌṩÊý¾Ý¿â¹¤¾ß,Êý¾Ý¿â²éѯ¹¤¾ß,Êý¾Ý¿âÁ¬½Ó¹¤¾ß;°²×¿Æ»¹û°æÈí¼þappÒ»Ó¦¾ãÈ«¡£¶àÌØÈí¼þÕ¾Ö»ÌṩÂÌÉ«¡¢ÎÞ¶¾¡¢ÎÞ²å¼þ¡¢ÎÞľÂíµÄ´¿ÂÌÉ«¹¤¾ßÏÂÔØ
¶àÌØÈí¼þרÌâΪÄúÌṩÊý¾Ý¿âÈí¼þ,Ãâ·ÑÊý¾Ý¿âÈí¼þ,Êý¾Ý¿âÈí¼þÅÅÐÐ;°²×¿Æ»¹û°æÈí¼þappÒ»Ó¦¾ãÈ«¡£¶àÌØÈí¼þÕ¾Ö»ÌṩÂÌÉ«¡¢ÎÞ¶¾¡¢ÎÞ²å¼þ¡¢ÎÞľÂíµÄ´¿ÂÌÉ«¹¤¾ßÏÂÔØ
¶àÌØÈí¼þ԰ΪÄúÕûÀíÁ˶à¿îpptĿ¼ģ°å´óÈ«Èí¼þ£¬ÔÚ¶àÌØÄúÄÜÏÂÔضà¿îÕý¹æµÄ¡¢ÎÞ¶¾Èí¼þ£¬ÆäÖÐÓÐPPTÄ£°å¡¢PPTÄ£°åÖúÊÖ¡¢pptÄ£°å´óʦµÈApp£¬ÕÒÈí¼þÒ»¶¨ÒªÕÒÕý¹æƽ̨£¬¶àÌØÿһ¿îÈí¼þ¶¼½øÐвéɱ£¬È·±£Èí¼þ°²È«£¬ÏëÒªÕÒpptĿ¼ģ°å´óÈ«Ó¦Ó㬸ϽôÀ´¶àÌØÈí¼þÔ°¿´¿´°É¡£
¶àÌØÈí¼þ԰ΪÄúÕûÀíÁ˶à¿îfcÓÎÏ·´óȫĿ¼Èí¼þ£¬ÔÚ¶àÌØÄúÄÜÏÂÔضà¿îÕý¹æµÄ¡¢ÎÞ¶¾Èí¼þ£¬ÆäÖÐÓбùÇò fcÓÎÏ·¡¢¸ß¶û·ò FCÓÎÏ·¡¢Ä§·¨ÆøÅÝ FCÓÎÏ·µÈApp£¬ÕÒÈí¼þÒ»¶¨ÒªÕÒÕý¹æƽ̨£¬¶àÌØÿһ¿îÈí¼þ¶¼½øÐвéɱ£¬È·±£Èí¼þ°²È«£¬ÏëÒªÕÒfcÓÎÏ·´óȫĿ¼ӦÓ㬸ϽôÀ´¶àÌØÈí¼þÔ°¿´¿´°É¡£
¶àÌØÈí¼þ԰ΪÄúÕûÀíÁ˶à¿îpspÓÎÏ·´óȫĿ¼Èí¼þ£¬ÔÚ¶àÌØÄúÄÜÏÂÔضà¿îÕý¹æµÄ¡¢ÎÞ¶¾Èí¼þ£¬ÆäÖÐÓÐPSPÓÎϷת»»Æ÷(PSPGameConvert)¡¢SteamÓÎÏ·°²×°Ä¿Â¼Ð޸Ť¾ß¡¢Ä¿Â¼ºÐµÈApp£¬ÕÒÈí¼þÒ»¶¨ÒªÕÒÕý¹æƽ̨£¬¶àÌØÿһ¿îÈí¼þ¶¼½øÐвéɱ£¬È·±£Èí¼þ°²È«£¬ÏëÒªÕÒpspÓÎÏ·´óȫĿ¼ӦÓ㬸ϽôÀ´¶àÌØÈí¼þÔ°¿´¿´°É¡£