揭秘Sql2014新特性-tempdb性能提升

时间:2023-03-08 17:56:35

一直以来,在高负载,复杂的生产环境中,tempdb的压力是成为整个实例瓶颈的重要因素之一.微软的工程师们也在各个版本中不断优化它的使用.到了Sql Server2014又有了新的特性使其性能得tempdb的性能有一定提升.这里我将通过实例给大家介绍tempdb在新版本中的实现变化.

我们都知道tempdb的日志无需提前落盘是其快的重要原因之一,日志无需落盘,那么数据又是如何操作的呢?这里先介绍一个重要的概念:主动写(Eager write)

主动写:Sql server引擎在面对最小化日志操作的情形时(blukinsert,select into,etc)会采用主动写的方式将数据页批量刷入(一般32页/次)磁盘,以减小惰性写(lazy write),检查点(checkpoint)操作时所带来的磁盘压力.

熟悉Sqlserver开发的DBA或是开发人员应该知道,在使用tempdb时存在着大量的最小化日志操作,如select * into #xx,而Sql Server由于其引擎主动写的特性使得即便是批量写入的优化方式也会使得由于tempdb的频繁写入使整个磁盘IO面临较大的压力.好在微软的工程师们注意到了这个情况,在Sql2014的tempdb中引擎放松了主动写在tempdb的必要性,在特定操作中数据页可以驻留在内存中而无需主动刷入磁盘(Sqlserver认为短暂的时间窗口),减轻了磁盘的负载,于此同时也使得tempdb的性能更高效.这里我通过一个简单的实例给大家演示.

注:为了演示不同版本的特性,我们需要开启跟踪标记(TF 3917)用以捕捉主动写行为.

我们先来看下sql2008R2 SP2下的情况 如图1-1

select @@VERSION--Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 

dbcc traceON(3604,3917,-1)----catch eager write

select * into aaa from dbo.bigProduct
dbcc traceOFF(3604,3917,-1)-----remember turn off the TF!

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAu0AAAHrCAIAAAD0bTSwAAAgAElEQVR4nO2dv4oluZavw5yHKLMeYPoR5phllT1wraat66WRD9D0I1yj6GproF9gYKykrIHjHKg2LpwxLlVjjDHGUDRFGklBQVwjckcqpKWlpaXYeyu2vg+RRK7Qn6UlKeKXitg7p7//34+5NM/TKQEAAAB0x4SOAQAAgIOCjgEAAICjgo4BAACAo4KOAQAAgKOCjgEAAICjgo4BAACAo4KOAQAAgKOCjgEAAICjgo4BAACAo4KOAQAAgKOCjgEAAICjgo4BAACAo4KOAQAAgKMypI7JdetGuwsAAHCrXFnHTNM8XVg3TDXHUQDCX6ckzZI9ajosntr1IsVfa5h+npYUHYcZPPWeDdFJdw1pZ6PKHc0p9XdFrmurPRcco11vVKnH0ZFcPespR7uXGTt7/JUaxCK19YSlLP7sMh/cfgKkFHTMLz//kku7edA8h+tqqNIx0XFL8VS4KI7p9Sju1RDpGH9F50d0r/YyHR5HvxaPW+rvCmNnQx1QZa9t2h1wpaxlfC19PxOWPxtq49lSz5rtkvPhwjGH26asY8Rion3ZXFmTaBdLKfWI9rBUrtF8j4MDh1BIT9n1h9GxXP4p+WmpVmkwo2OKf6/Pyd+7YinL323F/FHmqF3733O5PGI39SJV9c9qv+YkqmIfa+tx+HwtHVNbSS6zHv/adi9wW+1Hx1RpO3QMdMhuOibVHLq9WFCpJ9VJFYhqQLGHv6b2KTGK1Ub5RYevoWOin+lZ8dfcrdRS3HcdbL/trX6mzueqPUf9u8ctV4/F213atbduDLsRsQbRH0e7R9ExVfOt6Ak6Bg7KufZjRKO4ZZLbdInyK2LlmjomNc4lvSJWpTSaa277a3hRy/0RL17yHDpGz1ks7rj+7n6zUcSKW8fkKtHjb/TNUY/FvZxl9/vWrOqeXbqQO+to1+6PMi7FgvZf7bU59ETuulFVPzoGrohJx6RvxhTfj7HoDzFDLv/OOmZOdEbOHp0S7UoTRTdylkod46Dq79QddYxo71zH7HVfEfM0OuD2TTGeSce4yyq1Fc86xMoFbqud6JhcZnQMHIhLP1cSPHDpmNxzpbKmKYqP3FldeRSPc7LJaBG1keiVmRYdU7xP7HsdLDZh/LuzWNZyXFW/72aZ/mW/103X2MGz6phcPe6OzObxNWboTccU54N9HRkn0u7rd1/dBhCyp44pvp+rP3KqsudaN/S48ni1TJIlTJE9qm3KnE2rEk8pv7qYDK+XpvcG3ShevPbNnyti6a+Sv7bdqvrFevTKdSft9Yh+VsXfYdfbDS0O/6PiudqUdlPnxbN2T2qpWl/hKaUeiz1XT1TKXf9e/gPUsuf7MYdBVAyKHW4d990UrsiZRooJAHAsrv/9MQAADtAxADAXdQwbFAAAANAt6BgAAAA4KugYAAAAOCoVOoZ3YgAAOmQCuCDXnu8x6BgAgENy7dsZjM61V8Az6BgAgINx7fsXwAvXXg3oGACA49DnjQSGordJiI4BADgG/dw5APqRMugYAIAD0Mk9AyCkh2mJjgEA6J2r3yoAFK47P9ExAABdg4iB/rniLEXHAAB0DSIGDgE6BgAAYtiMgaNwrbmKjgEA6BdEDBwIdAwAALyAiIHDcflJi44BAOgUdAwcDnQMAAA8g46Bw4GOAQCAeUbEwGG58NRFxwAA9Ag6Bg4KOgYAANAxcFTQMQAAgI6Bo4KOAQAAdAwcFXQMAACgY+CooGMAAAAdA0flFnTMNM2L/+vBrTL9/MuSLL+uRJHUhzw9OwXk8pucz1RSrD+XeZeJm9ZwkwJ6+nmafr7ptZFhzF77QMfAQbkFHTPPL/LlAh1JhcJlCNuNtIuYZyWMZCRQ4iZKFvFXy+zJtavUL05N/dcqclP/KDqm9g7NHX2BOORAx8BBObCOWXZf1p2Y1Rid0vMrdrnR055HKiCWX3On0p2S0FjMnwqUsGAoa6JsShgtmkDXGUpBBaOOsVR+jv2Y+UpSZtkyWe6y4b12teeM0Y1ZqWc9W+VPrn693fWs4n9UyuJMriElRDnnjf0aB3QMHJSj6phUiKTHYTYlv2jXms44Jj7TSbVLao+eDRXzhxafjrE/39lXxzj2V5TKd5m1negY8R4f2dNs9nr0avV6wl8tdrv/VYoh13e9nvRUMW65PDcPOgYOyi3omPBXoz1Xj6kPeR2Ts6dbLMbMRh2T/rri24/JaZTQHpFrxdKuUk+jjvnl51+iZKlEyLb9O17cbGi0Z7uZ2UKw3I9zp+z7H8atIEXfVPmvuxT9tNRj1zHKVs0goGPgoKBj6vtQo2Ps+yu19uvqmKJRoUqa5DLvNWU73I9R7JfUMVX+GO1GV5X859MxVc7cJOgYOCi3oGNqnytZ7FrTmddWijrG9/xIbytX/0r6YSXxOHfKp2PSnQ+l3drKFbu446LTp44pPq9JT+n1KMcWf3KV1D5XsjSh599Xx1j8HAffzeDb3esvdx/O5NIOfHr/9dXbp0/7VPbt7vWXN++/71PZRSvfjw+PL/H88Pjq9Zc43X/bFvh29/rru89r/seHfN0P90nxsLksR9Ux80myRC/2Wt7zNdq1ptWXefX3edOPSefy61Xlfo1cFZ+k5IZcPKU/PBJPKS/l2CuftqRn0yYqP+OWrf+67/mmWmQ15h7xFOtJK6l9tFT0J7Lr9fge4hgrt58y5h8E182gdGdaeLhf73OnW5pwKtRD39+93d4d45vZJoMipA6jYz4/vTmnjvn0/uuzRDApgzyRjtnKjpdWpPwP93oHA8XzzPd3by0q+cA6BoxcOJKOTZGu2mXitTOmDjg61ptBqDz0tNy0Hu5fVMin918DKfP93dsv0R/3p5vW93dvwz/NtzmjG96mYExfOsYm+85RycP9c4g+vf/q7cK3u2hwDfsxL9rl89Ob/Dz59P7r1vj13Wdpv0ceSnTM7XN5HXPJ5nZvl4nnY/DNjBug/mbw+elNsr8i5Yk3Wk730eiZVKgSIh2z3NJybQWZ8zfLVGDVc1wdsyo/4w6H2rpdF77MkHXc002XeY43cpY8ySPLbNPoGAAAqL8ZRG8zCM8UnjdgNjfdYHtmK1Y2iqdaxwR/9G+aS/djNk83Xv7iT0oJoifWMZlsUc3LqehJWdqXoPLnUARFnkORrWS7n/HSl2SfIyy71BZ0/HlnK2c/HS/xjDoY7p2cBu7h/tnJYBSsOubNW/u7MugYAACovRkkuwJZHbO992wsy/bJ26eH91+3UiDSMd/uhBdIT4QCqErHbLTRt3en1sMHYdvXVjY6Jp/t5f598uHpIRO0gFjHvNq8HhvsTCSVPNyn2mWrFdYXWT4/vdlEIxVPun0RE493b7++e/+4ZHh+ULU2sWnr65vnnZXVvc3DqVV1SfsxSYTQMQAAkKfqZiA8YRF1zOZmv2YLbrrB2zbhvTnaeFAeo2wlTo2OSfeKSjVEd/dMtvhRWkCNjsmquqgSYacq3s0KuyztG532ZoQNMElQJi+vSPsxywOsVJHk92PS92OiICevFZ84pI55+n//5x9e/+80XaYPAAC3R8XNYBEfdx8yn7wNHi7IOiZ8rrR5BVh8rqRsxkTv/1a+H3PKnHtUlAipF6mhZJPl0UKNjok/vZXRMWJzp7Cnmx/CU7DnviRbHYn9293rxwdpU0SSsN/u7r9JqsX+fsza2edjUSjP84yOAQCA2X4zWB5bvEleF61+P0Z8PiK+OiN/IikRMXP9+zGBItE2aZ6JdIycrScds9a86rD8XkhZx5xaVxXSkoLnU206JugvOgYAABSMN4Plpih87EW+zcSfaXp5J7fiFeDkFZDCGzORV4bP17zUr71QHEgNJVvh1M46pvxcad1BiV+OmU9tPT8/2jxyytnT/ZjTnpz0SS5Rx6RvHJvej0HHAACAQtXNwKxjhO+POd2Dl8c6288rZT93nbxvaxExs6pjPr1/XG+WsYTabngIb79q2eJTD/enY6NIKuuYWBomrxxtHHvRXsKX7Tre832J5zLo689EyuyxH5N2JAYdAwAAZ9Mx25d2t7sR29dZsnfutf7XX+4+yO+m5L7WRd2PCfYGNnk2bxnnP3edyzbP2e8pXu2Wz11no5FWsvlyQuv3u3y722Y+RThnn+c51DHbp2z332Zhj63tPd8Nyc7QC+gYAABw6Jj3hZdqe/hvQbt+n+/YBK9FR3ol2U0Jd86a9mNs+gwdAwAA/L9rOCroGAAAQMfAUUHHAAAAOgaOCjoGAADQMXBU0DEAAICOgaOCjgEAAHQMHBV0DAAAoGPgqKBjAAAAHQNHBR0DAADoGDgq6BgAAEDHwFFBxwAAADoGjsohdYwoYkgk0lXSZa4dcG7QMXBQ0DEkEqkpXebaAecGHQMHBR1DIpGa0mWuHXBuam4Gn5/enP7d8cP9y/+1Do9DNv+1OE7b/3784TH7b40/PJ6KvPyn5Xmel3++3fa/tb+/e/vl7kPurPwvmksIpT69/6r8e/CX9PKfn5Xavr97m3j1+enNa6UjWbb/brqd7+/eGrq5Hf2H+6TjymTYgI4hbW5I0QGJVEyXuXbAuTmvjsnojORm/HLr+nZXvruvfLtT79+RgEic0XWMfkPN+ZnRMUW58OHxlGcTnE/vv259EHSMqhdfdEPiRqn7YR/jOGwki1JJfg6sTaRCzajJxtIxjcUbr/Vnzb+vk5dvvX1wG5v+h/2mh6UeY0N7zfxa9xwVwtG5+n7MVhCEN9qgOdWl7K5JeOeWnCzeMqXNjwKKjlE3eDI6Jtl2il1KhI7C93dvA0Xy+emNti30/d3bNfjbglFHPjxmpUxxdNIp8bL9lpNQK2PpGPv9Y8cadnT+TD2K6okqzNVfa79AF3bv+9UHJaqqB/fSsjteIOCKGG8GsdrI6Jjw5ufaj0lvY4W9me/v3mb3bBId8xRvooRbNXrTxf0hWRYE3czphvhunQTn89Ob3NkPj69ef333XvN8qzBeVNHDvSA+ckP26f3X5Lneps6XsOjdDAK43R9atFGywaZtiR1Yx4jGyF57FRbt0X1Or7/9zqE48w/JH9OKP1V+tgTZ6I+jXTEaemZ7tMNKooK7xLNYj+6P2BdffPT+isd6fjH+cHT23I95uP/y6v7pU/jqQ3k/Zp7nzO3Kuh+T1HaidT/mw2P+5p0j2KvY7kaYN070TaBwL+T5OKh5oyO1Dr5ooyBPfvukqGNeYquOWjgiqY55k0rSW9Qxc2bPIGfPWSz1rI3a75G5u1ptkfQ+pNzb7N3UWzSWrbVXdTYNe3G81iBbop0b39xY18azOGeUCpWySrZifKrqr5r/uXUKx8KvY06K5PHu/sub99+a3rr98Pjq7dO7VWos2wwfyjpmuYU/ZF5AEd6P2dwX/TpGlGhv3n9PdMxmd8r2Uq2qYwSVEMqI7w/3Xy0dDDZjXrZAsh7q7xFHZyMPt0JE1zFCr29Rx0RXT+WSWrzQ5yq33AKNad5JxxSPLbfJYovGsrX2qs7W9ks5sLRY7HttPIv59Qy5Kd0eH7H+Yv5iX+AGqNYxd/df3rz/Hu3HbJ9fJO/A5tOb99/Xl0bfvP++PpW4+/D904enN68f371okVRSrPdg+S4o7ceEt/bm/Zj0LhvexVMdo4Vi9V/VMZsWa+P8XMNGbi4Bz8sXYfNsw7e71+pbTbqOSSOQFs+KvwPrGMv12nGDcVzHz5HSVubSvcfRTeVW5A6RIz6WLuj9Ug4sLeZKFe219RszuOPv8F88rpr/VZcA6Bb7zeD5rrn+7V56z3erErIbId/uljc8lrM5HSA9rQif1IhPbeTnSi9VRTrG8rHhzR192dXYNB120/Jc7CWnSccIod608u3udfRcSfg0UFjDp/dfX90/3hX8XCKT5one/039iYWIaT9m2Y37nOaJOKqOmW3Xa8cNxnfd3z2lNVt8yMXB4qelbMtxVWeNxtRn40yInAxLOeIZlVLqKXbEUrYlPnoffXNAW/FwHOzv+T4+1H1eqSAL5Nc5g7dE796r+zHxww5hcyX3fszpqUrjfsy3uxefn++7m0cz9tdrNvf+jfjYxFZ8vpNueOQ+WJRkDt+wKT0TTD/iLomYuC/x3LA+VzqF7lZ1TGSJLtPpqRZ7ercQ7bsk0R+x77o/iv/K/U/MXBuHqnb1/lr6lQYn15Gck1GdtfGMjPZ60lKR83qLVX6KURIdNvZXzAnHZefPXW8/u2TZj9mete7HSF+Cl7ymetb3fIN7/+rM9mb/3KnS05/7b9uGnnXM83OozZ3+y5u3X1/l+7j2dLPX9ZI5ljWB6ip+6V+kY5LHSSvxqG0+jVX7fsxN6hjSvmlWdQzpwulYo3CRSwecnTYd8/npTfh+7qoMih++3X4Et1LHZD9rHX2sZofvwcvqmNMTnPXT2svrxuH+hPV7aTNvvYRlg7dYPr3fSBnblwU/PiRK7uE+bSL3PCh6rpQXMSGfn96cYv6sybbRMOqY/EYROoY0aJqnqbfjYKF04Y/x+NxXDbgMjZ9Xim6Q+T/r9Zu69FxJvBkXb6Lhbf58+zEv6mGpX/r4t/0b6sKnUeknnJPXqPVPQYdEH9LebpOkMdx+o91GIUXvuCjvEc9yNF4Khnsz+XeP5nku/esJdAxpxPR8A+bnHj8vc+2Ac2O9GWz/pE4eoKx3o7dPn4ybMc/3v2/Pr9G8CALpDv1s/3YnbKskKN8we3I+eeem4rM/Us3BSy3hKz5ZH6KXhzLiL/9hIvFb7BZy+uOZ4C3aXIuOf9U0z7O8kyS7l7778iK5Nh/s0qpCx5CGS/3sZNzIMdwEF74ZAOwFOoZEIjWly1w74NygY+CgHFLHAADAvqBj4KCgYwAAAB0DRwUdAwAA6Bg4KugYAABAx8BRuQUdM03Pn/1cD26V6edflpRaolM5e0gUYX0qpGengFx+U6cylRTrz2XeZUKnNSCsp5+n6eebXmB5lr6n3c/Zq6pt9u7FjTCJ9rTgyzE6Bo7JLeiYeX6RLxfoiKgJLkAkX9zHK2GEI4ESN12yiL9aZlWuXaV+ccrqv1aRWxLomHl72ztuE7XkXKpydZdKipUrB2Jb6Bi4AQ6sY5bdl3UnZjVGp/T8il1uNLPJsf6qb5mIVc2J5hArST0JD3IZcqpLCa9FE+g6QymoYNQxlsrPsR8z9yRl0j+4o1OhMcy8Wnz5c42K9eh+Kv1S6skdK10wCgWl3VyIlH0OY7/mbUiL/lh6IVosKgodAwflqDomFSLpcZhNyS/ataYzjomPb1Ltktqj50HF/OmpXNO5J0pzJrz25zv76hjH/opS+S6zuXMdM2fu0OI9MswcaRRHfvHv+1w9OT/1fhXtlvoj2VHVqP5r0V6VWfTT6IClFV0MoWPgBuhax0Rp6/cs/mq05+ox9SGvY3J28f0VS2ajjlEy7Lsfk9MooT0i14qlXaWeRh2jz65cJUK2yr/X97LPmXubUo944MgfNefzU8GhY6ryWxq9sI5Jj5V41rbCfgzcPP3qmEJFB9Ex9v2VWru7qoUz6ZiiUaFKmuQy7zWVD7EfYzSGdl2X1Oa3bHigY+yV2DeQ7K1UaCB0DByTW9Axtc+VLHat6Zp3adufH/na1auapQ8rice5Uz4dI+2rZdutrVyxizsuOuiYXP7a+26LjlH2Kor196xjLH2016y7hI6Bm+eoOmY+SZboxV7Le75Gu9Z06fPPucy5j0aL+fWqchbdviI+SclNBfGU/vBIPKW8lGOvfNqSnk2bqPzsW7b+fnSM8tAhPZUez4kssOQXj3WX3A9HxPyKV6m40b3VQ5rrVK5fxq5V+bl7/bkiL8fum8HDfeE/Gyc8/0/j7T86fiY2fnh8Jf7j6w+Py/+7XvN/ev91sTzcS/8K++UfaOf/o/VzL6L/QZ3+T+x5/vCYeP793VvDv+DOerX+qvzL6/y/px6aA+sYaOTCd2XHpkhX7fYjYgDOQcvN4Nvd66pb+LOOeVYMW0Gw0TEfHl+9/nL3IVfJ48OafyNTJN2zySAJgg+PoY6JGz0VfxZJgo5Zas55OwvyaKlh7WOkaV7azagura2hQMeMy+V1zCWb271ddAzcNsabQW6vIk3K5kGoJL6/e7vRH6uOebjP1ByonLsPz/kf7k8VfnhMbvZbn+8fz6ZjTLsmp+2i/LZQKAo/P71ZvIprlpwcFHQMAAB4bgaZjY0VdS8h3VpYFMmn919f3T+9e/vl1dunT1u58On919MmhCyn3rz//nC/3t23d/qdnisVdIy0w5RkCDddgt0jsc5Vx8QBR8esoGMAAKDw5plIScdk+f7urVjw293rx3fb92MW7SK8oXJy4O7+68vbOR8eg82MbSuXeK60Srd8WE6v9ay9W38NFFja8YIEHBt0DAAAOL78KbvdUhQ32l5C+H5M8GgpVTDPxuh+f3d/UhjCK7SPDx8e7z5sdIz0rvHGveitYV3HfHr/9dXbpwfp/eW4R2+fPj1vxnx/9/bL3ftl3yWJzEldfXr/9RXPlWTQMQAA4NAx8ieJEpWQefqTey/45elSLF+EO/fDffIQZ5UvL/sr88ujovtvhhdTlobSbF/ffTa+55vZ8vn89Ob1qfjbp4f3X+8+zJvjwseXvt29/vruwyof+fjSAjoGAGB0HA+Vnvce4o9bZ150jYSL+InreZ6fRcb9t+xLvs9q40nSIosCWFRI+Cno9fYvPFfK78c8Zwteyy3omDAgYnCWTp10zOPd6S2czZvIa7V80NoKOgYAYGg8Iib7dSnih4fT73TZbJZs6gzu5dEnqKP9mM2v6ae1472i1bHPT2+Wt3Cyn4RaXqyp1DGfn968zrr33J23T+/uX/Zjnj+FtNk02gqX4ovS2gvF44COAQAYlPRZkvlmkP96OtGePEjabIosZ5fv03uIFcla21YZhGJFeP6Sfd6Ue4UlUEKLfqrSMZKqkzZUHrY6ZvNu70bTbHwOJc4ayfye1migYwAARkQUMbabwfqeR4q80SJ8x27wLcCnF1233x+zVhh8/ih9s/X5LZbAvoiYx/ir+Z41wbPgSEXAi+W5C7KOeenmS/HsZ60/vf8aqbqNjnkWLi9fnHP3YRsodIwJdAwAwFiI2sV8M1gediifx5FObd93Cb7HZfmSmOBmn789xzrmuc77by9KIvQtEluLJgh3ZTKPaYQNmPvHN9sHVdvNG+35TvQ5o/DzSu/uQ2nydLeoujAa6BgT6BgAgIFQdl8s94P0XxBE3xoXfcmb/h0npwzRF8akOyVx5ScNFOYT/onB8gGil9duFBFwssT/1mC7kxT1yPYPGQLHXmpT333JvMisfMZqWByvdrW2iI4BALgKxUdIF74fALRz+UmLjgEAuAKWl2DQMXA40DEAALePRcTM19iiB2jhKtMVHQMAcDmMCibNfwHfABpBxwAA3DK1IiYqdVbfABq51kRFxwAAnB2fgknLnsk9gEauOEvRMQAA56VFxKQ17O4eQCPXnZ/oGACAczEl7FLVjh4CNHL1mYmOAQA4C3spmPNVCNBCJxMSHQMAsD9nusSnGzwIGrgwvU1CXccAAEAdF7i+izcSgKtwjhletxzQMQAAe3GxS/xV7lgAIeeb3lWgYwAAduBal/ir3MBgZC42t42gYwAAWun8Qg9ww6BjAAD89P/XKsBtg44BAHCCggG4OugYAIBq2IYB6AR0DABAHSgYgH5AxwAAVICIAegKdAwAgAkUDECHoGMAAMogYgD6BB0DAKCBggHoGVnH/OWf/qLoGxKJRBokRSLm6v6QSKQoCX9b/PLzL4uOubyqAgDoBD5ZDXAIhD8vQh1zdZ1FIpFIl09sw5BIR0noGBKJRNokRAyJdKAkrFJ0DIlEGjOhYEikwyV0DIlEIn38OyKGRDpmQseQSKTREwqGRDpuQseQSKShEyKGRDp0QseQSKRBU/rJ6qu7RCKRahM6hkQijZhQMCTSbSR0DIlEGiuxDUMi3VLi+2NIJNJACQVDIt1YQseQSKRREiKGRLq9hI4hkUi3n1AwJNKtpumXn39J06JjxFMkEol0rBSJmKv7QyKRdkzTX/7pLyQSiXSTKVIwV/eHRCLtnvjThEQi3WZiG4ZEGiHxnJhEIt1a4pPVJNI4ieVNIpFuKqFgSKShEoucRCLdTkLEkEijJdY5iUS6hYSCIZHGTNPcK1cPDYlEOkpCxJBIw6Z+F/xf/ukvV/eBRCJ1nlAwJNLgafrrv//1r//+13/7138L0+//8vvVPfvl51/YlSGRSEpCxJBIpOm3Xz9GD3T+/J8/f/z1t6t79svpa4VJJBIpSnyymkQiLelFxzw9Pn38c/745/z7355+/AkdQyKROk0oGBKJtKZnHfP3//j7xz8+fvzbx9//9vTbrx8bdYxyZbFfdNAxJBIpSmzDkEikKE2//frxtz8+/tu//ttvv378/V9+X1KVjlkvJfpBjly16BgSiRQmFAyJREqT8H7M7397et6Y+ePjb398/Pyfn8u1bIVL+DPKkCuYJnQMiURaEyKGRCKJafrt14///V///ef//Pnn//z58Y/59789/f63p1XT/Pbrxx/+8UeLlNlUmlxl2I8hkUi+hIIhkUhKmn779ePn//y8fPp6+QD2b398nOd5/vW3+dcff/v148e/aVIm2nTJyRT2Y0gkkiMhYkgkkp6E50rPOmae53n+/J+ff/jpxx/+8ccf/vHHbBV5sTLxfgyJRHIlFAyJRLKkZx2zfOj6z//58+OfJx3z64/zTz/O8/zjrz/89uvHH37K6piXutiPIZFIeyREDIlEMqYXHbOImI9/zuEOzdPj0+f//PzbHx+V/ZiXutiPIZFIbcl+iSCRSKS/rzpmFTEf/zjpmJ9+nH/64b//679//PWHoo6ZTh9QslyDjBcmdAyJNFpCwZBIpNq01TF/zD/+8cPv//L7+g8K/v4ff//rv/91+dRStgrb+zFiTvZjSCTSkhAxJBLJkablE0nLt+Et6SB414gAACAASURBVFnH/PTD/NMPH//28YefflB0zLT9vFLubKRjFOOa0DEk0iAJBUMikdxpWt7h/ef/9c8//PTjkhYd8/w9eL9+XL7n1/F+zHpJirROdMFCx5BIIydEDIlEaknCVWNRLWm6sGfoGBLpthMKhkQitad+rx3oGBLphhMihkQi7ZL6vXygY0ikm0zJhxr7vQqRSKT+U79XEHQMiXR7CQVDIpH2Tf1eRxYdMwPATZBuw1zbIwC4BfrVMSQS6WYS2zAkEulMiT+JAOC8sA0DAOeDawoAnAsUDACcG64sAHAWEDEAcAG4uADAzqBgAOBiZC8x57gM5a5u7lbEgmH9+3ZBrK0rozJqSk4xPhZjo/PdErnq9txX0F6qz3gWp9b52r1YWxaqxjENl76OajurF8ldLqqacGNs/UAXkPlo3h4dLdDhPW+39jJ1upvI3W6nQMf4alYaEnvRm1E8a8kw264jjX52S25G7VjbLqU6vFBOCWKexiZaijfiUA++bMWF5uBMzl+y9d4mvM6xvD001TpGvEKJuiGXczas26iStPXINzGbxZ7LqURDiUy3RrEj+rWyOHA7uhQ1lJtgvllnH+KwuNj9qMK0TuP8tPSo6Gcxm9LxlniK3YyMafGwZr1OxZ9ccUtZyykxgGJf9IJhDWKdlmzFY4vb0XHqgNKdnPNVPtQOnN7TYtNpf3NtFWeIaIzyF3Pq3sJe1OkYcUWlMyOXc85P3HQqKA1FOXN+RpNJ9DP9NUfRpZ6N66/iWLRXrg+x4lKEwxP7rFPazfmQM+4yP3PGord6izu2buzmlKC4VzTqA6d0WZntLUEWixsx5rcvmTRnsd3iyOb8tMz5YuuWIr55otcW/pxrArLX6rAME+xFYTqK1xHlahWNYm59pgNsXDPGBW83is6INDZ0XaPYEfvA5Yx7uRSezU2b9llnRA+a3iP7/DT2KOeh2E3d7X3juVp0Z+xjYRw4pb+WMaqaFXqULLjzF/20jHv4U6/T0oR91s01425svVhJlCfq+1waTUdOMSBVEwz2wnoRTC3FMTbWKdqjuaLk97nkmG2NDV3eWOyvHoTidaQ98nr9jQ0Vq3X7ELXYOD/FJhxzspihcYLl6k8v5bonjWtTOav82jgV3Xep2jz7rqPwp168as5XsVfrdh/sfT/H6nCsYmgnG2jx2jQlpHYxs73OyJ4e5CoUfSv6KTbti0kPRqU7Ss5i5pyx0XmR1KspQemsMZu79ShneiCWTSNQdL7orSWbpRW7S7niOR9yGYwuuYvP9ZHXnReLK2VFl0J7LrPPmHNg/TnnA6L3UXS+KnS68/bWcy4pTSvdzJ0VcyqdKhqj4krQoIWdI3uUoTqKn2CB0czhi0yxlPGm0jnH9RyuCNOmQ/YZkqNc0Y7iJ1hgNHVq42PJfwMK5tDOw7Vg2vQMowIAJm5AxADA7cHFCAAKTAnX9ggA4BmuRwCggYIBgJ7Z56r05dVrEol0eykSMVf3h0QaPO1yy74xmnQMkQW4VdiGAegQbrspzssTcQS4YRAxAJ3DXXjFc4UidgC3CgoG4EBwO55rdQwCEOCGQcQAHA5uyhWXKoIFcKvwyWqA4zL43RkdAzA6KBiAozPyDdp6zRo5RgCX5zIf2mQbBuBmGPY2bbpsDRsdgGtxAR2DggG4Mca8WaNjAHrk3DoGEQNwe4x5sy5fv8aMC8B12ffbrsLaUDAAN8yAt2x0DECPnEnHIGIAbpsBb9noGIAe2V3HoGAARmDAW3bhcjZgRAB6YF8dg4gBGIfRbtzoGIAe2VHHIGIAhmK0Gzc6BqBH9tIxoYJhOQOMwGgrHR0D0CO765gdn1IBQM+MttLRMQA9cr7PXQPAbTPaSs/qmPVvuB0fqOee07sf24sFw/r3fSdArK0ro/IahJJTjI/F2Oh8t0Suuj33FVxK6cqjNsjD6pjeppx9SiirWDT6lmHxOlDrYXi2Kv++VIXuMi61Y/d2tJWuBWU6PVDfcaSn4D4q2t0VRsYp0DG+mpWGxF70ZhTPWjLMtjXf6Ge35GbUjrVZSinKwxHkznVM46y47qRy3P5bcipXzr2uIXbO1/eLtd7/FSkEHSNSrWNE5S7qhlzOWRqMtIn0OKwzWodiNos9l1OMRnp8FKPYEV2UFAfuTNdKZYL5Zp19iMPiYvejCtM6jfPT0iOj8kh7JPYx+h48n0tKkMW+Kz6HOactukupP7nilrKWUznn074UO74WEeu05EyNUQdrjcXmQg+jgK9FipFXmrCHLoqzfdz1DhabTvuba0uZRaJXYv5iTt3bBXRMcC7RMfryiAYjzTnnJ1k6bEpDUU7Rk+hnzs/01xxFl3o2rr+KY9FeuT7EiksRDk/ss05pN+dDzrjL/MwZlyJFHWNZRyvp/yVwuGTJWcQSXqWhWeq40rqyBIpXBqNL9r7X5ndPxbl+GRa9yvU9F4cW54sFi0V800yvLfw51wRkr8Vlv46hY4Jz0vsxU8BqCc+m2dIMxVXUuDjtRtEZkcaGrmsUO2IfuJxxL5fCs7lp0z7rjOhB03tkn5/FHjn2Y5RuRjpGd94d5Mii+GwcIONoKo1aBq5qquhRsmDP756Kjm5aOh791Os0Oi8Occ4B47Qxtl6sJMoT9X0uTYa9FlfV/FxAxwTnki+c8K2ZXA2KPRpXJX/7MjbOjMaGLm8s9tdxXfPVaY+2vdFdZp3Ph6jFxvkpNjG1vR+TUtQx7UEW3TPmbFywylnl18b56b7NOOKjGHdZhna3w5+OOh3tKpU0tm73wd73cywux90KHXM6MU2TpGMiUruYObIodUb29CBXoehb0U+xaT0mOf97MCrdUXIWM+eMjc6LpF5NCUpnjdncrUc50wOxbBqBovO1n1fK+bmQ+3/XueJ2P2uDnMtpdMldfK4fDt15sbi976mrxZx68WJAFD+LnofZxF6Lx1XO6z7ksukV6q3nXFKaVrqZOyvmVDpVNEbFRZ/RMRtqw6HMhq44ip9g4SZH83zfH+ML100GOWWQbkJX7D7r0DEbjOEoStpOOIqfYOG2R/NMOqY2aLcd5JVBugldcb5Zh47ZMFo4ADqB7/MFAB+jrXR0DECPoGMAwMdoKx0dA9Aj6BgA8DHaSkfHAPQIOgYAfIy20tExAD2CjgEAH6OtdHQMQI+gYwDAx2grHR0D0CPoGADwMdpKR8cA9Ag6BgB8jLbS0TEAPYKOAQAfo610dAxAj6BjAMDHaCsdHQPQI+gYAPAx2kpHxwD0CDoGAHyMttLRMQA9go4BAB+jrXR0DECPoGMAwMdoKx0dA9Aj6BgA8DHaSkfHAPQIOgYAfIy20tExAD2CjgEAH6OtdHQMQI+gYwDAx2grHR0D0CPoGADwMdpKR8cA9Ag6BgB8jLbS0TEAPYKOAQAfo630rI6Zpmmapi+vXk9TQetUNLYlsrsrzLUSHbcj1taVUQxvMacYH4ux0fluiVx1e+4ruJTSlUdtkIfVMb1NOfuUUFaxaLz82tRLGZ0/E1Whu4xL7di9HW2la0FZLqbzrteCKbiPinZ3hZFxCnSMr2alIbEXvRnFs5YMs23NN/rZLbkZtWNtllKK8nAEuXMd0zgrrjupalu357dMxXNcQ+ycr+8Xa73/K1IIOkakWscoij48UHLO0mCkTaTHYZ3ROhSzWey5nGI00uOjGMWO6KKkOHBnulYqE8w36+xDHBYXux9VmNZpnJ+WHhmVR9ojsY9rbUo0WoIs9l3xOcw5bdFdSv3JFbeUtZzKOZ/2pdjxtYhYpyVnaow6qBjFUsWcoYdRwNcixcgrTdhDF8XZPu56B4tNp/3NtaXMItErMX8xp+7tAjomOJfoGH3NRIOR5pzzkywdNqWhKKfoSfQz52f6a46iSz0b11/FsWivXB9ixaUIhyf2Wae0m/MhZ9xlfuaMS5GijrGso5WwNrdLlpxFLOFVGpqljiutK0ugeGUwumTve21+91Sc1SutGBN333NxaHG+WLBYxDfN9NrCn3NNQPZaXPbrGDomOCe9H5NOemU40+URTYW0oFJnWK2e024UnRFpbOi6RrEj9oHLGfdyKTybmzbts86IHjS9R/b5WeyRYz9G6WakY3Tn3UGOLIrPxgEyjqbSqGXgqqaKHiUL9vzuqVjskd0YnQ1/6g0ZnReHOOeAcdoYWy9WEuWJ+j6XJsNei6tqfi6gY4Jzp/2Y0JIeF425GhR7NK5Kfp9LjpnR2NDljcX+6kEorvn2yOv1NzZUrNbtQ9Ri4/wUm5ja3o9JKeqY9iCL7hlzNi5Y5azya+P8dN9mHPFRjHstQ+Owhj/1Omudt7NX63Yf7H0/x+Jy3K3QMacT0zRJOiYitYuZI4tSZ2RPD3IVir4V/RSb1mOS878Ho9IdJWcxc87Y6LxI6tWUoHTWmM3depQzPRDLphEoOl/7eaWcnwvpcyW9uN3P2iDnchpdchef64dDd14sbu976moxp168GBA9Srrna+b155yPp8953YdcNr1CvfWcS0rTSjdzZ8WcSqeKxqi46DM6ZkNtOJTZ0BVH8RMs3ORonu/7Y3zhuskgpwzSTeiK3WcdOmaDMRxFSdsJR/ETLNz2aJ5Jx9QG7baDvDJIN6Erzjfr0DEbRgsHQCfwfb4A4GO0lY6OAegRdAwA+BhtpaNjAHoEHQMAPkZb6egYgB5BxwCAj9FWOjoGoEfQMQDgY7SVjo4B6BF0DAD4GG2lo2MAegQdAwA+Rlvp6BiAHkHHAICP0VY6OgagR9AxAOBjtJWOjgHoEXQMAPgYbaWjYwB6BB0DAD5GW+noGIAeQccAgI/RVjo6BqBH0DEA4GO0lY6OAegRdAwA+BhtpaNjAHoEHQMAPkZb6egYgB5BxwCAj9FWOjoGoEfQMQDgY7SVjo4B6BF0DAD4GG2lo2MAegQdAwA+Rlvp6BiAHkHHAICP0VY6OgagR9AxAOBjtJWe1THTNE3T9OXV62kqaJ2KxrZEdneFuVai43bE2royiuEt5hTjYzE2Ot8tkatuz30Fl1K68qgN8rA6prcpZ58SyioWjcXJkFvyZ5reRufPRFXoLuNSO3ZvR1vpWlCWi+m867VgCu6jot1dYWScAh3jq1lpSOxFb0bxrCXDbFvzjX52S25G7VibpZSiPBxB7lzHNM6K606q2tbt+S1TcZdleLHpve9I7dJ6/1ekEHSMSLWOSeX8agwPlJyzNBhpE+lxWGe0OMVsFnsupxiN9PgoRrEjuigpDtyOLkUN5SaYb9bZhzgsLnY/qjCt0zg/LT0yKo+0R2If19qUaLQEWey74nOYc9qiu5T6kytuKWs5lXM+7Uux42sRsU5LztQYdVAxGivJ+ZwGfC1YjLzSkD10UZzt4653s7bvivPKLBK9EvMXc+reLqBjgnOJjtHXTDQYac45P8nSYVMainKKnkQ/c36mv+YoutSzcf1VHIv2yvUhVlyKcHhin3VKuzkfcsZd5mfOuBQp6hjLOloJa3O7ZMlZxBJepaFZ6rjSurIEilcGo0v2vtfmd0/FuV5MVDlTnBiNzlt81ov4ppleW/hzrgnIXovLfh1DxwTnpPdjpoDVEp5Ns6UZigvJvjiLVxbdKDoj0tjQdY1iR+wDlzPu5VJ4Njdt2medET1oeo/s87PYI8d+jNLNSMfozruDHFkUn40DZBxNpVHLwFVNFT1KFuz53VOxNlzGUYt+6g0ZnReHOOeAcdoYWy9WEuWJ+j6XJsNei6tqfi6gY4Jzp/2Y0JIeF425GhR7NK5Kfp9LjpnR2NDljcX+1l7s3HXao21vdJdZ5/MharFxfopNTG3vx6QUdUx7kEX3jDkbF6xyVvm1cX66bzOO+CjGWpcsdSrOhD/bG6pamGmpXbq5b9/Psbgcdyt0zOnENE2SjolI7WLmyKLUGdnTg1yFom9FP8Wm9Zjk/O/BqHRHyVnMnDM2Oi+SejUlKJ01ZnO3HuVMD8SyaQSKztd+Xinn50L6XEkvbvezNsi5nEaX3MXn+uHQnReL2/ueulrMqRcvBmS1W1zK+R/WUIxtlfN667lseoV668a+TxI5e3pWzKl0qmiMios+o2M21IZDmQ1dcRQ/wcJNjub5vj/GF66bDHLKIN2Erth91qFjNhjDUZS0nXAUP8HCbY/mmXRMbdBuO8grg3QTuuJ8sw4ds2G0cAB0At/nCwA+Rlvp6BiAHkHHAICP0VY6OgagR9AxAOBjtJWOjgHoEXQMAPgYbaWjYwB6BB0DAD5GW+noGIAeQccAgI/RVjo6BqBH0DEA4GO0lY6OAegRdAwA+BhtpaNjAHoEHQMAPkZb6egYgB5BxwCAj9FWOjoGoEfQMQDgY7SVjo4B6BF0DAD4GG2lo2MAegQdAwA+Rlvp6BiAHkHHAICP0VY6OgagR9AxAOBjtJWOjgHoEXQMAPgYbaWjYwB6BB0DAD5GW+noGIAeQccAgI/RVjo6BqBH0DEA4GO0lY6OAegRdAwA+BhtpaNjAHoEHQMAPkZb6VkdM03TNE1fXr2epoLWqWhsS2R3V5hrJTpuR6ytK6MY3mJOMT4WY6Pz3RK56vbcV3AppSuP2iAPq2N6m3L2KaGsYtF4+bWplzI6fyaqQncZl9qxezvaSteCslxM512vBVNwHxXt7goj4xToGF/NSkNiL3ozimctGWbbmm/0s1tyM2rH2iylFOXhCHLnOqZxVlx3UtW2bs9vmYrnuIbYOV/fL9Z6/1ekEHSMSLWOURR9eKDknKXBSJtIj8M6o3UoZrPYcznFaKTHRzGKHdFFSXHgznStVCaYb9bZhzgsLnY/qjCt0zg/LT0yKo+0R2If19qUaLQEWey74nOYc9qiu5T6kytuKWs5lXM+7Uux42sRsU5LztQYdbDWWGwu9DAK+FqkGHmlCXvoojjbx13vYLHptL+5tpRZJHol5i/m1L1dQMcE5xIdoy+PaDDSnHN+kqXDpjQU5RQ9iX7m/Ex/zVF0qWfj+qs4Fu2V60OsuBTh8MQ+65R2cz7kjLvMz5xxKVLUMZZ1tBLW5nbJkrOIJbxKQ7PUcaV1ZQkUrwxGl+x9r83vnoqztLrtV4aiM8WJ0eh8sWCxiG+a6bWFP+eagOy1uOzXMXRMcE56P8a4PKYtUYZ0MGoXp57TbhSdEWls6LpGsSP2gcsZ93IpPJubNu2zzogeNL1H9vlZ7JFjP0bpZqRjdOfdQY4sis/GATKOptKoZeCqpooeJQv2/C1TMTXacyrOhD/1Oo3Oi0Occ8A4bYytFyuJ8kR9n0uTYa/FVTU/F9AxwbnTfkxoSY+LxlwNij0aVyW/zyXHzGhs6PLGYn/1IBTXfHvk9fobGypW6/YharFxfopNTG3vx6QUdUx7kEX3jDkbF6xyVvm1cX66bzOO+ChGX2TcfQ9/6sVrnbezV+t2H+x9P8fictyt0DGnE9M0STomIrWLmSOLUmdkTw9yFYq+Ff0Um9ZjkvO/B6PSHSVnMXPO2Oi8SOrVlKB01pjN3XqUMz0Qy6YRKDpf+3mlnJ8L6XMlvbjdz9og53IaXXIXn+uHQ3deLG7ve+pqMadeXLcodqPzs3Qj12Nb5bzuQC6bXqHees4lpWmlm7mzYk6lU0VjVFz0GR2zoTYcymzoiqP4CRZucjTP9/0xvnDdZJBTBukmdMXusw4ds8EYjqKk7YSj+AkWbns0z6RjaoN220FeGaSb0BXnm3XomA2jhQOgE/g+XwDwMdpKR8cA9Ag6BgB8jLbS0TEAPYKOAQAfo610dAxAj6BjAMDHaCsdHQPQI+gYAPAx2kpHxwD0CDoGAHyMttLRMQA9go4BAB+jrXR0DECPoGMAwMdoKx0dA9Aj6BgA8DHaSkfHAPQIOgYAfIy20tExAD2CjgEAH6OtdHQMQI+gYwDAx2grHR0D0CPoGADwMdpKR8cA9Ag6BgB8jLbS0TEAPYKOAQAfo610dAxAj6BjAMDHaCsdHQPQI+gYAPAx2kpHxwD0CDoGAHyMttLRMQA9go4BAB+jrXR0DECPoGMAwMdoKx0dA9Aj6BgA8DHaSs/qmGmapmn68ur1NBW0TkVjWyK7u8JcK9FxO2JtXRnF8BZzivGxGBud75bIVbfnvoJLKV151AZ5WB3T25SzTwllFYvG9rVZGyu9iNH5M1EVusu41I7d29FWuhaU5WI673otmIL7qGh3VxgZp0DH+GpWGhJ70ZtRPGvJMNvWfKOf3ZKbUTvWZimlKA9HkDvXMY2z4rqTynH7b8mpXDl9y7Aleufr+8Va7/+KFIKOEanWMYqiDw+UnLM0GGkT6XFYZ7Q4xWwWey6nGI30+ChGsSP6da04cDu6FDWUm2C+WWcf4rC42P2owrRO4/y09MioPNIeiX1ca1Oi0RJkse+Kz2HOaYvuUupPrrilrOVUzvm0L8WOr0XEOi05U2PUQcVYLKX7nAZ8LVuMvNKWPXRRnO3jrve02HTa31xbyiwSvRLzF3Pq3i6gY4JziY7R10w0GGnOOT/J0mFTGopyip5EP3N+pr/mKLrUs3H9VRyL9sr1IVZcinB4Yp91Srs5H3LGXeZnzrgUKeoYyzpaCWtzu2TJWcQSXqWhWeq40rqyBIpXBqNL9r7X5ndPxTmzuudM9CwLJNf3XBxanC8WLBbxTTO9tvDnXBOQvRaX/TqGjgnOSe/HpMtDGc50hURTIS2o1BlWq+e0G0VnRBobuq5R7Ih94HLGvVwKz+amTfusM6IHTe+RfX4We+TYj1G6GekY3Xl3kCOL4rNxgIyjqTRqGbiqqaJHyYI9f8tU3MsYnQ1/6q0bnReHOOeAcdoYWy9WEuWJ+j6XJsNei6tqfi6gY4Jzp/2Y0JIeF425GhR7NK5Kfp9LjpnR2NDljcX+6kEorvn2yOv1NzZUrNbtQ9Ri4/wUm5ja3o9JKeqY9iCL7hlzNi5Y5azya+P8dN9mHPFRjL7IuPse/tSL1zpvZ6/W7T7Y+36OxeW4W6FjTiemaZJ0TERqFzNHFqXOyJ4e5CoUfSv6KTatxyTnfw9GpTtKzmLmnLHReZHUqylB6awxm7v1KGd6IJZNI1B0vvbzSjk/F9LnSnpxu5+1Qc7lNLrkLj7XD4fuvFjc3vfU1WJOvbhuUexG52fpRq7Htsp53YFcNr1CvfWcS0rTSjdzZ8WcSqeKxqi46DM6ZkNtOJTZ0BVH8RMs3ORonu/7Y3zhuskgpwzSTeiK3WcdOmaDMRxFSdsJR/ETLNz2aJ5Jx9QG7baDvDJIN6Erzjfr0DEbRgsHQCfwfb4A4GO0lY6OAegRdAwA+BhtpaNjAHoEHQMAPkZb6egYgB5BxwCAj9FWOjoGoEfQMQDgY7SVjo4B6BF0DAD4GG2lo2MAegQdAwA+Rlvp6BiAHkHHAICP0VY6OgagR9AxAOBjtJWOjgHoEXQMAPgYbaWjYwB6BB0DAD5GW+noGIAeQccAgI/RVjo6BqBH0DEA4GO0lY6OAegRdAwA+BhtpaNjAHoEHQMAPkZb6egYgB5BxwCAj9FWOjoGoEfQMQDgY7SVjo4B6BF0DAD4GG2lo2MAegQdAwA+Rlvp6BiAHkHHAICP0VY6OgagR9AxAOBjtJWe1THTNE3T9OXV62kqaJ2KxrZEdneFuVai43bE2royiuEt5hTjYzE2Ot8tkatuz30Fl1K68qgN8rA6prcpZ58SyioWjcbJUHsdqPUwPFuVf1+qQncZl9qxezvaSteCslxM512vBeH6Ee3uCiPjFOgYX81KQ2IvejOKZy0ZZtuab/SzW3IzasfaLKUU5eEIcuc6pnFWXHdSOW7/LTmVK6d97RvP+jzcMf8FWu//ihSCjhGp1jGichd1Qy7nbFhOUSVp69GKFbNZ7LmcYjTS46MYxY7oF7viwO3oUtRQboL5Zp19iMPiYvejCtM6jfPT0iOj8kh7JPZxrU2JRkuQxb4rPoc5py26S6k/ueKWspZTOefTvhQ7vhYR67TkTI1RB41Go2ORh1HA1yLFyCtN2EMXxdk+7noHLWGJ+ptrS5lFoldi/mJO3dsFdExwLtEx+vKIBiPNOecnWTpsSkNRTtGT6GfOz/TXHEWXejauv4pj0V65PsSKSxEOT+yzTmk350POuMv8zBmXIkUdY1lHK2FtbpcsOYtYwqs0NEsdV1pXlkDxymB0yd732vzuqThLq1tc73avcn3PxaHFeaN79nH3VRLlCX/ONQHZa3HZr2PomOCc9H6MuDzCs2m2NEM6GLWLU89pN4rOiDQ2dF2j2BH7wOWMe7kUns1Nm/ZZZ0QPmt4j+/ws9sixH6N0M9IxuvPuIEcWxWfjABlHU2nUMnBVU0WPkgV7/papmBrdMQwzhD/1Oo3Oi0Occ8A4bYytFyuJ8kR9n0uTYa/FVTU/F9AxwbnTfkxoSY+LxlwNij0aVyW/zyXHzGhs6PLGYn8d1zVfnfZo2xvdZdb5fIhabJyfYhNT2/sxKUUd0x5k0T1jzsYFq5xVfm2cn+7bjCM+itEXGT1KijPhT0edjnaVShpbt/tg7/s5FpfjboWOOZ2YpknSMRGpXcwcWZQ6I3t6kKtQ9K3op9i0HpOc/z0Yle4oOYuZc8ZG50VSr6YEpbPGbO7Wo5zpgVg2jUDR+drPK+X8XEifK+nF7X7WBjmX0+iSu/hcPxy682Jxe99TV4s59eK6pWjXPQ+zib0Wj6uc133IZdMr1FvPuaQ0rXQzd1bMqXSqaIyKiz6jYzbUhkOZDV1xFD/Bwk2O5vm+P8YXrpsMcsog3YSu2H3WoWM2GMNRlLSdcBQ/wcJtj+aZdExt0G47yCuDdBO64nyzDh2zYbRwAHQC3+cLAD5GW+noGIAeQccAgI/RVjo6BqBH0DEA4GO0lY6OAegRdAwA+BhtpaNjAHoEHQMAPkZb6egYgB5BxwCAj9FWOjoGoEfQMQDgY7SVjo4B6BF0DAD4GG2lo2MAegQdAwA+Rlvp6BiAHkHHAICP0VY6OgagR9AxAOBj7yDK3AAADk1JREFUtJWOjgHoEXQMAPgYbaWjYwB6BB0DAD5GW+noGIAeQccAgI/RVjo6BqBH0DEA4GO0lY6OAegRdAwA+BhtpaNjAHoEHQMAPkZb6egYgB5BxwCAj9FWOjoGoEfQMQDgY7SVjo4B6BF0DAD4GG2lo2MAegQdAwA+RlvpWR0zTdM0TV9evZ6mgtapaGxLZHdXmGslOm5HrK0roxjeYk4xPhZjo/PdErnq9txXcCmlK4/aIA+rY3qbcvYpoaxi0Xj5tamXMjp/JqpCdxmX2rF7O9pK14KyXEznXa8FU3AfFe3uCiPjFOgYX81KQ2IvejOKZy0ZZtuab/SzW3IzasfaLKUU5eEIcuc6pnFWXHdS1bZuz2+Ziue4htg5X98v1nr/V6QQdIxItY5RFH14oOScpcFIm0iPwzqjdShms9hzOcVopMdHMYod0UVJceDOdK1UJphv1tmHOCwudj+qMK3TOD8tPTIqj7RHYh/X2pRotARZ7Lvic5hz2qK7lPqTK24pazmVcz7tS7HjaxGxTkvO1Bh1cBej2Gga8LVIMfJKE/bQRXG2j7vewWLTaX9zbSmzSPRKzF/MqXu7gI4JziU6Rl8J0WCkOef8JEuHTWkoyil6Ev3M+Zn+mqPoUs/G9VdxLNor14dYcSnC4Yl91int5nzIGXeZnznjUqSoYyzraCWsze2SJWcRS3iVhmap40rryhIoXhmMLtn7XpvfPRXn/Oo2GvV2ixOj0fliwWIR3zTTawt/zjUB2WtxFcdoBR0TnJPej0knvTKc4pqZpalTuzj1nHaj6IxIY0PXNYodsQ9czriXS+HZ3LRpn3VG9KDpPbLPz2KPHPsxSjcjHaM77w5yZFF8Ng6QcTSVRi0DVzVV9ChZsOdvmYp7GaOz4U+9daPz4hDnHDBOG2PrxUqiPFHf59Jk2GtxVc3PBXRMcO60HxNa0uOiMVeDYo/GVcnvc8kxMxoburyx2F89CMU13x55vf7GhorVun2IWmycn2ITU9v7MSlFHdMeZNE9Y87GBaucVX5tnJ/u24wjPoqxcRXbvZrOo2P0RhVP2lu3+2Dv+zkWl+NuhY45nZimSdIxEaldzBxZlDoje3qQq1D0rein2LQek5z/PRiV7ig5i5lzxkbnRVKvpgSls8Zs7tajnOmBWDaNQNH52s8r5fxcSJ8r6cXtftYGOZfT6JK7+Fw/HLrzYnF731NXizn14rqlyqj4v/6c8/H0Oa/7kMumV6i3nnNJaVrpZu6smFPpVNEYFRd9RsdsqA2HMhu64ih+goWbHM3zfX+ML1w3GeSUQboJXbH7rEPHbDCGoyhpO+EofoKF2x7NM+mY2qDddpBXBukmdMX5Zh06ZsNo4QDoBL7PFwB8jLbS0TEAPYKOAQAfo610dAxAj6BjAMDHaCsdHQPQI+gYAPAx2kpHxwD0CDoGAHyMttLRMQA9go4BAB+jrXR0DECPoGMAwMdoKx0dA9Aj6BgA8DHaSkfHAPQIOgYAfIy20tExAD2CjgEAH6OtdHQMQI+gYwDAx2grHR0D0CPoGADwMdpKR8cA9Ag6BgB8jLbS0TEAPYKOAQAfo610dAxAj6BjAMDHaCsdHQPQI+gYAPAx2kpHxwD0CDoGAHyMttLRMQA9go4BAB+jrXR0DECPoGMAwMdoKx0dA9Aj6BgA8DHaSkfHAPQIOgYAfIy20rM6ZpqmaZq+vHo9TQWtU9HYlsjurjDXSnTcjlhbV0YxvMWcYnwsxkbnuyVy1e25r+BSSlcetUEeVsf0NuXsU0JZxXajfW2avDe0G56tyr8vLaHrFru3o610LSjLxXTe9VoQ3kdFu7vCyDgFOsZXs9KQ2IvejOJZS4bZtuYb/eyW3IzasTZLKUV5OILcuY5pnBXXnVS1rdvz26eicjk1rnejSxZndsx/gdb7vyKFoGNEqnWMrujDU7mcszQYaRPpcVhntDjFbBZ7LqcYjfT4KEaxI7ooKQ7cji5FDeUmmG/W2Yc4LC52P6owrdM4Py09MiqPtEdiH9falGi0BFnsu+JzmHPaoruU+pMrbilrOZVzPu1LseNrEbFOS06jMep1VX4RcbzWgsXIKw3ZQxfF2T7uejdr+644r8wi0SsxfzGn7u0COiY4l+gYcXmko5jLOecnWTpsSkNRTtGT6GfOz/TXHEWXejauv4pj0V65PsSKSxEOT+yzTmk350POuMv8zBmXIkUdY1lHK2FtbpcsOYtYwqs0NEsdV1pXlkDxymB0yd732vy+WM350M2V06ZYZ25itPtp8dA+7r5Kojzhz7kmIHstLvt1DB0TnJPej5kCVkt4Ns2WZiguJP0SppytNYrOiDQ2dF2j2BH7wOWMe7kUns1Nm/ZZZ0QPmt4j+/ws9sixH6N0M9IxuvPuIEcWxWfjABlHU2nUMnBVU0WPkgV7fstUFI3FHin5dWfCn3pDxnbFIc45YJw2xtaLlUR5or7Ppcmw1+Kqmp8L6Jjg3Gk/JrSkx0VjrgbFHo2rkt/nkmNmNDZ0eWOxv3oQimu+PfJ6/Y0NFat1+xC12Dg/xSamtvdjUoo6pj3IonvGnI0LVjmr/No4P923GUd8ao21ftrdDn866nS0q1TS2LrdB3vfz7G4HHcrdMzpxDRNko6JSO1i5sii1BnZ04NchaJvRT/FpvWY5Pzvwah0R8lZzJwzNjovkno1JSidNWZztx7lTA/EsmkEis7Xfl4p5+dC+lxJL273szbIuZxGl9zF5/rh0J0Xi9v7nrpazGk35lxSshn9X3/O+Xj6/NRbz2Uz9qjKJaVppZu5s2JOpVNFY1Rc9Bkds6E2HMps6Iqj+AkWbnI0z/f9Mb5w3WSQUwbpJnTF7rMOHbPBGI6ipO2Eo/gJFm57NM+kY2qDdttBXhmkm9AV55t16JgNo4UDoBP4Pl8A8DHaSkfHAPQIOgYAfIy20tExAD2CjgEAH6OtdHQMQI+gYwDAx2grHR0D0CPoGADwMdpKR8cA9Ag6BgB8jLbS0TEAPYKOAQAfo610dAxAj6BjAMDHaCsdHQPQI+gYAPAx2kpHxwD0CDoGAHyMttLRMQA9go4BAB+jrXR0DECPoGMAwMdoKx0dA9Aj6BgA8DHaSkfHAPQIOgYAfIy20tExAD2CjgEAH6OtdHQMQI+gYwDAx2grHR0D0CPoGADwMdpKR8cA9Ag6BgB8jLbS0TEAPYKOAQAfo610dAxAj6BjAMDHaCsdHQPQI+gYAPAx2krP6phpmqZp+vLq9TQVtE5FY1siu7vCXCvRcTtibV0ZxfAWc4rxsRgbne+WyFW3576CSyldedQGeVgd09uUs08JZRXbjRa7e23qpYx+nomW0HWL3dvRVroWlOViOu96LZiC+6hod1cYGadAx/hqVhoSe9GbUTxryTDb1nyjn92Sm1E71mYppSgPR5A71zGNs+K6k6q2dXt++1RULqf6xGhcm+fr+8Va7/+KFIKOEanWMaJ4F3VDLudsWE5RJWnr0eVbzGax53KK0UiPj2IUO6Jf7IoDt6NLUUO5CeabdfYhDouL3Y8qTOs0zk9Lj4zKI+2R2Me1NiUaLUEW+674HOactugupf7kilvKWk7lnE/7Uuz4WkSs05LTaIx6rRQs1hx6GAV8LVKMvNKEPXRRnO3jrnfQEpaov7m2lFkkeiXmL+bUvV1AxwTnEh2jL49oMNKcc36SpcOmNBTlFD2Jfub8TH/NUXSpZ+P6qzgW7ZXrQ6y4FOHwxD7rlHZzPuSMu8zPnHEpUtQxlnW0EtbmdsmSs4glvEpDs9RxpXVlCRSvDEaX7H2vze+L1Zz3M12b4Sm7M8WJ0eJnsXVLEXfolNrCn3NNQPZaXPbrGDomOCe9H5MuhuKaSTMUr7/6JUw5W2sUnRFpbOi6RrEj9oHLGfdyKTybmzbts86IHjS9R/b5WeyRYz9G6WakY3Tn3UGOLIrPxgEyjqbSqGXgqqaKHiUL9vyWqSgafd3UHZvM9/IqP8UhzjlgnDbG1ouVRHmivs+lybDX4qqanwvomODcaT8mtKTHRWOuBsUejauS3+eSY2Y0NnR5Y7G/ehCKa7498nr9jQ0Vq3X7ELXYOD/FJqa292NSijqmPciie8acjQtWOav82jg/3bcZR3xqjedbm+FPvXitn3b2at3ug73v51hcjrsVOuZ0YpomScdEpHYxc2RR6ozs6UGuQtG3op9i03pMcv73YFS6o+QsZs4ZG50XSb2aEpTOGrO5W49ypgdi2TQCRedrP6+U83Mhfa6kF7f7WRvkXE6jS+7ic/1w6M6Lxe19T10t5rQbcy7ZjTn/159zPp4+P3UHctn0CvXWcy4pTSvdzJ0VcyqdKhqj4qLP6JgNteFQZkNXHMVPsHCTo3m+74/xhesmg5wySDehK3afdeiYDcZwFCVtJxzFT7Bw26N5Jh1TG7TbDvLKIN2ErjjfrEPHbBgtHACdwPf5AoCP0VY6OgagR9AxAOBjtJWOjgHoEXQMAPgYbaWjYwB6BB0DAD5GW+noGIAeQccAgI/RVjo6BqBH0DEA4GO0lY6OAegRdAwA+BhtpaNjAHoEHQMAPkZb6egYgB5BxwCAj9FWOjoGoEfQMQDgY7SVjo4B6BF0DAD4GG2lo2MAemRVHvuma3cLAM7OaCsdHQPQI+gYAPAx2kov/6fN0SIC0APoGABwMOAyR8cAAADcCAPestExAAAAN8KAt+yyjpmHjAsAAMCxGPNmjY4BAAC4Bca8WZt0zDxqdAAAAA7BsLdpq46ZB44RAABAz4x8g0bHAAAAHJjB785ZHTMFrMbGr6CYtkR2d4W5VqLjdsTaujKK4S3mFONjMTY63y2Rq27PfQUtpW4gyJeht2jYB0hZxXZj1dqsjZVexOjnmWgJXbfkvB1cxMzz/P8BkYvpiwaYRsAAAAAASUVORK5CYII=" alt="" />

图1-1

接下来同样的脚本我们在sql2014中执行如图1-2

Code Sql2014 tempdb does no eager write

select @@VERSION--Microsoft SQL Server 2014 - 12.0.2000.8 (X64)  

dbcc traceON(3604,3917,-1)----catch eager write

select * into #ttt from dbo.bigProduct

dbcc traceOFF(3604,3917,-1)-----remember turn off the TF!

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA0sAAAD4CAIAAACykOpnAAAgAElEQVR4nO2dP2skSZqH82OcIVPGnbcNY9yZO6YscV+h6S8gQ856jVhrOGsNMWprQOassdDrCFkH6zRojYM9Y1GtccYYixhEGYVAkGdkVVZkxBtvvJGVGZmV9Tz8aKqi4s8bkZUVv47ITFX1+gmhOevf/v0/EUIIIZSlavL5GyFdk58kCCGE0NEJh4fmrslPEoQQQujohMNDCCGEEFqacHgIIYQQQksTDg8hhBBCaGnC4SGEEEIILU3V3/7nqVHdsPla//pxr83XGgAAAACOChweAAAAwNLA4QEA+FSfq1nVAwCQyzQOr6q2KkG1k5Lovq3iCj8V6wyr9TKLb6vgtbF/n6tG3uv204y6hiaMp0dZrzvhW3v9Yp3TIsYTCzIW9uDdEZs2jtuBOQ9MPDCkNr9bMDeAMJuxXQCAAZlyDe8Qh2ctW0mviyXqb2OeL39YvHkou/w4uNNkmGgsK9bTz8LOx/i26N0MX4thD37QRSsjvhbLHpLzwMQDQ7LHpqfj8ABgDiza4Xlrae4LL9HN7BVUqk3mVPLHItSrirUwb4eXTLRkM86vufFMS653iQ3L2Gt4J+XwLN80fTHVvvgKADAeAzu8dvvVdWCxPVkxJczp1em+Tfi80MCJrq6S8tfSR+3rqu54sjBPLF1xeGIANkSHp2wheR/FDKK+M6XkdPPoiXqnLG+z5k5lDUxcLfNehK+NxbNiszu8foOQFUzWR7UavKXUGA6vzXDI/y7EkQ+Pu1KDpWkAgAEZ0uF5rk5JTL5NFs9YwzvQ4YVmTvFhoe0LKxQ/CuLx/JDnLUKT4f27b8G2GBObw7zXWXNtzE6FiTHCPuqt59ZZjzMgYvFkVMnXytuk6zrQXifTxQw9HNV4Ds9+RIwOL4wEhwcAs2KUNbwwJbY4l8wZc3LlHF5tSwzbFd+aHV4W/Ryenn6g9Ym11WOq0/vVb+50i4vWxzgg9uKWYJSG9I8GNxC9j11uVIP/v2LwkGrbd97+5QEAKMMo1+EZF9t0w6cXz3N4SatXBxnq4HWYOLjDcwPLoaTD0z8d2+FVznJm7wotxZXgLY7BHlXWyIsrSfbVKTu9PUru0pql+LQOL9miaPf1OgEACrDoXdo64qh6ODD3tT1Rfxurp5TD67dkZUwU64wl6tnChvotZQ0VfG93q4dkqedwQ2nE0m7SynjWR29CL25PzP2/isiBXxXjUQMAGJWBHZ5+q4SYM3lPhnKjhnUlr5WeWMfztDm9UmG6UkMdlPKyhTFY+tdd1nLfiosKSkpsiWjAnG6EyU4lG/L6mHR4gwQfq9ZSXAlJP0axRCW9N3qPdDulFI9l6913Y0Ox4grhFyys3H44cHgAMAn8TQs4PoY1NAAhQ33B+KICwFTg8GCZvJydIzQTTX02AMApMrDDm/yXFCGE5qbhf7kBAFLg8BBCaFwN/8sNAJACh4cWq+FPF5gNVVVVh/zdQwCApcN1eABwZFQOU8cCADBTcHgAcHxUXaYOBwBgduDwAOAoqQKmjggAYEbg8ADgiMHnAQCI4PAA4OjB5wEAeODwAGAJYPIAAFxweACwHPB5AAANODwAWBr4PAAAHB4ALBN8HgCcMjg8AFgy+DwAOE1weACwcDB5AHCC4PAA4CTA5wHASYHDA4ATAp8HACcCDg8ATg58HgAsHhweAJwimDwAWDY4PAA4XfB5ALBUcHgAcOrg8wBgeeDwhufm883UIUwPgwBHBz4PAJbEKA6vqurmt7F9cbx4P/TuT784DXjOJjZVhOnKpGKZacTiSutitkNmtbDgkZq86nNVfT7yb22EpfZrWPB5ALAMxlrDa38VR/p5LPOz27YSWrFYGK6t8Uop1cZy1oHF1OO01CkawVh3jIhBztDhGS3O6Tih0+lpFpg8AFgAODxrE64NilkixdPoLkr3glmdNbpGvWwPxLJzM3k4PI/T6WkPpvV5YesA4FLyfDxSBnZ4zbasuzkbpijpsczdgvIxbt+K6VVgcWI1VJJDqgPn5P7bIhqasJVYothQ2EoMS516hYecM2LZMg6v2Vf1dle9FDePZ2vC9OaFcbtWrzM3TrddPQA3m1hK7L4YjCX4k6XwvGKf3gCgYdRT8qgZ0uF5Xm2QxHhb8kpYFbcylWSYlMRYVe6nXh7jGl7YqB5S1jdYLK4Mi57ocvP5xlOyeGfPumspXBfSO7HurkLpid5rvbhYVYi99azY7ObS+1cvrndfD+nEKTCpDDzpAZwYg5+SC2B6hycWN7SV4VG8b0CsrPddqUZzeJZEMZsFr6Del2Riv3ZbCqzhJVe57A5PTEw6PONKWMzhxRb2lEa9bKLDU/InU2I9OnHGm1SYrgB6wImTZPkOL3RRxrK6w6ultbEBHV7d/frGqlUaUhJPweEl18yU4lkOL6v10AVmVStmG9zhWZo+WQafUZifAA4Bk6cwvcMbdpdWSennsfRPwxaT99LaE8WUcHs0K/hYSpgoNqSgD8V4jLRLqxTpVzzLStptVmjvlOLs0g7FUJMKMxPAIHAqiYx4p0UzyFXqTotkYrytzoGMHV3xwOs5La20b72oLM/DsyeG6THjFRY3Vuimex2xWzSxzmI30uqbpOEGaHI7NXx7eOvGzVwlZ6z19l+leHI3OdkjCKkCehcfKUKAk4JzyoO/aTE8YzubYs7pkIbm9pyUyWFtbKn083lMRQBjwJnlgsM7JnJ3Tuff0EnB2thS6WHymIQARoKTqwWHBwAwAHafxzIDwHhwfrXg8AAABsPi85h+AEaFU6wBhwcAMDCKz2PuASgAJ1qNwwMAGAnR5zHxABSAE63G4QEAjEdo8iwTz9vV+cuZTVePYdnX25Wb8n576aaYKm+qfb57lTNcv+2rf1yfXW6epS4EsR3I29X5y8Xd+7CVplltLs7XD81ouB1veVyfnb+cna8fxOKPa7mUxPPdqzSYc2K1udgf2bwjYujd++1lWOH77WWP7xIOr8bhAQCMTZa9M7DzHDs6Hi6YRz2H5/NwnZw+Q9fo2B3R4T2uo46nP56feL+9jDrdh+v2o7DvTcH4mDSOrbVlgcNzKg/8rlgbDq+ua2vvmqPTfnkOsfWYPBweAEAJhvN5qsMLFkKET7OWBh+ud7U5Zi50eL7viavvhO1O9l3T+bh2Y364funEuc/prl9GHN5qc3H+enGZcHiRLpjGVmk94YFG8c2ZjOPwoqvFnvLsLw4PhwcAUIgck7fd+3O1m90TDq+uV5uL/VyorOGl91K9rcnW3GhreKvNhbJC1h/FT7zftp6sY0FqeePvcR3xWM2GoFNbneXwAlabC8XU7j61GuLjcni5vduX6vQxujmeBoeHwwMAKETOBXne7p478yUdXgd3ucu+yPRycfcemaRfb1eaw3u47mxcpi5f869g62ywPhr9xN7GPd+9ChV6HjTi8Hahhg6vs4x0K65WCn18uzp/vb1bn11v5AMkuplgMC/u3oMD192UF9xS4933pfxK9tFuR9WtJ77l/XJ1JxwRuWxG71JjgsPrCQ4PAKAQ7pRTyuEFU+a+/l4LQs93r9tJXXR4QbXyDN3xWG+322leuAbrzOLwnIWl0EYIm4Oiw9tHLq/htTxcv1zcba6cRGlVb3d/QHMcO6uqbtg5HigY2455XW0uOrvYeyPYOrDtSHY2tbeD3LbSZO5seatHJCi7G1gc3vTg8AAACpEz5Qzl8MQ7IfQdtNhylNNExOEJJkycocOVtm1V58F2c9rhvV05MYcrdkJbgsNzN6wtDu/NucEzHH9na7g9jvJ29gEOTyvujVVniIIrGr0j7nTfcESiZe29s+3nyru6Gjg8HB4AQCEmcHiRZRL1Yv+2XeFawO0sKzq8Zjtvu3Cl20fpAjXBiqUd3vvtZcfSyQ4vtYbX3VmO79I61+HF96m7vsc5jn4HD7sOL3J3QpPBu8JSuA3ZdXjeqLZj2OOI7Me/33V4gQ9mDe8AcHgAAIXIdHjy5J1weB1L5992YJt3e63hNTt0F8Gjy5QZuvUosUvoUn7Ct3diJenr8KJj8nq7it9psU3vPq2tqcp7XqB3VWLvfUzB4cX22Wfi8LJ3acNvCw7vAHB4AACFOGANzyXi8LZXxHubcZfB40K2NxMY1vD2JB3e21Vod7QK9+yv9Ar3BIMrxuI7jzv8O3mz7qXdF+kuZLoOb99HecCFGyO6lrH7bBeXvKelaL3Ic3jdYXQyG45ItGxu73aB5X5/4uDwcHgAAIUYaMrxHd7uMW/u9OksJnWfCdeg3lRrcHh7Ottq1hn6+W7tLjq6V495V/VFHF7E3vkVmi/469BxeG382xfO4G/XIIs98dgP27sxpX6+e3XHKsPh6bdWqEckXjazd5GDhcM7ABweAEAhBppyutcqyfuS3VWiIE+PNbyIBezl8DoVhhextStekaeliJegRf7chddri511HV73OSzXb7uNxb3FfLiOXtS4HZ/h/qbF7sEl8uNvgqel1O5bdZf2LTJidfeIrB+EXVqlbEbvpP+H7NJxeD3B4QEAFOKgKcd9LFniMbPSjNj962SmNbzOg9C8XUXn2jXPOjSPTMu4uF4hvI6wNG9X7ord9frKdzl1XWsbr7P/q2Xl/tqv1rv4U7JxeAcwmMP7BQAijHX6wrHBlJPJ9A5v8ZRzeMXhdBvM4T399QkhJGqs0xeODaacTHB4o4PDWzA4PIRG11inLxwbTDmZ4PBGB4e3YHB4CI2usU5fODaYcgCKwek2jcOrqrrR5FNvGFiRVqr23wI9KjbUzbnkvjiwHmX0ksVbBunRgRrr9IVjgykHoBicblOu4R1iO6Z1hwe2Ljo80UnYE/U4iw1XG9vh1mqo4pNE4pUa6/SFY4MpB6AYnG4n4fBuPt8cMscPGHkVoDuJoRxeMeHwxFJjnb5wbDDlABSD021gh9fuCbreIrZRKKaEOb063bdJB9N4O/ff+JQsh+2+0Fu374d6a3ii57Mn6t2xdCoMPmuQvcBiKV56boVKWbF1b7TbbO4LpVqvzrBrek6vzrFOXzg22i/G1IEALB9OtyEdnucYvBfea/1tsrh9derm800jS2bRtFlat8cmupDwbW6ipTthp5Ij7/6b7FGsd3qivU79reK6vPQBg4/F6bUy1ukLxwZTDkAxON1GWcML/URs0SuZM+Ytijm85GvLp6GlCP1NSYdnCf7YHV6y2kGCNzY01ukLxwZTDkAxON1GuQ7PaHd0w6cXNzo8+y5tMqRBHF4VoJsSHF6YU3RplgXRWNlDgsfhQRZMOQDF4HRb/i7tU86dFqzhlXd44gprjzU8yxCN6vCUmMc6feHYYMoBKAan28AOL7YbG7uuX7/eX0ls0xXnkaUwpHC/OAzVEqdoKWK+xLJAFUtUeqQnKp11h0LvlLcwKa5TuultSszhhTnDVsScYrtZIVnaMjb3hMMDh/bbMnUgAMuH042/aYGOW1V85Ww+Guv0hWPDPOWsNheXm+f9+/fby5ezc1evtyu56PPd69n1m1bzuVeVoP2fsXpcu7U9XNv/wtXbVTzIrFLPd6/JgM/OX7w4/UF4XJ91hrT7kT9iseDF9DAxPF4x7Qv6B+5xfXa+fpCibQ5Bm//57rVJkY/OanOxreftKhbGdmRiYTthCGP1fnuZ/3fP9lG1b3t8W3RweDg8dPSKraLNR2OdvnBs2B3e++21O/2/316685/31uXtSv9Drt7MKuEZhYfr1gFkOTzVVIVuY+sbIg5P8axtW/s8suUShqWJsK/D2/lIi5dN26BONx/XZ9Hj+HZ1vn5o83cMnHRkOxmkOPeHSRqlXfHtoRfGqk596wLj2NTQ9tHwnewFDg+Hh9DoGuv0hWMjb8pxFqK8udl1ePbloshsGszZoY17uG7m79zVGsWJxlAcnmqkdr0IFvxeb1dbMyGsWjWl2hEIs/mrg40xbcJo4zE4PM3EdB1bc9z1MB7XV4/b/A/Xu6aD4K8eu9+N6/VoDs+0CLf7XsWXEs/z1wI1cHg4PIRG11inLxwbxiknmGj9DbuIc7KshfRyeNHAvHoy91KDwLRNzMT+8m6xsLvg13ivYIVp52k8L+X0OmY017sK17fRvePX21XebngT8/Pd69n15vbyJVxWbGxra7LFenYuPDhMA+3SJhxeU1Zban2/vXS/eM6KY7TOA8HhDebwfgGACGOdvnBsWB3e8926u3Hp+6rWmnRNiWFppJnv4/6j8Qp752Exbcr1bdm7b4616i4LPd+9xvd894QO7yJ0HluHtxtY0y5ts365cdbt2oMireG5TtrZrXbDc5z0zjIGrs71WF54V9fOgDyunaPc/Q9AiV3a1tFqi6zufxvaawfr/Qrx4ODwBnN4AACgkzPlbP3N25Vp66qxd7Kd6qzJBWt44VVu8TU8wWtqF8nFHZ64EbnbwnMd3r64cPOEhLSGJwV2uXlub2fZuhbNIl89tsuBr7crQyt5Dk/4KO7ttome/7663nkv4SaG9cPjetcFcaAaOg4vvBxTcXiN/36Ifxn2Pdp66/VD09xdcxTU5eGe4PBweAAAhRhnymm84KO2LRh3eFtb406uUYcnOTbNeCXX8MJbMdzwQoenLSVuvYt8HZ7Xa8+mPK7PrteJO1S2GO+l7e/wdvF7m/LSIq437G2LnVHdbbymLOzF3fuuoTDb6+3KeKdFxFKvNhfnu+KXm4e71+3Saft6lJstcHg4PACAQmRNObvJMrqj2r2DMj5Hxtfw3rdXfTVNRJxH7WZ270vwM1vu+ehM/832XGf71XUn9lnf2c+Nrq49rs+EPG3M4vZiaK3aCuOdbeLPdnhvV+cvZ9dvupG9uNtILq1pqInWvRvm7Wpr/YVd2vga3jabc2NEwuG5R1DcTG86tXN466vd0HXuBRn+UjwcHg4PAKAQOVOOZwuCx+P5JizX4W1vjOi6PfeKqzCezjrZ3lVEN5ETa3hvV3sztK25szRlv4zP6bu2f7qr0Lk5t3MdnuKuOp5p+DU8d6WtDp574hnNztvwGSv+oLWRrDYXsRtE9n53vxNtdXirzcV5NLxtdy43t9f7NbztQe8sNA7+MLwah4fDAwAoRsaUE38oXeSmRfXmTd/hRR631jQqOLx2l23Hzlgk766NWjTnWvvWJnav83Puh9DWBZtlRYvD84N3GpLX1ZQ1vFRijsNrDu6D79U65rszLK2N859Rsl0IFCOJXSrnhNQ4yyyHF/vPhj8gD12H17m7wn++91Dg8HB4AACFsD/xWJgj2yvM5DWzPru0Mr7DC+ydQ+oZdamHwO2fsdKYD3em1x6YHDSkPS3Fz+7eyLktHt93Ht3huQ6s6zvjYdTSBZSNvVv7t+Zs699asXBzdp+yt9SCw5PGKvqEFGeVt+50tnOPy/5BgFePmQ/TNoHDw+EBABTCOuWEFzN5G4jCslmGw0teLbfP39jKnvuw8U/390Psb//0L4YzPh6l7u7tyndadAiWndRnvI3q8NzK43cl+2Fsvwy7NdTdX7boDKb0fBzhDlz3KAiLdtfri+62b3fBT7t47vnu1R18917a2+v9pvzF3eaqvaN54JstcHg4PACAQmQ88dh7Il3seXjSg239PMFzg61reA/XwUVdtf9kY+eZcGnjGLWn7pVYjgc1/yGs2A0Ee+/VsciecQwcnmODhAfRNe4n4Y+Vcd53MHC06TDersT4/bFq9rv3l/d1nnEor+H5f/RMuBFkf1BsD/FxAtvXZrycYABweDg8AIBCMOUAFIPTDYcHAFAIphyAYnC64fAAAArBlANQDE43HB4AQCGYcgCKwemGwwMAKARTDkAxON1weAAAhWDKASgGpxsODwCgEEw5AMXgdMPhAQAUgikHoBicbjg8AIBCMOUAFIPTDYdXiJvPN1OHMD0MApw4TDkAxeB0G8XhVVXdDGn74njxvh9VQCzRxXM2sWxhuvIFtXxrxeJK62K2Q86Q5FAsj+pzVX0+8i99hKZrXu/ERGNVgwTTVuWlhHEe0txQMOUAFIPTbaw1vHZIRxrbMsesbcVzXfYMDa6tsVel1Gn51mbFKRrBWHeMWMzuIhnJTEzrUdrW3TDERL24ktIjHvffWGyDNDcUTDkAxeB0w+FZm9AdjxKP4mnsdYavs0bA6Br1sj0Qyy7e5C3b4SUTjcUH6Y7dxuHwAE4NTreBHV6zLetuzoYpSnosc7egvHvYvhXTxTUwPWfS4SUXyRpEQxM2HUu0tK5gqVOvcDEOz9vO89LddSBlp8+S01hcCUmMXGxdea28sAyU3k1llCzB187y2yHbvjGHN5KhPJy+U85qc3H+ersaJSaAhYLDG9LheV5tkMR4W/Kil+Ja7M5MXCRzcyru0OjwxDqz4sz61orFLQ4v2crN5xtPyeKdPWvp2qkxEt3mOhHG9xwtO4C5OcXX/dxMVp2eOTO2EnutJyarVUJKtqhXq5jO43R4q83F+ctZRFeP+4zPd69n5+uHcYIGOE5weNM7PLG4oa0MO6Ivznl52pyKwwvrUSrP3aU1ms5+Dq92vN0gDs/ebsuEu7QxnxEuUHn/5uYMW9SXsnoHn3xt+bRfncmq9JxZo2SsdnFreKvNxeXmuQ7X8N5vLwOH1+QEgC04vOU7POPqV5iYdHjJphsGdHh114nGqjWGh8MTU9pExbfZcyZXznB4tWGUjNUqxY/c4dV1Xb9d7U0eDg8gCQ5veoc37C6tktLPTimfJuNpSd5La08UU8Lt0WSdSUcrJooNKWStaBYgy2cU26UdNvisnHor0zq8Q9bwZot1ynm+e41tzop7tTg8gAAc3oh3WjSjWqXutEgmxtuqPBMjHs6qi5co5rS0kizoYnkeXlbNXnrMeIXFjRW66V5H7BZNrHPaBTxx+y/cePV8W7iHqOc0NqTk1LsQ61Ss9VjYyYHS4zwkeCUke516N8PMliDHJnPKeVw3vu357vWMXVqAPDJPtwXC37QoxNjOpphzOqShxT8nBUAnZ8rxr717uzp/vX1s773o3FqLwwMIwOHh8I6e3J3T+TcEsFTMU07m41FweAABODwcHgBAIXLX8NSL8K7fRo8X4IjB4eHwAAAKkevwmkfcvd9ebtfzHq5fLu7e62bRDocHoIHDw+EBABRiLIf3cP3CE48BuuDwcHgAAIXA4QEUA4eHwwMAKIRxynm7sj0M7+x8a/gAIACHh8MDACgEUw5AMTjdcHgAAIVgygEoBqcbDg8AoBBMOQDF4HTD4QEAFIIpB6AYnG44PACAQjDlABSD0w2HBwBQDmYdgAJUDlPHMhk4PACA0akCpo4IYMlwotU4PACA8QiNHRMPQAE40WocHgDA4CjGDpMHMDacYg04PACAYTCaOaYfgFHhFGvA4QEAHESPVTpmIICR4ORqweEBAPThkO1X9moBxoAzywWHBwCQwSHGLlbPSKECnBScUx44PACANEMZu1idA4YKcIJwNoXg8AAAooxh7JT6B6kT4KTgJIqBwwMA8Bnb2CXbGrwVgIXBiZMEhwcAsKWksbM3DQBJxj5DjxEcHgCcOjOZNorNhQBLouRJelzsHR5CCJ2UlDljtoEBQMPkPyDz11zMb27c3//2+1//+QtCCOVKmTMmjw0hhIbSvByeMfPN5xscHkIoSxg7hNBJaXYOz7KAh8NDCBmFsUMInaZweAihBQpjhxA6cVW7e2W/ftz++n0M7p4NPvr7Dx+EbCM6vJ//+DMODyGUFMYOIYQaVdWnr3Vdf/1UffxzXdf16r8+NCl7/vyxzfPhv1Zu5jIO7+c//nzz+QaHhxCKCWOHEEKeqg/f/bCqv3501+e++2GlOLwww5gOr7F3ODyEUCiMHUIIxVR9rD5+dR1e53XD6ofv9ru0By7g/e73f/iXf/2PVr/7/R8Uh9faOxweQqgVxg4hhJKyODyH7QKectFehslr7V3M4d3/dI/DQwg1wtghhJBdhl3aPasfvvvww987+7b91vN+9/s/uPYu5vBck4fDQ+g0hbFDCKEeMtxp0bIzdoc7vBDlTovG5OHwEDopYewQQugQWZ6W0rBbwHMzD3fLhf60lPuf7nF4CJ2CMHYIITSIeOIxQmh6YewQQmhY4fAQQpMJY4cQQiNpXg6vvXM2KRweQscrjB1CCI2tyrJmVkbf//b7LE0+dgihLGHsEEKomGbk8BBCi5Ri7CaPDSGElip+YRFCowhjhxBCE4qfWoTQkMLYIYTQHMRvLkJoAGHsEEJoVprLvbS17TkpCKFZCWOHEELz1Ix+hb//7feTx4AQsghjhxBCM1f19U9fv/7pq/dnwSbRzecbVvIQmrMwdgghdCyq6rr+9Z+/fvzxy+ShNM8xnjwMhJAnjB1CCB2dqqdf6/tvm4+fcHgIoY4wdgghdLyq7r9tvvz4dKDDU37x7ZMBDg+hOQhjhxBCC1B1/9P9/U/3WQ6v/aHXX+ROEjg8hCYUxg4hhJakqq7r+2+bp29P9982X/769OWvT6t/rNLFupbO/dfLECsYCoeHUHlh7BBCaJGq7r9t7r9t2ofSffnx6cNvPlpMXqeWYDJgDQ+hmQtjhxBCC1b1cnaOEDo1hcZu8pAQQpNrclOCBhQ/6widqDB2CCFPk5sSNKD4fUcIIYTQ+QsOb1mqXs7Ov/z41F6Ht1lvVv9Yffnr04fffEwXli6/a19wHR5CCCE0f+HwFinH4X36WH/68Mv//fLxxw9Jh9fePGsxcMZrt3F4CCGEUHnh8Bap6uXs/P6n+2YB79d//vq3//3bX/77L80dtdEywdPvYh+FOVnDQwghhGYlHN4i5Ti8Tx/qTx+evj19+PRBcXiV+tC7mMNTElvh8BBCCKHywuEtUnuHt33i8Y9PX358uv/pvsd1eO0urecCvT1cHB5CCCE0H+HwFqmtw/vwm4+hCoeCw0MIIYTKC4e3SFXzOaI4PIQQQqi8cHiLFA4PIYQQOmnh8BYpHB5CCCF00sLhLVKzc3g1AEcKCUMAAAbcSURBVAAAFKR1eFMHAkMyI4eHEEIIofJiDW+RqvDsAAAApwxreIsEhwcAAHDS4PAWCQ4PFktVVe2/AAAQA4e3SNIOz/2LFAe11MVN6VGPmDJgkMeSEo6qWKpNV2q25wkzeIcg9yjEiuQOjlI2Kx5LKUs3jUen36AdQm5zA0Z4yDEVo8pq2vJ9tlfYo/gYR7/898dt2vtXzzkrLF8GS9gTjv+A4PAWiWkNz52cDmpMqqdHnV6R9uw6/IfSe31EKcmxdQfnkDweIx3TWKIlxZ4tl/CLl5W/th3TMtjbGjvCQw7W4L0Y6ifO+Onh4znV98dt0eLwYmWnJRaDfVTH60Xh8cHhLZIJHF7uNKnE075dpMMLY1Py6E4rZgdz84SMdEzbxGTNOLx+4PAOrLBHcRxeWHZacHgtOLxFYnV44lwrprjpXp5YPWGdYSViilLKKxjLo0QyeYrXOz2P/tproneekJGOaRhPLBIxNmO2sKHwS6X0VOy7WCQ58no9YUhhzGFb9o4k2xVfi+F5h1scMaV+JaVwL2Kt6+OsdFb8MiRThupXGI+SEobkvRZjTuYRG1Li6TEasZiNAbifiq/FhsSwvdfeC3vf9bYGBIe3SPLW8MKUHi/Cb7ax5lie8N/YC/3cCM/qaVPC2GJ59Nf6kNrziIx0TI01x2IzZgsbshwFJWYF73vo/uLbgxSjPeRktJAbYSzmZLZYyiS9GPyF2G7y652kfL/EmL0whj3KWQxyFhhHNfw0OWLGM1epeSRweIukp8OrnYnKSwkz6KeTZdYUT5JaOlsspSzdFGsrnBLGFsuTfO0di955QkY6pmE8seYsAehdcNvKqkT/YhtDyh3ncHwsecSPkjGHOS3DqMQj1mAZ52K9UL6rSuuWF2K7Yoq9U8n6wy4o/QpbV0beazQZRo+jHMZjpMfxUmJLfufFt7Em3OFKHguxX0owh4DDWyTDr+FZSimJlgq9F+I5Y2w9liH2szW3FPvrOjI4PfKI+ZXEHsfUHkm/6UT8NBZ2LKXfPCF+e5NBZhXPGvAk9tnOEkaPH4qSvcj6Qo707dUjVHJmnadD/YYbv8Y9jrLlIyVz7tGJtWj56bC07r6NzVaWdrNGww4Ob5FkPC0llt5+WcOcYgaxhli68jZ8XXdPFb11Y2fnn1IH53yss27iIXks4Snpytvwo7BOMafYkdj4iB0Ji+jjE0aSO0TJtmJNizHH4lGaC3utN63nDI9FsqfhEQxTSvYiOYZitHr3LeOjpxzer1g2sTuxPLGGqu74x/KIESpt9R6Nuu/xSg6X3pDYKfHTOhi0rKpyR8MIDm+RDPbE4/BLPC1ziwfKE/6MQsh441Ny5Jd6lKcaw3mO5zyjWgY4vEUy5N+0sPynpyRziwdgboxq74qdfUs9x8v3a86/mfOMajHg8BYJf7UMAADgpMHhLRIcHgAAwEmDw1skODwAAICTBoe3SHB4AAAAJw0Ob5Hg8AAAAE4aHN4iweEBAACcNDi8RYLDAwAAOGlweIsEhwcAAHDS4PAWCQ4PAADgpMHhLRIcHgAAwEmDw1skODwAAICTBoe3SHB4AAAAJw0Ob5Hg8AAAAE4aHN4iweEBAACcNDi8RYLDAwAAOGlweIsEhwcAAHDS4PAWSdUeV4QQQgidsqb2JDAkODyEEEIInb/g8JYFDg8hhBBC5y84vGVRTR0AAAAAAAwMDg8AAABgaeDwAAAAAJYGDg8AAABgaeDwAAAAAJYGDg8AAABgaeDwAAAAAJYGDg8AAABgaeDwAAAAAJYGDg8AAABgaeDwAAAAAJYGDg8AAABgaeDwAAAAAJYGDg8AAABgaRyNw6uqjFCrLkpisvKsdgEAAADmQLZ9mcTx6C6tCtArqYNeWIokMwMAAADMhDyzEpoq762Y6BZPpiiNGgOLlY25QDHg0DUqBhEAAABgVuRtfXov2teh49HzxFKMjRpz6m5Pj1PvkSUeAAAAgKmYu8Pz8ovramJ6uPYWW5CrJW+HwwMAAIDjpY/DC1Nizqk2+0LFMOnV6mXDT8XMMYfn+chkPQAAAABzoL/Di1mcmPfq5/Cy1ghjK3zKp25Vis+zdx8AAABgcno6PH3JTczTew1P/LRHithcLCocHgAAABwvh16HF6ZkrbqJnypN6/n1CsUFPC+e2MpfWCEODwAAAGZLnk0Rdzzbj8S3Sh4xRWlXTzFWqFhDZcWuzvGjAAAAANOS7VQmMTfGPdnQO4ZFjMuHSovYOwAAAJg5x2FW9GU/ZdFO3HV161QKivUAAAAAzB9cCwAAAMDSwOEBAAAALA0cHgAAAMDSwOEBAAAALA0cHgAAAMDSwOEBAAAALI3/B3GHYNeAkFMbAAAAAElFTkSuQmCC" alt="" />

图1-2

通过实例我们可以看到在sql2014中,tempdb中的操作并没有因为select into而触发主动写,使得磁盘写操作得以避免.

注:此特性只实用与tempdb中,用户数据库新版本中依旧有主动写实现特性.感兴趣的朋友可以自行测试

也许有的朋友认为批量写入已经是优化行为,这个tempdb中的小小变动不足缓解其瓶颈问题,这里我们通过一个简单的实例来说明下.

Sql2008R2 SP2 code

注:测试前请重启下sql server实例,使得tempdb计数尽量准确

测试结果如图 1-3

use AdventureWorks
go
create proc p_tempdbtest
as
select * into #ttt
from dbo.bigProduct declare @t datetime2=sysutcdatetime()
declare @i int
set @i=1
while (@i<100)
begin
exec p_tempdbtest
select @i=@i+1
end
select [extime]=DATEDIFF(S,@t,sysutcdatetime()) SELECT
d.name AS database_name,
f.name AS [file_name],
f.physical_name,
f.type_desc,
vf.num_of_reads,
vf.num_of_writes
FROM sys.dm_io_virtual_file_stats(NULL, NULL) AS vf
INNER JOIN sys.databases AS d
ON d.database_id = vf.database_id
INNER JOIN sys.master_files AS f
ON f.file_id = vf.file_id
AND f.database_id = vf.database_id
where f.database_id = db_id('tempdb')

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAt0AAAHfCAIAAAADdfMzAAAgAElEQVR4nO2dP27dSrav90AcegDX2e3QDhUpvsCLDE9AgQZgaAgXD4blqAFP4AEdGY4u0MkBdIIDqCOrgxt00DAOBAWCAAN8AffmLtafVavIIllV/D4sUBRZLNY/Vv32YpE8dF3Xdd3Nx5sOAAAAYFMO/R90CQAAAGzOXnTJ4eNNb1snBAAAAIIk65LDoTsc5p1ydgzJZzRyl0uarJ+L/qTzY9gk5fk5DI133ZNmwrrimv9hAACgZIq/JMvouCaCLpkjUzS5SM3poiVjRl6KNJmTDM2xqfGvVSzoEgAAL1pdYv7OtoY370/wUPhhbyh+N/LO9ys/dF5/4k+5s27lDDd39Ld4ksrB3Bgqn9Tw1hYzGUnlY26/+XhjmRFubNbGLrzL3RhatwJ7T6HfHtoYij81vLXFTEY0PSe8lxvSBACgU+oS73BobTf/DYX3Rij/O+Fwl15zmEtrl5LUcgilLTW8cKCp24YA0fLROkvcsVleTw3vHuINIAz8SecNbYyGFw48OCty/F3XoUsAAMIk6xLzX+v3fWicjkboRiWEFM4bPN0CusT6N1f6U3WJd0UuH/cUWn/JKJbwemp4l1AhyHGGXCDeeJLCRxNgrQjxd12HLgEACDNXl2jC6yN0/9X4G6KE7uOYu1Tx6MphTvpz6ZJp8UfwjspChFn8JdEECNtT45d3aRIQLZOu69AlAABhknWJxi+Seh9BuHGTV5fIu6IaRVMOQvo1/iQ57zN1id4xcwqk+FcQAd5dgn8iqjNcB4m8XRm/91zeYOgSAICFUemS7jTcWrMZzO3ueBy6iSCHN+OXb0ak3sdx14ctk+e9uuVgbbd2adKvDB8qMSH+pELrutMYH7gZcQygDz9sdKWDGz4UzyEQT2i7Jn7hFEJ47xnd9PiKAl0CABBCq0tqh/eqLYJG3IAPnhMGAPCyF10CmRGcKKAAXQIA4AVdAgAAAKWALgEAAIBSQJcAAABAKaBLAAAAoBTQJQAAAFAK6BIAAAAohb3oEt5fAgAAUD7JukT7qtAlY0g+Y+xl86l6ZeX0AwAA7IQp/pL5o3JpumTBU6NgAAAA1Ez8Po67XfjIS/T7c6F4vN+Ckc/rT7z4PeGk+ztCZjvHFZT8PRoAAIB9o9IlXq3QOfLCu907JIcOzHK4Sy87zKU3gJ6QrnL3IkcAAAD0JOuSbqw/Qt+tjZxV9JdEx/XQeYOnW0WXRNcBAABAZq4u0YTXR+j+G9IlSQj3cawA2gjRJQAAAAuQ8z6ON7w3mP7GTV5dMjlANAEaXYJGAQAAkJk47zV0K8cNH5oPGwpvxi/crJlwH8dd74x5r8rZr6H7Vm6avVkDAAAAAd6rBgAAAKWwF10CAAAA5YMuAQAAgFJAlwAAAEApoEsAAACgFNAlAAAAUAroEgAAACgFdAkAAACUQim6hPeLAAAAQBG6RHgfq7BRipC3qwIAAFTIUrokSRhEdUnKeY/MiQQAAAA2Ifn7OJrv4CR9vKYTv/frvb9z8/HGMie16BIAAID6SP6esPmv/FnghER8vLGW3gAJEaJLAAAAKmSKv8S70d2VkIhEXYK/BAAAoEmmzC8J+Uu8YVQRhu/jWAG0EaJLAAAAKiTnfZzQIVGREJUd6BIAAIA9oNUloXmsml3xRISfxxnmvSrfbnIYEz83AAAAFEMR7y/peK8aAAAAlKNLAAAAANAlAAAAUAroEgAAACgFdAkAAACUAroEAAAASgFdAgAAAKWALgEAAIBSaE2X8B4UAACAepmlS6Kvc/XuVb4EVslN4F2xC31nJ/Qy2dD2ZgQfAADAChzcb/NO+4Zf2lk30iUJUQXEh/dfIRi6BAAAQI9HILhDqfmlG+urN+bG0CGeszrbQx/ZkblxPqYzrIS+sxOKxysg5usSN5EAAAAQQqVLuvD3gV2NEjpK2C7/K+DVJebSPq9vo6Ab0CUAAABrkqZLzKW53V0PbfFutz5KvJouid60QpcAAACsiT2/pNtIl0xDfx/HCiBEMk4YugQAAGA9SvGXTCOkS0IwvwQAAKBktLqkC4gSYT6s975M6nYZQZeE5r3Ks1+N9Izwbh/FH9juJhIAAABCJOiSMnGlSVHvVaurMAEAALZl7vtLNqfw1BaePAAAgKJo7T30AAAAUC/oEgAAACgFdAkAAACUAroEAAAASgFdAgAAAKWALgEAAIBSQJcAAABAKcR1SdILWLVnzR0hAAAANIDqvWrICAAAAFgB1XvovV/AGXbJ27uxx0UI3C3jmwEAAIBa0OoS73eDQ58Fdj/I50YonAJpAgAAsE8S/CXuv9ZHgKN6RbkFXQIAALBP7PklXaIu8UeKLgEAAIB0ct7HcQO4x4YORJcAQPkcALZm64tgceK6xJqUKsx7deXIcKAc3p0ku4OSB4Bq2HokAvCw9WWxFCp/ydxzNFt6ANA4Ww89ABG2vkTyo3p/yZR4A88PAwBUwU7GAKiO5lsm76EHALBpuNOHNmhYmqBLAABGtNrdQ3s02VbRJQAAZ9rr5aF5Gmu06BIAgCON9e+wH1pquugSAIAjzfTssEOaab3oEgCArmvrFyfskGYaMLoEAKDrGvq5CbuljTaMLpnI4ePN4eONuQIA9dJGhw7QQEtuTZesKRGGcwknzZUepA/AojTQmwN0TbRkrS4RPoLjrofCm9s7xfvpU30SfbDBQrvcyIct0fOakVgHuudNSo9wiBAPAGShgd4coGuiJat0iast3HXhg8ChMJpys4ZnTfjoRkF/uLs6n3BxA1i7JqcnFAw5ArAcDXTlAAO1t2etLgl9N7jzKYxQ+AmllDo2h3RAyA8RXQlt1GxPTY+1K5ovAMhC7f04gEnt7XmKv8TdKzhU9PH4D8mkS+TA6+uSYAZS4gGALNTejwOY1N6e5+oSzX2c0HblfRzvelL4JXTJhPs4+vQo4wGALNTejwOY1N6ep8x79c51Fea9aubDBs+bPt9TOZ/UXe+c+SVCPG6YUDqV6QltlOMBgPnU3o8DmNTenkt/TnirYZjhH2A/1N6PA5jU3p6L1iVbeQjwTADsitr7cQCT2ttz0boEAGAFau/HAUxqb8/16RL3IVt8GwAwh9r7cQCT2ttzfboEACAvtffjACa1t2d0CQDsndr7cQCT2tszugQA9k7t/TiASe3tGV0CAHun9n4cwKT29tyaLsk1DZbptAD7ofZ+HMCk9va8oC7Rv9Q12xnX+jBNql6pt30A7IHa+3EAk9rb87L+kvnFkhRDro/ITI7HLcba2wfAHuA6hZaovT3P+j6Otd17lBCPd7t5VOikwUQGPqQ3bLE23ny8sWxaPGaE/oRV2z4A9kDt/TiASe3tecr3hL3fEHb/jQYIfYtY82lifzqNb+/Nv48zIR50CUCNpPbjL1evf77S2dV399jHTw/mll+fLs0tqsj7aH/cPvoDXL+co//+9Ory+YcvC07aCuLH7aMv2Sceni9eP307/x/Pzo/bx4vbX8HiNUtsNj9uH/NGmMgudEkX8HNY/gyNLgl9l1g4r55UPSH7S+bEY5Vnve0DYA/k7sftUXOkPJwR19IlNt+uowLC1TrG0OjVJd+fXo1SGDz1aeS24zd2mcn79elyPN7bpx4FEPKVrkukMvxx+6jJr5NC6xD/LkeF/Pp0ua3m24suGR2j0BPeAKHweXVJ57v/YgVYKB78JQA1sqou6ceti9tfwt4kN8y361NshgRxdYmpJGTrY/t2/XMU23ng//Xp0hAc35+M9Pz6dGn6HsYhLfUwOtAmny6x0iDzcmX4Tr5dm/pD2DU+xcPzxfIuGZFd6BLlfRz9gfpgSfd0orJjwvM4SQHQJQA1Mqkf//7kjD2ngSqiS7ru4fniPFIK/hLV7QlzwBs0iuQveXi+EL0LpzC2I+SkpaxUvVy9HnZZuqQvJVEx9IFDY7lHMI1vxFw+f/LprSF5Z9E2KvMAthvJyJqwa1w+Xv/WORlrsBddEp2vKt/iSdoeOns8M+HnaJI+8jc5HuF5nKpbCUDbTNUl5gBsapGoLhlh/tZXOUvOg7R/OH/89CDpkm/XI+ngnQzh3vgw3Cdj8TFSMMm65Cwaxqdz/SWjoV3yl3h9J6p7K96T9tkRdo04qx/jjBohmJPaRxzeq7ZsPABQPpvqEmdIPsevnRIxop/gGdQlTrRBXTIehkdbej10+fzt9vGV4zYwYhvd+7AxBc3CuuSkISTZdyw0u+IMXRLYZZ3opH7OXiW/glkQdAkAQN1sqku881Ll+xqeQc4ejAO6xLr7MA5pYE4uOQczMmXMVnFGa/fGloexZJmiS/qieP50+fPq1jzcVxSB22GOYhil6vi40/FfYVfXdV33/WlUsH0Kt3kqB10CAFA3W+oSz8yD46DrP2QkIzxzXIyf/o4u6cXE1ffggcNY69cl5n2c0ZRY730cwVnizEWdMr+kL+FfPx76LX5d0s/YvQjcxPF5Moz5K9cv4wDCLmsuc19NT1eTPF6zQZcAANTNqvNe3d/9oyFTM0JP8peERujk+SXOnaDg1BP/Eze+B2Tm3cc5vcelLwHrns7Tt/DkktgdFlttBHfZTq9jGk4vTVkZdAkAQN3k8JeYBHTJ8d7H+Pf3xaX5CO7gYwi6WALv7IrqkuAI7Y/Qnqp5HoYTpsTaz9N2kRknVqq0zwmfZnIcNx7zaORrqi4JTf3xJGBU+Ea0kRerLAO6BACgbpZ+f8nJ/+/euTjPqXRfAjvLX3Jm9FNerUs87y8xvUH28zjB54RHe7WipEvRJb731P28+m76V/S65OVqPLfX8HYEd1l34uxbYIK4WQp0CQBA3eTux8defb+DYXyDw/e4R6q/JCBcpuoS6c2n45tN9vtex7ENE1C8b80P3eZQ6hKfpOuFwotRgCn+kvPtOaf8/bterkKKbXzgim+ARZcAANRNnn7cfKFqcFZB+DGN8fu4VP6SwMvgjRPZifl1enolOr10Y8K65FQyl88/Qu8FOT3GHFBj2nfhpyG9qcU3kWhB0CUAAHVTez8OYFJ7e15clyhf1QoAsBW19+MAJrW35zX8JdUWDgDsgtr7cQCT2tuzVpcIH7XpfE4RM3C1hQMAu6D2fhzApPb2POt7wt1YkXi/M8x9HAAonNr7cQCT2tvzWZdYNgp0sM3c5a4LOgYAoDRq78cBTGpvz1P8JaFd6BIAqJHa+3EAk9rb8+K6hPs4AFA4tffjACa1t+cp815N/WFNfRV2AQCUSe39OIBJ7e2Z96oBwN6pvR8HMKm9PaNLAGDv1N6PA5jU3p7RJQCwd2rvxwFMam/P6BIA2Du19+MAJrW3Z3QJAOydef3496fAl29HfLv+eXH7fPX66dt528uV+wXa70/erw33/Lh99O09fiD36rv/K8QlfB94FqOP8b5cbZKjQL2cPukc/pLwCOvLxguBLgEAqJtZ/fi365+Ckjjx69Pl46eHQVi8XI2kw9O3h+eL09gmRDjWJWcVchrqjmexkocuycBZl4zEnyUyftw+iooQXaIBXQIAeye1H/e7Jbx2HIQeni+OPhVzZBr8JS9XoxGulxfyWQb9YUa4gC75/vRq5OPZgiRdMj/BoxjcWjjteni+cE5kCkdfyaNLNKBLAGDvTO/Hf9w+am7iBO6/vFy9fvz0/ewpUZ3OjsfSJbnv4+xdlxgbrZJX6ZLnq4CyXNLlgy4BWI/Dx5vetk4INMXkfrx3eLzExp6Xq9c/X10/96Lh4vbXaVKCY9dPx6iOWuflaix6xrrEPu/Vd9lfchzRzXsN4m93S+WcYzZjMMbX3utzPuri9tcoknHK5ZSYRXR169ElvmNTE9xLENML4onBujVzzsXD88Xrp6vrURrwl+RgQV2y1WteVxi6ZkaenMKDYaG9ofDmgd6NcvzR8JrtBvYnIY2iiBaIGaBZaRKq5aVPmgmrfkMdS2k/hCb24+GJIP3wdvox3Q9+1y+dM1Z9u/7pcbcYE2ktB4nHXzLyJcgcdcyQgH7EjRzrOA9GaX54vrDk10kNDMP5Mf7vT6/G2kJIybdro/ROgcVjDTWmT/D3J+PAl09DvUT8JYnzS0bTotElGpb1l8wvlgkxZBmxVhj20k5xcFa8e0OBvYd71zXxa+IJRHUT0BYaoSbokuJkypyWrzk2Nf61Oqgd6ZLgoP7wfPHaVBsvV68fP90+ubrEL0q6zh3JRmPwWJf0ybi4fLz6bv76906J6N025uG/Pl3GJu1ag7Rz88K4k2XdYbFOZ+4VUzKSC8NJx7pEyIU6wT9uH/13fEYxuM6wU9q080vsG23okhizvo9jbfceJcTj3W4eFTppJKm+vAy/y0Njobvu9WoIkZiHy+cNpfPm441lRujOvz78m6Qn9DpjWjyBynKdJf5wAbyV1Yn1FY5L9Pd04V3uxtC612lknUK/PbRRcJUlhbe2mMmIpueEtxupQpqk9+Pfn169frzwjDHu7IeXT/2P5pEu8dz6uTB/r5t65Txn1tUlvz5dPl5c/ry4fhpPUvGOf56ZGUFtNMrpefS1b2o4usc4qXU6U2BJKfHIhdj8klEu9AnuFaQ71cPjL3HFkH0f53zTx72Pc1Yw6BINKl3iagh5e/RAIR5X96QSVQDen91Jv7+9YsVaicY50V/SOUNCqi7xDioTdEkonsCg1fmaWZKe0JdtLKLwv9711PDuId4AwsCfdN7Qxmh44cCDsyLH33XdnnRJP62kH2OCk0tGamOkS56vjnMmzoPf6P5O+IUoti75/tRPW+mdJZYIWEyXhGaVFqtLpGmwg3C5CN/H+XH7eHX9dJz3c1Izwfs4vvkl3677kOgSDSpd0nV+v4Xlz9DoktB3iYXzpuLVJVEXSDQSYa8rbkyZIpzXinZv/hL7UN19nAy6pAv/7hd0Rmp470lDiRHiDLlAvPEkhY8mwFoR4u+6bk+6pCc09vserrH9Jecf63F/iYHz/pJBHnXeOMdTNd0f/Yp3gViDtHuTZRybXpcEU+Kewp2bIuQiIcFnRjNabF3ycvX66Vtfg+a9mwePsmTeaw60umR0jEJPeAOEwq+gS+Twy+mSpHRKyLok5KLQKIxo/JPjcciiSzpflc2aX6LXeW74RXXJTH+JcpcmAdEy6boOXdJ1nUqXXD6+Oj4e7PeXjGd9dt3oZoQZ+cvV9UsgGUF/SXh6aQB7XB9P6e19CYZiSNAl8kTX0QQdz7zXYC7UCf5x+zQEczwuj+au49yd07zXH575JccC571qOVDpEuV9HP2B+mAT7ukkiQzNfRz9jaE1dEnSWKX3i4Ti18csb++6LvAwjvmvFVg/HyUpnsj9CHcM1pS54J+I1p3rIJG3K+P3nssbDF2ypi45Dld+f8mvT5c/X10+f7OeMUlOhnAf58V4nET1ng/nVeujB1Kc54St0wn3cYSUmHfH+pfhWvdxpFwkJfi4feygMmLoxV/0/SXHesdfkgOtLonOV5Vv8SRtD51dm6XYvFdhrqv3EDked91MQ9J9nHCWAk4Rc6PXdR/aYu0Ke+Yj4UOBA3h1Rmh+iXcyind92KKMR74ZcQygD29VgXtUKCrvdiue0HZN/MIphPDeM3qbilMUu9Yl5/dthB6xOfo2/E9zGM9umLcJpJkrziMe0kyXYbJtGe+kLyclajzfxxm/7ER6rGkss5ZNaLcTXVIXs1z6K1JLOvOibGkeJ0fXdWHxkRpPhFov5+3Z0XPCFRJWA74HjJfUDRXqkpqovT23qUuShq71KT+Fy6HXJWue7kzM5QMy6JKSKUcNlJOSJqm9PTeoSwAAkqi9H1dSjhooJyVNUnt7RpcAwN6pvR8HMKm9PaNLAGDv1N6PA5jU3p7juqTevAEAaKi9Hwcwqb09o0sAYO/U3o8DmNTentElALB3au/HAUxqb8/oEgDYO7X34wAmtbdndAkA7J3a+3EAk9rbM7oEAPZO7f04gEnt7RldAgB7p/Z+HMCk9vaMLgGAvVN7Pw5gUnt7RpcAwN5ZuR8/fofW+N796NPEZ7SfFO66ruu+P50/ZWysn75ULPLwfPH69KHjMT9uH4UErPKRPy0/bh9DH/VV5uJ8uFWYQsgjL1dDAX5/WuWjwQLoEgCAupnWj48+c2+pim/X7q5zeEeCCLokNMLZh5j649u1OXC+XL3+eR5lz7xcDSkJ65IIxzHbOrbPqT9CX8lot796/XMY8h0VEihDf+BAXkK6ZHysJ7ZUIbgs6BIAgLqZ0I8bv4+74/A80h/jX9tB18jxt/Vx44/bx5GA0OuSkbBwR2jPmD061xRdcpJZoxH65eosINwIX648noZOLrFv115R5RwV8i1dv3RnJTGuNYuj/jCz8PPi9pfGX3LWImEX14piBV0CAFA38/vxX58uh7HK8EOc/jXGpJFEOI2Xw0ZXbeh0iXfslG79jEbfyE0Nl9PpQv6J7vuTq0vGXhwTqcTCuuRYCH3Ib9eexNiuC/m+mHkW018S5azqhvSIAmhx0CUAAHWTR5echkBToxzHwqvvnSsFLm5fPHLEnJ2QNL/khO108WFLhCR/SZ8q+RQeXSIM1aESOyU1KhEeni+OYYySdDKlKZlz+vuQhuCzfSenBH+7PjqHjPjRJXNAlwDA3pndj4+H0mHk/nb7aDvwzZBnd8jI+XH+6Z8yv8TcHrll4E7MTNYlscCuLulPaigtjyfDV2Lj+SX+0jCcJWfXi+ueCTtsfOm/fLq6fPx0+9Qn5sft41GX9DEMKw/PF5ePF68fPz28XJ2T57qj1pwJiy4BAKibmf24Z9qEMZqOBqT+wZCLy8fjbJLjUWN/ychzkKhLBBfL+VyOqlhJl9jTQQL6Q8qyvff7k0ffBMSHM4XWsiHBvap4/PQQ9Zf0teB6R/CXzAFdAgB7Z04/Pp596WzphYgxJfbx4vLnxe3zeNwaRMZ4pkW6Lvl2/fPV5dPVpXWU40SJz0cJD6uTdMmP20fflrO7KFBiFp7JOma+ftw+vrp+uprgnDhn6uXq9dM33/wS30M9L1f+6bTokjmgSwBg70zux11R4rlLcp4h8f3pPKfE+qF/ii1hnqY7eA83ic7zLcYJCLHafRxjw1mXCCVmMy4iWz0c1cDxnksSlgQ8xhyZHWzcPEKXZCSuSwAA2mZaP+5/6tVwAxw5jbL9DRRpXogdW5q/ZBzDacz+dq2Y3LCCLgnPQg2XmIvpT7LHfmP6iLUr9vDR9YutjVx/ycnD5FM8Xl2i9j/lB10CAFA3095fEpjHYE1xOE+k6H3+Pl3iTLYwtmt1iTu6qx6cOYdcWJdYCsl8SUmwxLque7k6p3/knbKeAbaljFR0gQSHnxPu7+AMS6em8JfkBV0CAHsnuR/3vtf8PFyN779Irzg7hgyMoGnvLxm9V234jd5P9ozc10jRJR4BNE5VYL7tcKyvWIQS8z2ae5wFYh7rakT7jXYS9qM6Z11yntEyzC9xSgBdkhd0CQDsnTX7cePVroIzIzazZDzL4TyvInTLYBAEV9990iFg1gxT3/at8TlmzljPb4+wyuEUyankL25/WfpjPO/VnIGLLsmLVpccDkfr162N5l4rsDcSbwAhntAhAADzqb0fBzCpvT0fbj7euGYHOozWrX+j60JU8rqwAgCQi9r7cQCT2tuzJ92yLvHu8rpG9OGjpVdt8QJABdTejwOY1N6eVbqk891ksba74f3nC0QSSWWtxQsAFVB7Pw5gUnt71uqS0THOPRf8JQBQL7X34wAmtbdne35JN0mX6MN4w6NLAGBDau/HAUxqb8/a+SWpc11zrYe2AADkovZ+HMCk9vacMO/VnRoSfU5Yud3a656dJ4QBYDlq78cBTGpvz1PmlwAAtETt/TiASe3tWfX+EgCAtqm9KwfoORhsnZaJ8B56AAB0CTRCAy0ZXQIA0EJvDtA10ZLRJQAALXi/Adpow+gSAICua6VPhz3TRhtGlwAAHGmjW4d90kzrRZcAAIzu47TRucOuaKnpoksAYNe4iqSZ/h12QmONtlldcvh4cyg7U9GX2yY1sOz5Lb8AAWYS0iKN9fLQNu0112Z1Sdd15Q+rwneVJ7x6X5PfpDIpvwABphH1juA4gfJptZW2pkv6X/n9gBodVs2QVuAhnmG7G615iBs+nlTHKTKhXYXy602PuTGa3yFCfXjhFEnls229QNvo79foQwKsSfMtsyld4g5ImkPc8cwdC63A1lgYCh85te9mTeijhqHEyxnxBpPj6Xz5dbeHwidtF9iwXqBVpvXm3qMAymGFa2dlmtUl7r/RQ6KuhdCKFXiOLnEDKBOvSb97iBx+WvxRP03h9QLtMbM3X3mYAVCy3CWzLeiSKf4Ad/ybktqYX2SyLsnoL0mNXxNew4b1Ai2RtzdfedQB8JLxAimTZnWJ+/vY+6nk6Pin/F2enFTftBJLpiTpkpCfQ/CXaPI7rXyE8EpWqBc+nd02DXTo9aYcYA5N6ZLOcN13zrDqjkNuYGtI9t4OMGN2w2vuF1gPA1sPBuvnlwj5FcrBm8hQfvXh5UJIK59V6qWZNg8utSuSgQayAJBKa7oEQAPOklZpRpEMtJQXAA3oEtgjNPj2aE+RDLSXIwABdAkA1E3DiqSn4awBuKBLYBusmR/KqScAJs0rkoE95BGgB10CAPWxH0UysKvMwp5BlwBATexQkQzsMMuwQ9AlAFAHe1YkPXvOO+wHdAkAlA6KZIBCgOZBlwBAuaBIXCgNaJs2dUkVD3d4X+rqvv41Hk84s6FdQmDVKTeiimqFXKBIBCgWaJgGdUlF45bVpVgfx9HrkqTtE6IqiioSCXNAkUShcKBhmtIlqS/DCH1BxorKDTxsEcLHU+s4Rab1MF53SKgc5ETKUWlSskJ5oksaBkWih1KCVmlKl/QkjVvWSOmNwTuUmmNqKHzk1L6bNcN9HH1XM8FfojxkQr5WKE90SZOgSCZAcUGToEtuQuven/jelWkvLY1OIlnuPo5el6Tma4XyRJc0huMIvP0AACAASURBVKtIGGX1UGjQHugSzzgq/L73rkwbKaN+kRJ0iSoFgUMWKk90STOgSLJA0UFj7EiXeD9tHx1Hlb/vkxPpm1ZiyZQmdcn88kyqXygTFElGKENojKZ0iez/d8ctM5h7i8HdFZoP4Q0jpXP8MLD1YPD8+SVCOeTaHkrJCuUp6BI5eVACKJIloDChJZrSJftkb/c1vPnFWVI+KJJFoVShGdAl1aN0ZjSAkFMacMmgSNaBsoU2QJcAwFKgSNaEQoY2QJdAGu7klZ14ayAJFMkmUNrQAOgSAMgJimRbKHaoHXQJAOQBRVIIFD5UDboEAOaCIikKagGqBl0CANNBkZQJ1QH1gi4BgCmgSAqHeoFKaVOXzHxIJPsDJlli47EXKAQUSS1QO1AjDeqSXCJgfiTZKTNVsB9QJHVBNUGNNKVLUl+q4X6fxdzlbtd8/0U4xJvUbqw25MQrdYmcL2/Kzcj16YH9gCKpFOoLqqMpXdKTNIJaI7Rmu7se/bCcECB0Ik08At5oQ/GHvp+n/GAetA2KpHaoOKgLdElEc+jX9X4OIYWyvydJl0TTKQgXyyeEy2SfoEiageqDikCXpOmPrvP7EuQEKHVJXn+Juy74S7wrCJHdgiJpDOoRKmJHuuTm442bzSy6ZM59nC6gG5bwl0TvHyXpEm95Qu2gSFqFCoVaaEqXyPcdQrrEDWxu8Ubl/hs6aWhXNHznSAf9/RQh/d5d7hk1522jzcAAiqR5qFmogqZ0yQSm3argBgfOksZAkewEqhjKZ9e6ZMJ0TmaA9uyzwTQJimRXUNFQPrvWJQB7BkWyT6hxKBx0Sa24k2lw5IASFMnOoeqhZNAlADsCRQI9tAEoFnQJwC5AkYAFLQHKBF0C0DgoEvBCk4AyQZcANAuKBGRoG1Ag6BKABkGRgBIaCZRGm7qkoodTakkn1AKKBFKhqUBRNKhLUt+TtlxKKkoDNACKBKZBm4GiaEqXpL7MI/rxGu9653NypL5BxIo2Go8yqZpTQ3ugSGAmNB4oh6Z0SU8Wf4k19pvr5jftvJFo9JAcoTL+UDywH1AkkAtaERQCuiRZl7jrE/w03n+FeEIb5RNBw6BIIDu0JSgBdEkwsPfmSEiXzElhajyTzwtt4CoSBhLIAi0KSmBHuuTm442bTcH9sI4uEe7jyAmT09YF8gtVgyKBpaFpweY0pUvk+ymhcVq4+eJuTJ2XGk1q50gTNx4hcuGkbdQp9KBIYDVoY7AtTemS7Hh1ySYpSQVnSTOgSGB9aGmwIegSP7JzYqtU6aFCGwBFAltBk4MNQZcAFAeKBDaHtgdbgS5ZCneySy2+FtgQFAmUA40QNgFdAlAEKBIoEJoirA+6BGBjUCRQLLRJWB90CcBmoEigfGicsDLoEoANQJFARdBKYU3QJQCrgiKBGqG5wmrsS5fU8lDMhumsonwqBUUC9UKjhdXYkS6pZbjdPJ2bJ6A9UCTQALReWId2dEnomzLmutIP4f1yjfWvGybpM37exMxMZyiq6Hk7p7hCSYrmCyxQJNASNGNYgXZ0SRf7vm7SsGpJEG8kGo2yZjqjEWq2hzKemjBAkUCT0J5haZrSJZ3otEgd7/Xrwko08ui/+nSaG0N+Du92IQE4SyaAIoG2oVXDoqBLIvFo1gvUJUnnVSYAaRIFRQJ7gOYNi9KaLunCT5SEhtWbjzdu9vX3bro6dYlwo0qpV7zltltQJLAraOewHLvQJcJ9jc43vlqTQL23QtxorV2aRMo3WZIikbMsZE3YLiempTYzBxQJ7BMaPCxEg7oEVgBnSYcigd1Ds4clQJfAFHbeYFAkAB0uE1gGdAlAGigSgAEuBMgOumQp3Mki0562zRUPzAdFAuDCFQF5QZcAxEGRAAhwXUBG0CUAEigSgChcIJARdAmAHxQJgB6uFMgFugTABkUCMAEuGcgCugTgDIoEYA5cODCffemSWh5mWTqd5ZfA+qBIAObDFQTz2ZEuqWUw3iSdtRTOEqBIADLCpQQzaUeXWD4G7zdukr47Y65Y271hlB/ts5KX5fs43nW3TLxb3PNG0ykfUhEoEoAl4JqCObSjS7rc3+n16gzvuqBRVkhnaF2Ix93lDRxK2JwEFwKKBGBRuLJgMk3pkk50WuQa74VzKV0m2XWJK4aSEhAKL/hv6nWWoEgAVoBLDCaDLonEo1lvWJfo01A+KBKANeFag2m0pku68C2M0PB58/HGzb7+3k3XnC6J5qK6+zgoEoBN4KKDCexClwj3IzqfLjGDhW5huNFauzSJFG6O6G+ReEVJKBLNrmj4CYncCleR0D8CrAmXHqTSoC4B6FAkAGXABQipoEugNVAkAEXBlQhJoEugHVAkAGXCJQl60CVL4U4WmTYbI1c8bYMiASgcrk1Qgi6BukGRANQCVyhoQJdAraBIAOqCSxU0oEugPlAkAJXCNQtR0CVQEygSgNrh4gUZdAnUAYoEoBm4hEFApUsOB9u820NHebeEjtqKPjnzI8mSmK3iD5009bxDo3C3T4i/CkUyXEH964O9/2rWrTi921MTtkJ6JiQy2mnMr2QeXiuWkq9l2Bytv8SSF3PWTV1SFJuM+guRNy9JsU04deiQ+YpkgqJKCj9gXkHW4J26Hop2MiukZ1o6rcr0dhSTQY4UDtIEQqTpEu/vG3ddCJaqSyxPjbXRWg+F18TfncYk699ON1YJHgJlYoQ8huJPLQQ3jDKdytHacat54g8daG9JVCRyOwkVnVAIQng3tdblM3gd3L1b6ZIV0pOaVLdLSRqeQt9sMtfxlxQO0gS8JOiSkN/VXZd1SefrkgKJs8cGeV0IH43fO2a7GmVyglPT4w0f0j3RqLzb9eWW5EUQAqtSle4jUbaTJcL3oEvkXV68nYCp/uIx5PsuN2wFugRcMvhL3H4kly7pwr/jBY2i9E904fFGWJkWoT4S+Yx6xZCkS7qYP2AdXeJVJPqqjLaTUPioLhHi7/Hqks4RBMp1IeZprJOeLLrEDRCJxPCXhHZByeAyAZc0XSJsT9IlcpzBNPiGnAmjoByhvDItQn0km+iS7f0ls+eRhM6SxV8iH97l1iWpWiHKOumZoEtkvwi6ZCcgTcAimy6ZuR5IXHyYFwYV61/3UQLhPk5oZX6CNZHo1cYEv4h7llA5pKY8GtgTc8BHoj+dG60m7+bGpPDeXAgj9Mw5p7IOUEqB1dKjSUxP6P7vhN8toRkk6JKKQJqAiUqXCJNLhK7Eu3fYormLLN9c6HwDhhDe24+bgd3DzRUpoeJ9ASH9QlSa+OX8ytutE3lzHT2FnMhQORzPIvpI5pxXUw6h/HrDRxPjDvymi8KrJ7yHeI91t7snFSgtPV24H9D3DKPYHF3CvNcaQZfAgNZfUiapP6yhBPLetSmEla8gvbNkHYpKDNRIS70BzKRWXZLqhIASaFKR9KyvS9Y8XZTS0gM10l63ANOoVZdAXTSsSAAgF/QP0KFL9LiTJ6Y5bHLFsxUT0p9FkdRebgCgAV0C6BJYEHwkAJAE3QWgS2ARUCQAMA36jZ2DLoHMoEgAYCZ0IHsGXQLZQJEAQC7oSXYLugQygCIBgLzQn+yWw/0fdxg22VxFsnmSMAxrw+hY9mnoUJgIPhIAWBp6mB2CCMWSDR8JhmGrGV3N3oxqxhIMRYJh2MpGh7M3o5oxlaFIMAzbyuh5dmXUMRYxFAmGYZsbXdB+jArGgoYiwTCsHKMv2olRu5jHUCQYhhVo9Eh7MGoXG5mrSOgCMAwrxOiX9mBULXY0FAmGYeUbHVTzRr1iKBIMw2oyeqq2jUrdtaFIMAyr0eivGjYqdaeGIsEwrF6j42rYqNHdGYoEw7AGjB6sVTvcfLzBdmJeRbJ5qjAMw6YZXVmTdnj39h3WvHkVyeapwjAMm2l0aO0ZGrNxw0eCYVjDRs/WnnFbrlljHgmGYXswurjGjFps0FAkGIbtyujrWjKqsClDkWAYtk+jx2vGqMJGDEWCYdieja6vGTt0W7B5tlsyFAmGYdg90qQV26by3r19t3nOGzAUCYZhmGl0hg3YNjV38/FmEz9NKptXT7DaUCQYhmE+o1es3TbTJVW4TApMJIoEwzBMMPrG2u3w5sPdmw9rn9WrS/7+P3//+//8/W//72+mff3r1w1Lp/frbF5Jx6pCkWAYhimMTrJqO7z/3Mm6xKrXLNXs1SVfPt9Zt1H+/Pef7z9/2bB0CvHroEgwDMOSjN6yXju8+XD35j/EEDFd4h015dYg65Lnp+e7P7u7P7uvvz2//7BrXYIiwTAMm2Z0m5Xa4cvnuzf/8T64+1SdwgBpVnlo3TJBl9z/4/7u97u73+6+/vb85fPdTF0ipEHTUjfUJSgSDMOwOUbnWakdvny++8t//sW/L6Y8hi25/CVffr/72//725fPd1//+rW3JF3iJti7ok/tJroERYJhGJbF6EVrtIgucavTq0ui65Yp55d8/e356Dj5/e7L73cP/3yI52csRMylnKpCdAmKBMMwLKPRnVZnh69//RrSJccQAU+DGUDvgegtpEv+9b//+vPff/757z/vfu++/vb89bfnQaP095s00sSb+GmpXVOXoEgwDMOWMPrVuiyiS1JrURk+pEse/vnQPy3cPzD85fe7ruu6z1+6z++/fL67+02SJlGpJKdwQ12CIsEwDFvU6F0rssOXz1+i93EOp7sh3mFexhuz8j7OUZd0Xdd1D/98ePPh/Zv/eK+cpSvs0id1aV2CIsEwDFvB6GYrssN//9//Fkb6UdDY7FdrKZigS/qHhP/89593f550yef33Yf3Xde9//zmy+e7Nx/iqRVkRyhtK+sSFAmGYdiaRn9bi8V1yVCLgi5xR3254mVd0ouSuz8704Py/PT88M+HL79LTzWHkndfkr8ERYJhGLaJ0fFWYZIusSov5H4I6RWh7gVdMoiSu99PuuTD++7Dm3/977/ef34T1SWDhNIM/9GmmVeXoEgwDMO2Nbrf8u3wl//8i/w8zjno1KdtXYvrkt+797+/+frXr8ML6e//cf/3//m7/i1w8i435KL+EhQJhmFYCUY/XL4V9D3h/omb/u1qvR11yYc33Yc3d7/dvfnwRtAlsmwK6RJhYyidaeWLIsEwDCvJ6JALt7J0yZsP7//r//zXmw/ve+t1yfG9ap/v+vfATphfMrQ/9zaT2Trz6hIUCYZhWJlGz1yyRark56vXTZqydKbpEhQJhmFY4Ub/XKyhSyRL1SUoEgzDsCqMjrpY26ku6XLjKpLspwAAgIzQY5eJVpdsLqCy2BLZcRUJ6hvDMKwKo98u0A43H28EGwZyOVgtljc7XkWyeR4xDMMwvdF7l2aHd2/fCTYM5HKwWixXdryKZPPcYRiGYalGN16aRW6qWRMy3r19t/ytJS0TEjN/folXkUyODQAANof+vCgO93/cPfxxF1oOA/nD6eGU/jD5qBWWZmL0zNElKBIAgFahYy+Hgzz8mxNFTSmwrSh5WFeXoEgAAJqHHr4Q8JeIpYMiAQDYB/TzhbC2v+RwiJyxEH8JigQAYG/Q4ZfASv6SXHJkBX8JigQAYLfQ82/OSv6SwyEigErwl6BIAACAIWBbsvlLhlq0hEi/pd81bB8CD+uheNbxl6BIAACgh4FgW/L4SyxhYW4x5Uhor7s9eusnly5BkQAAgAUjwobk8ZdY47rp+bBEhlemuH4U89iF/CUoEgAACMHQsBX5/SWWWJH9IoK/ZNH5JSgSAACQYYzYhGz+EmtdFiJRP0p0quwcXYIiAQAADYwU65PteRz3Jo7gEQntdeNZ1F+SuzABAKAp+BG7PrzvFQAAIAjSZGX4Pg4AAIAE0mRN8JcAAABEQJesxuHm441gw0De/ztIAfmodQxdAgAA64DLZDUO796+E2wYyIctXdfJh6xpqblFlwAAwDSQJuuQML9k2O4+WbPVMjW36BIAAJgM0mQFIiVrDeTv3r67/+Pu4R8P93/cb76c0CzQJQAAMAd0ydIkP4/T+yru/3F//8f9tkv8JQAAsDK4TJYm+Xkc/CUAALBnkCaLgr8EAAAgDaTJcmT2lwz1JGzBXwIAALWDLlmInP4Sc3u/7m7BXwIAAA2Ay2QhlppfcjgchqW5BX8JAAC0AdJkCZaaX4K/BAAAmgdpkp1F/CXMLwEAgJ2ALslLfn9JyEeCvwQAANoDl0le8j+P484yYX4JAAA0DNIkI0s9j4O/BAAA9gPSJBc5/SWHMcwvAQCA/YA0yQLvewUAAMgAuiQLfB8HAAAgD0iT+eAvAQAAyAbSZCaHm483gg0Def8v/hIAAAAZpMkcDu/evhNsGMiHLfhLAAAAZNAlk0mYX2JuPxwOJSxTc4suAQCAFcBlMplIeTU2kDeWHQAAKBakyTS0uqQxW6dwAQBgzyBNJoAuAQAAWAp0SSroEgAAgKXAZZIKxQQAALAgSJMkzmW0uQ8DwzAMw5o0U5psnhiNoUswDMMwrGVDl6BLMAzDMKwUQ5dodcn9H3f3zqdwMAzDMAzbm5WgBDz+kg1VEgAAAGxFCUoAfwmGYRiGYXf3ZSgBdAmGYRiGYXf3ZSgBdAmGYRiGYXf3ZSiBw83Hm96G1AxbMAzDMAzbj5WgBA7v3r7rbUjNsAXDMAzDsP1YCUog7Xmcd2/fLT8Vtz4qLZZKkw1QLFVfU1Unfg67zXiPlf1Snsd5cO4q9Vus5c3HmyEDoTA7XJrFUkJ6lEtqkyXLvMuqr6lK+7Gd11reeu8pQpcMSRxSQ8PdQ7OmNlmyzLus+pqqtB/bea3lrfeeInTJkET8Jbtq1tQmS5Z5l1VfU5X2Yzuvtbz13lOELhmSmMtfcjgcUovmcDgsVOibN+u+NMxlCWnW1+a0OtWHL6pMWLKcs9xkaM91BW07PGfvB/RjyraCbPLYt0S99xShS4Yk5vKXhApaqICqByehWVv5Kkp+JXVDy6W8qDJhyXLOUrimyr+CNhyel+j/9XFuKMjm1938GArVJUMSl/aXCA2l6sFJ3xkVJb8W9Zfol0WVCUuWc5b6nygZlw34S5bo/6vwl8yvu/kxFKpLhiTO9JccDKwtQ0Ox1t2QZmMKbXHPKDdN+SjzLKnxR5u1GbN5qZSQcllOuedya9C6MEJ7o7nYsO5Yssy4jF5T1vXivdaUrdc8UL7WrDSErrioqLLO5d3rhvQuvSkXQobSL2w5+PqlCbXmpsG71w0p11o0be4ZrbL1ps1bGnK7LVSXDEmc4y9xm6m3WXubnbeyhTBubELVei8kbzwT4lc2ayvOQlKeVJtueqyzT8ip0CpWqzuWLDMuNddUtK0q+4foUaEr1FoflhpRJcTmXq3es8jHCjlNGiOEVKXWmr6+oueSay1USpqednLeH4rVJUMS5/hLvI3mYOCGGQhdilYYIQb9BSCkyq3+aPypnZE+5hVSnlSbmkYvH2Vd6t5WsX7dsWSZcan/ieK9Rub0D96jDr5+NbRM/aES2uI9uz42odxMhr3mFm9+oz3Aoj2hPjZvKYWW3rN7yyfabgvVJUMS8/pLNA1XU9mh9ehlNvNy0sSf2hnpY14h5cvVppASfZe0Tt2xZJlxmd1fElpOuI6qHp69YSaMGpNrTVNf0bEpqa7NHLlL4exCKUXrvacIXTIkMa+/RNNwlRenrBMnXwDy5ZS3WXsb1rYpn1mb/XnlNCTlYpO6Y8ky41J/TXmHk0X7B7dHteKcNjwPeVl0eI4epRcNc2rNSo/cC6XWmia8exZN+ejHr54idMmQxJnP4xwMhC1mpZpVa4V0w5hNwYo/VOjeS9E6l3A5RePXN2vvxbxtyqN3Va2S96bHPSqaklAuNqk7liwzLqM9pLdtC9eIcC7rWhCuNfdc3jin3aYftnivwVD63ZQLIYX0u6UX2jKt1oReaNgi9EJCrUVDCmcXtnjLR263heqSIYm873WJzqjY5fx3LcgXFUuWe1tOeMOT8lpbYVlpP7ZarbW6LFSXDEms+vs4B4damvVWKZ/zroW86dyw7liyzLiM9pDu71fltbbC1bHE8OwmvoScptbahGVSXpJKadF67ylClwxJxF9STrNeuTmWkB6WLGtfVn1NVdqP7bzW8tZ7TxG65ObjTW9DaoYtrg0ZEMLs0CotlkqTjWHFWtXXVNWJJ+Pzs99ThC559/Zdb0Nqhi1e67pODrBPq7RYKk02hhVrVV9TVSeejM/J/kARumRw6UTnlwzLgzMbmeVqd0NZsmTJkiXLjEtTExShS5JS8+7tu/s/7h7+8XD/xz3L0XJctbVwX2eyAYql6muq0n5sPlXX2kzuC9Qlg2JSPo/z0D/b9o/7+z/uWQ7Lw+EQL+zy2G03BLAQVV9Tux2eq661mZToLxlkh/J5HPwl+EsAIETV11Sl/dh8qq61meAvaXaJvwQAusqvqd0Oz1XX2kzwl6QtD4fDsNzeI1KMvySjBhK6IetVP3Ia5MBL457dXGoOF/41tyyUNSFab5F6i1pO23JVoy+9UDLm51ETYShys3KzFNG0a8qbHuEs2ZPdI/dj3hpZqF2tTFSQRdtYqDmVXz6N+0tC2ycvD4fDsNzcIzLZX5K9UWaMUOiGlN2i5t+lUQ5XysPdoxbNjjAOeYfkUGqVLXDp1ijkIpqdCXn0Dg9CYqKJFI5Sor+m5PxqLsDsNSuLqqXPviFyrUXbmLylcBr3l/QCAn+JXcQF6xJlNxTd25gucX8GzUme8uxKPTRTl2RHX3qa7ITiFAJ3vlFBH15/lBL9NZWkwzQCbj5Kv+/K2n0FkvwlmvZTUYG07y85nHwbg8YcPB/DXu92M87RxkCY0pbyqGD2I6F/vdvdLl6OzQysqf5UOaUcAIQchbIzoZSEpB7GXUPo7KG8hP6VU6g/l/dYN2vRKrCS5AaWdwkp8cYvZFnOrD473o3RPApVGQrvZid6lJJc/hIhVZpKn4ZyfonmGqyLqCCTW4i7121jxbIXf8nB8HAcxj4PK4wQUtiyvXdkkr/E23a9YYSQSVuiKO+Fy/myAocypU98aJfQj3tPHT1XNIXe8JoIZx7rZs06yv1XrnE5Hn0uhC3uXm9It0XNz6OcGE34CddOiAnzSzT5FdbdIp2MZnh2z5Xr7BuS6i/xVqLbBbnrBdK+v8T1ghzGc0TMMPfjuSP6LZt7R1L9JcOK1aDdRqwfBrx9nBtYZubtJ3nAEC7R6BZNKQlJNQ8UCkpIrbv0JjWa09DGUOQhonlXVrqmNXrTJgR2k+EtPW/4LHmUS1gmlPfJZPSXdOryFLYnMcFfkuW8mzPZX6JpP4UX0R79JdaWA/4ScVd0hPBu0ezyMnl+iTfZmr2aITC6S+jH3QOV/bhwlpm6JDV3cmpDiZmgS0K7NJFPKD3hcPnYunRJxvklVvJW0CWp80sKH3H1TJ5f0oAu2ZG/JOTzOOzbX2JtzKVLJveq86frRkWSN3lb6RJ5nIuebn7iJ4/9oVNoRohUhSQcFQosZEc4Y648pl4LqeNKEnn9JXLaMia7Z/LzOLWT3V+SvWqWo3F/ieUX6Yn6S6yQ1m2gUJjilrHn/ocVbz/rjl5WSO9GN0yXeA2k3gt3Ixd6KG/iQ9nR7AolI5qq0NmVefEmIFQs0XPJx7qn9laxXJ6p8XjPnhS4U5SeMhkT8qiJ0E2Vsl6EFS8T/CVdIL/eYNGMzCHp/SWh6qiR7O8v8W4pk8b9JROWh1L9Hxn9JVNqZa2mXMJbDsu/bktmD6VXVx5LuKYmw/ted0j7/pLU5aHY+SJZ/SXJtbJWR7xVN9TMzywonIPD0mesemjf7fBcda3NBH9Js8tKx9fddkMAC1H1NbXb4bnqWptJif6Sm483vQ2pwTAMwzBsz7alLnn39l1vm5cChmEYhmEl2Ja6xJ1fgmEYhmHYnm1LXZIUup9fslBSqqbS+7LUJkBeqr6mKu3H5lN1rc2kwLwfQk/fCM/jbJ3mEimwajVQmwB5qfqaqrQfm0/VtTaTAvN+UIoS83mcrdNcIgVWrQZqEyAvVV9TlfZj86m61mZSYN7xl+ShwKrVQG0C5KXqa6rSfmw+VdfaTArMe9H+kkM9X2FYumoXKgT5Wx7Kd2NHAy+Ne/akluPmJRRgoawJ0XqL1FvUctqWqxp96YWSMT+PmghDkZuVm6WIUr85FbpwNrmg5r+OvVKSvo/T5fgGSDkUKEZz+kuy10rS6LIt8z+AJ7NQIUyuTfmCXLnKlMOV8nB5ZM2OOS4K5w0FEw6X48mFvvSi2ZmQR1m76BtGxiJKuqaUOV3tgtL8UDG3eNdrRPOlMHOLtV61PmvcX7JnXbK0XFuoECbXZtu6xOp3StAloY2puiQ7+tLTZCcUpxDY2r65Lkm6pibU5qKk+kui22th5veE3fWKaN9fYl5XoX+9292+zApfuBqN/s4w1ycUSygGb2A9qXJKeUEKOQole0IpCUkdAstnD+Ul9K+cQv25vMe6WYtWgZUkN7C8S0iJN34hy3Jm9dnxbozmUajKUHg3O9GjlCzhL1mN1NsZ0e21kCTIUttb4ezFX+JWlbdnl0MKWwpE0xnNL5bshaOcXxIK4A0cypScbGF8kiP0JlVZaNEUesNrIpx5rJs16yj3X7n25Xj0uRC2uHu9Id0WNT+PcmI04WdeRyZ5/SXyNZidaf6S1ZK3HPhLimKR+SXuKBUaCeb0gEWhlGsziyV74cy8/RQdU929yoxoSklIqlVoVoTCIe6xoV3KnIY2hiIPEc27svY1rdGbNiGwm4xQo3XDZ8mjXMIyWa4jk1bnl4RSslraFgV/SVEs7i8J7dIPtFVUfKq/JLRLLoTshTNztpA8YAgDs3J4Du2K9trRcVGIJLqSqktScyenNpSYCboktEsT+YTSEw6Xj61Llywxv2S1fm/C8zhLJmc98JcUxVL+Emtj87pkndtb2Qtn/nRdYewvUJfI41z0dPMTP3nsD51Co0tSFZJwVCiwkB3hjLnymDpOLNrJ62BDegAAAaVJREFUZPeXmCWwNJOH59rBX1IUmd9fYl5X3g7F7aatkO5Gb5jSkKt2frGEYvAG1pP6/pJQx+o9tTeRoWRrdoWSEU1V6OzKvERrQZPTUABrl3tqN6neGvfWlzIe79mTAneK0lMmY0IeNRG6qVLWi7DiZcI1FS0W+YwZSR2eQ4mvDt5fUhQbv++10op0yVu104plwlElKOVm2sAm7KH06spjCdfUZAocotah6lqbSYF53/h9r3X1OAJbybWZv1e26oaa+ZkFhXNwWPqMVQ/tBQ5R61B1rc2kwLzzfZw8FFi1GqhNgLxUfU1V2o/Np+pam0mBeT/cfLzRG98TDlFg1WqgNgHyUvU1VWk/Np+qa20mBeb98O7tuyTbbcOVKbBqNVCbAHmp+pqqtB+bT9W1NpMC854wv4QlS5YsWbJk2dJyaxHigVmHAAAAUAroEgAAACgFdAkAAACUAroEAAAASgFdAgAAAKWALgEAAIBSQJcAAABAKaBLAAAAoBTQJQAAAFAK6BIAAAAoBXQJAAAAlAK6BAAAAEoBXQIAAAClgC4BAACAUvj/3QzgV6H3CtYAAAAASUVORK5CYII=" alt="" />

图1-3

Sq2014 code 执行Sql2008R2 SP2中脚本

注:测试前请重启下sql server实例,使得tempdb计数尽量准确

测试结果如图 1-4

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAukAAAF+CAIAAACwLRM6AAAgAElEQVR4nO2dv2slO5r36894gxt28IbTMMFO2A4dmYU3WXijpv8BB04ma8xGw0aXxbQ7GujNZoOFu4lxNHCTC75BgycYfCbYYIKhaYwDY15DvUGdU0clPXqk+q2SPh8e5LKOSlKpVNL3PKWqU9V1XT//VH9/f7Tnn+q6ruv6y3988Vndn6qStwEAAADiqeraq12mL6zaGwAAAMAwemiXYe4WAAAAgAlBuwAAAMCWQLsAAADAlkC7AAAAwJZAuwAAAMCWQLv0o6qqqqrMDQAAAFiSPLXLrKqizdxXysjSkUQAAAAKaJfhmaNdAAAAlmcC7WK9ca7ddt9EJ76bro1Upuyqi3Y8/pRWpJgyZncxcd/SxRziDxMAAKBYxmoX8U3/7kYwpbUtFVSJ28HEyu6tYnAjxZQxkX1Lj9kdAAAAWibQLqLjRPeviNolUNHR2kV0k9RLaRfRoSL6V9AuAAAAClP6Xax4V7vE7y6lnMzvYkUu7HcJ1hbtAgAAoMA9I+4ZAQAAbIm51upWxnJdX0olUiql3yJWN6V7w8jSLuaGsnswZUzpfXcHAACAhgm0yzIsNpcjGgAAAFJmG9olxhEyieaYMCsAAACYg21oFwAAAIAGtAsAAABsCbQLAAAAbAm0CwAAAGwJtAsAAABsieW0S+R7XCZBeW/KArv3SgkAAAC9WNrvMmZOj9zXev9b/1L67X758dLNAe0CAAAwE7lpF99rc6OL6L27q136FgoAAADxTPmbAMHX/9eS/tB/KMD8bYGYu06m4LBCyx1y+fHSsl67m/n4qgEAAACTM+9vMdaOWFH+jf8FRwWf+DA/nWR3V/qYIgbtAgAAMBOT+V3cGJ9DJZjSN+8npV1a8LsAAAAsyWTrXSIdJLqU0XfvpV3E1Srx94yCu5v5+KoBAAAAk5PbPaNaFRwxkqLv7mgXAACAJZlAu+iLbcWUwVW9ylLfSO+Ltbq26rLM7uGKAgAAQE+WfkYaAAAAYAxoFwAAANgSaBcAAADYEmgXAAAA2BJoFwAAANgSaBcAAADYEmgXAAAA2BIraJfId7QAAAAAuKzjd0G7AAAAwDDQLgAAALAlJvsdafPXiJpt/felAQBmpYIcWbtbQRLM9VuM7g8rDvhVRQCAvqw9t8JCrN3RYE2m/C1GXaagXQBgVtaeTGEF1u50sA5T+l3ESLQLAMwNs1o5cK6hnu+eUWQkAMBImMYKBPlSOHOt1fWtfWG5LgBMCBNYyXD2i4X36gLAVmHegppuUCRoFwDYJMxY0EJnKA20CwBsEuYqMKE/FEU/7dLaonUEAOjC92ywoEsUBX4XANgezFLgQq8oB7QLAGwMpijwQd8ohGy1S1I9OKnKTM7lx8u1qwAB2nMknqzNncG8LygYA32jEJbTLgu/1mWOvjsyz/DulWHip77ElRTjRo7cXaqYNe3F33LOYYjxnanJSxmHdY4ykC85dB6YB/pGISztdxnTo3rtO6bvztTvo7KtnA33I/PfqvtR5SQYkKeyl6pdzAPUD9aXcuURZ0DhwV3i85zt0DPTLkxOoEMPKQG0y8T7js3WJxQqJ8ZNIyZQ8hywexfX6eJNKiVrxxczJiaHuchRu8Qrla3IF2Ym0KGHlMAE2kV8zb/vDpEY46a08hzwYwJux7U6tDlxuttW11di3IvEd+WYMZcfLy07JDJ3cLbjtYuez7DdQzeM6jjxYeoVsdljRZ54b8va9qWsu9vKfTExXo900/jy1FPq5ep5HkC7QGnQQ0pgrHbp+7OLyr/B3cf4XSzZ4dsQ/9XzVDwHkdl2y1C3Y7SLOOEp6WN27zMvBkcNUbuYH4UJSqsBkXWoeWfNU0wpxldOqOaDdoHSoIeUwFjtUtcBr0lQu7gpfV1upHZRHCr6vkqeVqgUpGTbLcO/LamH1Pwux538BzuBdqnV1hAFmZtM3/bF6LvowtFKE0zpK6J2jtSXJ9oFyoMeUgITaJd9RpW8rSTzpZxJu/iSTa5dYqrU757RAPHhixy5e5eR2sVqOn0vT17Sv70aYULtEnO+fHnGxwf9Ll3QLlAa9JASGKtduGc01z2jkY4TMavgPNpTu9QRzxl1lJmUsvafCN/ukzWInlWv3UfmKaYU44PaxcmH54ygKOghJTCBdvHdG6o8q3d98fruZnzUgUneFLNDm/+K93esmdi6E2S5DXw561VyKm2YG1k7n/r+FXdxp0BfSjGZB0u7uMcuiw9P4jY+sLvvoGr1MH3xbmuLKYO7j8zTTek7R7Xzr5In2gUKgx5SAmO1S7Ik1X2TqszkBKe9kfNij93zbOAJyOm9unlfTTAeekgJZKtdIAV8Tpfpdw/5hyAbmJlAhx5SAmgXANgSzEygQw8pAbQLAGwJZibQoYeUANoFALYEMxPo0ENKAO0CAFuCmQl06CElgHYBgC3BzAQ69JASQLsAwJawZqaX8zfffoiz81srq5fzN49XOzPm9erMjInKvMn24fpRTnDxcsz+9umHs+eHuq53z6cROZ9evxoVO9b/4fpxn0/7r1lKXd9cfLNijkWbGNXYl3VMZhy7u2Obp1WKzMu50PjzgXYpAbQLAGyJnjPT7vn0zdPN8f+OOrFEgKNdbG4ugnOwq4cMbdHRLmat5LJ82sXMc38Iu1fjKERNJtX8UI1jWR3t8ni184iehkjtcvv0Q+hgJwXtUgJoFwDYElNql2ZS70oE+9Ne7hxJBIzULlYdHq+unzw1eboR3D8H/WEl7lbj5uLb6fWLWdD5raVdopqiLfHmItYZZjT+VKBdSgDtAgBbQpqZ3Lm5VQYB7VLXu+fTo19B8buEb3xY925aHePVLv47R6fXr12/i1i64E3p1qHRH86+joQa4nc5VD4gPnbPp44jambQLiWAdgGALeHRLubNC1OvBLVLB/NuS7yn4dvp9atnCcvj1W6Ke0a3T9J6nSjtcnrmX/sSWO+iaJeX88YDdPEcvMtmlu4uzZkBtEsJoF0AYEvMqV18kmLoio2H68fT69fx2qW9E+QXSY6Pp67FxTdiNW4uvp1eP3cWJl88+bXLQTM1zd5xXDkFdQ8T7QITgXYBgC0xp3YJPYwTeIxoj60YVO0ieHcaV4qhXfbuk/Nby9Hi8bu4612sRmibS7xntD8in9/FWCHUJvb6Zuw7SmgXmAi0CwBsiRm1S3eJSbv7QQE4dGZiYc3N3h0S0i726mBbu9w2t2a+nd/W9e759Hikketd2urtt49p7HtGr1dnj1e3jR9F1C4v56ZcM5r94frRcrE0y3X37pkeym88aJcSQLsAwJaYcq1uR6zsnk+tNSUxb2GZwO+ia5cmgfiQcx/tUh/v4HS0y9nzQ1vWzlQtjnZpWsN6XY21lsWUR3tfkVK9mUC7lADaBQC2RITfxcSjXfYP8Xam+W+nZ4+Gi6X1MXhdNZ6ZeNp7Ri/n+zo08drr8s5vo9a7uPU5PCPdJG7KsrRLewPIt4T5+DD2+e3L+Zunm7C0mgm0SwmgXQBgS4x8v8th7jfXZxgeBdN5cEB94ChCuxwJ+12O6O+m80VGahdrYa9vre75xaP2FHTg3XRoF5gPtAsAbImeM1N3Gam2LMObZoDfxSNuej5npC/L7bFW19mr9aA464Lbej6G38uCdoHVQLsAwJaImpnM97p63QbuAg5jd0s3BP0uZom2yHBfo+LVLmZZ8joYK3Gk36XzotvjG1yebg5LhSJ+7MkhRrtcB9YM8V5dGATaBQC2BDMT6NBDSgDtAgBbgpkJdOghJYB2AYAtwcwEOvSQEuihXbxZVEez/nUjfTtan7qRvpQAUBTMTKBDDykBTbt8+Y8vPjvu3xUckZGDdzdDACgQZibQoYeUQEC7iPv4tMskkXp/ozcCFA4zE+jQQ0pgrHapVf0helD0lGgXAFBgZgIdekgJTKBd6sNiFOtfN1IoXlrXolWX3ghQNsxMoEMPKYGwdvnn//PPptV+TaM7UfC7AMB4mJlAhx5SAtP4XfZ5RS/LVSLRLgCgwMwEOvSQEphyrW78c0YDIsV/AaA0mJlAhx5SAhNoF/1FLDEvfVHe79KpKy93ASgeZibQoYeUwNj3uwAALAkzE+jQQ0pggvfqAgAsxiQz08v5LL9g3JuH68fDrzpL7AI/wtzZ1/5t6pdz4deh7dJPr1+blMpPZM/Hw/WjdnQDa4J2KQF+zwgAtsQc2uX16uw4U1rz/c1F+9Hj1c7Kp9nRjT9w+6RPvRHaxZQjTuYB7eKv2F43+DM3MFqgsai9Yni4fgzrktsntAs4oF0AYEtMrl26c/ztkylfbi6Ovo2H60dDppi+Co9E2D2fvnk8PUtQu7xenX3Tyu1iNsK0HLSLKrPQLiCAdgGALTH3PaPXq1Zt7J5PO26Y16szZ6/bJ492eb06+3Z+a+RWR9wDevPtB7Nisdqle9Pn7PnK9pR8swTZvojd82mEKJlPu+zRm6V30WiXEkC7AMCWkGam5taMczujc7vn1hQiAe3SfOTeVRFmcY92OXgUXO3SydD1uxyFhZS+Qw+/i+jYaNSVL/dOlbwCwtPyvQg4n3qDdikBtAsAbAlnZuqoh5er/cTfrERpJ9S9ZyKsXQxfizunCrOsqF1unw5Fp6tdbi6+HdWV6gHqrncxipBbvjeHmkwF2qUEctYuqXVf8SXCvV5aM9URpdYyAPHYM5O85tSVFLsYv8vLubG01vU3CGUJ2sV8wGdh7dI8lfN8dfbt/Nrc19YuzQM+otNFVRIdRRi/2lfHWQtsmbbiWALtUgI5a5e6rpPqvso7guOrGTyiyENOqmUA4nFmpsOcbWoRYVoNaxd7BausXUJ+l+7cP369S8wz0u16l72z52HXxMjapVl0fOq5YRTyghhNJ7X8xOyeT9EuIIB2WYj2VcJWTP980C5QNPLM1L4pxLdUJaRdhEdvhqx38aqNx6vdoveMDg3S1M26f/R041/sEtIu9oJlq+UnRm8BGbRLCeSpXSoDPU0t3UCx9q26KCnVKh1DKzIGsQJj6tnriGJKV6pdL9XIUAJaf7i5ODgb3Fs5nYefLe3SuVV0xP7S3+s5o+Muw5+RNo4rLGh21k2ib+e3beReqRjvUxmsXeRX3h1bvgeed+KZr6Q7rhyKhxGjBDLULtb8qqc0505l93YCDqb0l3UMrfjgJaZUKaYm8buPjPRVfrFGhhKwZ6aH66dWOhh+kZfzzuO1ylpdj3CxM4xeWNNhtHZpHDlnzze7Vru8PjRP91g7GtrFyXavVAwNFK9dXs6PWXW8U56W73+MCpZvKQq0SwmUrl18KV2vQC1Nqz5XgVSWJlP0vePr6SbQjyg+T1+a4LEv2chQAm5nML6+d+a57uvjPM9Ii6+l97xy1xQu0uM5gkYZo10svWWzX+LqLATuvkPvmPj0+uXqrI3v43c5PgjtyJrwW1gkZ1U0gx5BYrgoAbSLth2cVqOrJG/rkQPq6auV74gi84wsZWTlRzYyFMLQmcl+0VwS+LWL5g06sj+og5A6e37wLW49+G9MD4r12j33LXZTEPhpAgdLFPZdqFujXcqgFO1y+fHy8uNlTEolUplWQyJJ2A4KmgH1FGvS9zAHR46sfHwji2cTCiEr7ZI/ca/unRS0SwlkqF1q6UaDO9tZ/dvddjNpQzelWpnj3SJxO+YScyvji7Rq6Esp7jgsZUy13YqNaWS0S8nEdDwJtEspDO0hsCXy1C6QPWiXYkG7gA7apQTQLjANohNlDnC6FA4zE+jQQ0oA7QIAW4KZCXToISWAdgGALcHMBDr0kBJAuwDAlmBmAh16SAmgXQBgSzAzgQ49pATQLpshpwsyp2OBhaHzgA49pASy1S4Jdl+3Ln1f8SJGuofp/ptaUzQkWCVIn2T7MyQCPaQE8tQuba9NqvtadYl/r+4hjfeFuTGHmVRTNCRYJUgfZibQoYeUQObaJR3ad+laMX1y0F72P2D31UmwSpA+zEygQw8pgdy0S9UlmNLccDMJ5hl/kbjaxf03lIP91n+3dKU+ovRZt5UYXGAAzEygQw8pgdy0S0Nkr7WmXndfK9IMfSn9ZR1DKz7yEouf+2O0S3zl52slBhcYgDQz3T4dfyH59sn4FeKD2T/IbPy48e3TD2+ebqavp/V7yLE/0fxw/Rj++eiW3fOpXXnrB6Jlbi6+6Ud9c/Ht9Pq1zVBo0n2Duz8THVWBOUG7lEDp2sW3i+tUqKVZ2edpkMrSZMrI9S4x8b4DDFZ+vlZicIEBRGiX7twvqAEjvTFJi3RmbmtKvrloP7Lm71qawoVJ3alb74nfzkH43WaP+BDseBRd7eIc3bEB0S6wCmgXbTveoxAqSN7WI5Xa6hXo63eJL3faVmJwgQFYM9PLuTH7nl6/xvhdjhPz7vnUM5GfXr/aE/Ptkylfbi5a30P9cP3oyJco7bIXFq3a8NXH9sTIcuT0+vXh+jHC0/NyLuTpyfnieax2EeTUrKBdSqAU7SL+gJ8+E7uRyqwccl0I20FBo9RWL7Svdhngd5mklax/+ZFFiCHkdwmyez7dT7evV2eSRvHyenV2mPLtX6Vus+rERGiXzr43F0KCkGfI5OX8WCujOPO+mLF9c3FUMOZ293DG+V2ahrp+RbvApGSoXcQ7FO686N7v8N3maD9qQzelWp/j3SJxe9h6F/Ew3Tr7IqMrP2MrVWgX6I/Undqp1HC62D4Yc5J+83i1qx+uH/0TsMhxRn+4frTWi5humDZxnHY5cPRPGCmPSsvhcNQP149GrVrNYR3Uy/mbpxvLr9MUZ+uwfUz0ehfLzWNpppiGnZaYkQ22TobaJVdyuiB9x4J2gSA+7fJ0fvZ4df3UzuJ77dJIlnZj93x69nj65vFq93J+FB/2BCyvYzXmeEP37HFiemsXw+lydJ903SHdQz5WshFVL1dnj+cXj4ZnyLsad+/L2cnukOM6nrPnh6F+F1feLUVOQyX4QLvAHtGJshg4XSASt382yuPxahf0uzTTqjvdxvhdOmtEHC+LO1Wbt28a/Nrl9qlzV6jxjmhPG5nCq8388Wp3lCzCCuXmI2PVzj6NpXJ2z6dvns4vDg3YiMKe2sVw/ywP2qUE0C4AsCWsmenlvJmPnfUu0sPGL+cXL9J0G9Qu3RW1Pu3SiYl/AMdeK/Nw/fjDxZOjTmyOB9gRH60PxizrIO+uhYXM59evD7dPrdpoXDI8Iw1pg3YBgC2hrHdxb/2IT9z01S62cKlj1rsIr43xTOq28NpXpl3FotCs3Tm1lgnvvU3H0oXVvke50+i5ttyX87PnB56RhtRBuwDAllDX6poxb3x3LkTt4nvTiedxYnsJre07kdapmJO69xEnY8eoFcTCW+bCt5wCq2HqibXLwmoG7VICaBcA2BJh7dLcTGlDR77E+12U96C473cxpID8fI05he9Xw1geEdt5YysMew1N816Z0zNDvuwfEXo+7zxwFPluumNlhmiXvZ5zlYq79GdW0C4lgHYBgC2ha5eXds5ul4NIq2ijtIv7nreuI8dcCGKtdQ2ta9lP88aSW5+zxHwhXsfZ07mTtffWGMtWAt6Xfn6XuGek3Qe8j2Ut+aQ02qUEstUuw7rvVD1+cCZcdQA61jWyf2HJ4ZWyx/m4u1b35dz74hMxZjCaj6EjhkxVob8HpRVDkkRTM3HfmGfmOcU9o+67ho2a6O8FnhVG0RLIU7tUxlvRBu+7IinUASBNyp2Z+rxgt2TK7SElkbl2WXjfqUihDgBpwswEOvSQEshNu1RdBqSs1FfaW+ndHHxF+8ryJY45zFq6yaXUUE8JsAnot6BDDymB3LRLQ2SvdSVL7agWPaWvROXfAbv7Kt+rnmaolw6QMsxMoEMPKQG0i73tm9Stub+NFMuK1yI+j8iwyot5+rSLzx8DkDJ0WtChh5QA2sXe7qVdfMVFahGxUCW9L41+IEG/C8CGYGYCHXpICZSiXcSf+ht5K2dkyvjdReLzDGqXdpsfRIT0YWYCHXpICWSoXcRbIT7t4t5ecf810wcLqrq48b4cWm0h7u6ruVvPSqI2tIvvYH2tBJAUwasDCoceUgIZapd4enXuQq4EtAskDjMT6NBDSqBc7RLfv9e9EkQnyhzgdIFNwMwEOvSQEihXuwDAFmFmAh16SAmgXQBgSzAzgQ49pATQLgCwJZiZQIceUgJoFwDYEpPMTNLvMI/j4frx8CPPMsdfUtztf/vatX2C4+9FS7/J/ObbD96fgH69OvumV6MA0C4lgHYBgC0xi3a5uWhlwePVrpPU+Ojb+a03xx7aJYilXaxsd8+ne+3ycu7RQF5V1LPO2wTtUgLZapc0u2+CVQLYFtNrl5uLo6/i4frRkC9dN8btkyJfFB3wcP1oyojzW9n1cnr9asuRi5eefpd+oF1gs+SpXSrj9WuRKReDKwpgDFNrl93zaUeRvF6dtbLm5bzzkXan6eH68YeLF99Hp9evjd/l5qLVLh390fHKxPpdjKK9HhdN5aBdYLNkrl0mTDkVXFEAY5BmpqNzwhYExztBt6ZGOaqQh+tHYa/9jP56dfbtqEiOKuf16izyZs3j1c6nXfy3dXqud/HKJkflWKBdYLPkpl2qLn1Tmv9WHsRMelVM311PyQUJheNcCLdPxl2el6u9AmjkRTtz7+/FyNqlO393YhqRcfZ8c/3oWzXSYN54shC0i87t0w9nz1cX33yOHDd//C4GDJUlkJt2aYjvtW5KSzH0jQyWMiDP+IIAsseemVzHSV1bgqaua+ve0FG7uJrDytBw3ig6oJFK9jrfNsOudvG5bZrd9582iRWnTlgDhUC7wGZBuwgpW7+LmMx10gSvk167i56YyMMByB7nkjncfzGdIoKg6aVdzHtGnWW8HsVw+/TDm6er60ff4zyOdtmrnIfjLi/nbx6vdi/nb76dXzhrXGrPDSD/49Yd8y/EiXTtbAq0SwmgXUZplwGlRO6OrwVARJ6Z2vsmvlUsPu2irXe5ffIvhTFpl/c2+sP+uKffxbNW16tdAs8cZSpQFNAuJVCKdvH90KCvfyuej0TuGfHTiVAm2sx0c3G4s+PeM+o84Ww9Z2SmPD5npC7j7UYexIF4F6bVLgeBovhdDlU1nD3yG+1sQSO96+XipUa7QJ5kqF3EGzHKTC/2cle7iNdD/EUi3iHy3TCKKQjtAmViXwsP10+t8jC0xcv5G1NneNfq1sL7XQ56pZEL3eeMuneFhPfYyutvOk9Bx2sXo9oBv4vt8mkli6JdjlIvK9AuJZChdhlPUMokAtoFCsSdmQyXQ0dGmK4I7zPSdV13n3kW7jSJy2Mf/E8e7W9gdRVDV7tE3TPae3QazXTxFNIuvf0uaBfYLGiXDtM6V+a7eHC6QLEMvbjsd9CNwXLqiOwFSlui6Hfp5rlfq9vIDuv2k/vMkdcZ02C8GGaio94KaJcSQLsAwJZIQbtAyqBdSgDtAgBbAu0COmiXEkC7AMCWQLuADtqlBNAuALAlmJlAhx5SAmgXANgSzEygQw8pgbK0S4J9eskqpXbsAANI8CqGpKCHlEBB2qUy3gi3bk1alq9SOscOMAxmJtChh5RAidolHZavUoKNANALZibQoYeUQG7axey1lYfg7nX39oq4HZ+nW7G+u4u1cvOMiRR35yKHrUCnhSD0kBLITbvUEb//HNy9cm7liPm0eiKY+cgq1Y5q0as0OBIgTSqJtSsFiUIPKQG0S9TuKWgXN8Y3jluRSulc3pAyomRhZgIdekgJZKhdao+eyE+76CkjXSxc4ZAaul5hZgIdekgJFK1dxF803KJ2ialnTCQ/8QgrEu9lYXICH74+A5mRp3apJeHidmh3qrbSuNvit0Arpa8+Vpr4a6zXCC6O+GK1YxoEYAHEi0u5NCIvHCgQ+kYhZKtdYBhoF1iMvpLF3XGZesKGoG8UAtplSvoOwdPuPhKcLrAMgyWLmMOsVYVtQa8oB7QLACzBeMki5jZ5PWG70CvKAe0CADMyrWQRc56knrB16A9FgXYBgOmZT7KIRUyVJ2wUOkNpoF0AYDIWkCy+4ubIHzYB3aBA0C4AMAELqxax3FkLgjShA5RJWdolwS4+R5WSOkDIm7Uki1KHxcqFdeG8l0xB2qXt3On08sWqlM4hQx6kIFmC9VmlJjA3nGuoy9Qu6bBYlRI8dtgiqUkWC6V6kCtrdzpYh9y0i9mhB/R1a18r0k0Qf/1YKYdVSayhmK1brluQHhlzUFAIvkspwU6iVBUyY+2+BmuSm3apR//woXlVuBtupBnOVyWxIN8F7EbqMfphQrFsetqYcpKElFi7Z0ESoF2idlciq1W1S7A4JUYcDhgdgGkDABInQ+1Se/QE2kWPif8UsgTJAgBboWjtIv76YILaxVfKVNpFP0zIHlQLAGyLPLVLLU3z7nDsahcrjbvtjuxtGJQvVppeM4SrXcTdlYnHFzO4SrB1xC7N2QeA9MlWuwCACJIFALYO2mVKRk4GzCUwH0iWnODcQeGgXQByBsmSJZxHKBy0C0CGIFnyhnMKhYN2AcgHJEs5cH6hZNAuAJsHyVIsnGsoE7QLFI37gp9toaiWrR8aRIJ8gQIZpV2qyjY30k3v7m5tL09T+OB9p63MTHm6RfQ6ajG9+++YllyednZv3vTT/NtuByPNfMT3HMZXo2/pkY6WXlVyrz7fhdwnT+bUJUC+QGmM9btYWiQm0pUvtSNrlmdDM27L+DpH5tAmi0k/eUv2Eli9cjandlN8uBu+SDGrAUSW3vfe0BjtIl7FvWhrxYS6AMgXKIoptYsY2UoTMQHaZQzLa5fJE0+bYa+iRd+J9VEi2iUoWZTSIyvmXqfjr0cm0YWJkbMAeTCZdhFvBomf1kO1i3kzyvzX2nZTDsiz176R8b40yoGYid0N8ajdbb2qkccYmaGYZ/y9pPjToZxxX0or3tUuVlgvq13c0uO9LHNoF/dfz47HKvXyCcEc0PJQCBNoF/eOePA7nKVpxGv5CYQAABpeSURBVHHTqWjlbsdH9s3TDHXcmXJM6b4dI5VH3wYZ6XeJ0S7jGyTyMHulrBPWLrpk6Vv6GO1SR36pMFL4tmExkC9QAnP5XZRP3fgY7VKr87fPURHM0N1OVrsEiw7mKfoklBoGk0VqF5/nQ9w33jkkeoMi86zT0y6RkmU+7aLIlMD3CrRLYiBfIHsm0y5i5LTa5VBjYfaNnNqVBMtrF6WUybWL6IOJqaGerK/fJZKYHPq62dyPRO1Se5ae1LNpF0WyTFJ6TMUUF6kS2U1QtaEVCWuBfIGMmVe7mNuKh2bwPaPgv+22+AhrIdqFe0a+T33iIF67BCMV6aA7WsaXXvdxurjbQUFjHUsbWpGwIsgXyJVR2kX0M1uRvm3z3zZUri/lvoNyk6KN9M0i1h2Ndq821L/Ki2VF3h8JVt4UH8qx983BPLSYqurHqJfSq0HGH6abUj9GS2T4pID1Ucz7V8zE9rH0lCyDS6+jnS7mlehuxzpEHeHCrJkCnAjIkrF+l9WJlAgAIiPXqcTnH5Qs8xUNhYN8gfzYsHbp5d6YpKBhJY7cfTEWq+dWGmQkl31egAswK/Q9yIwNaxeAZEGyQGrQDyEn0C4Ak4FkgZShT0I2VPdf7zAMG2OKZFm9bhhmGv0Ty8PWlN5963ry7uT7P/6OYYmYIllWrxuGKUZfxbZu62uXyMSXHy/RLlgihmrBtm50WmzTloR2iXG6oF2w1Q3JguVkdGBsu4Z2wbCAIVmwXI3OjG3Umk773nmy6Kf3Vfejv/7hrZBsRu3yp//8E9oFW9GQLFgJRsfGtmhVXde7f3tbfejKkv9+38T89KF6+2+7ZuP9f0+qXFTt8qf//NPlx0u0C7a8IVmw0ox+jm3Oqrqu67/+4e1v/7BTtIubYE7t0ggXtAu2pCFZsJKNPo9ty5r1Lj+9t+8H7f7w2+M9o5FOl9//64//63//rrXf/+uPinZphQvaBVvAkCwY1hj9H9uQ+bSLwd7p4qyAGSRfWuHi0y5f/vgF7YLNbYpkYdTGSjYuBGwT5rlndGT3h9++/cNfO3eRhvlgfv+vP5rCxaddTPmCdsEmNyQLhunGRYGlb561ui0HyTJeu7goa3Ub+YJ2waYyJAuGxRsXCJa46beBDk6Xuj4+NT3dol39Gekvf/yCdsFGGpIFw4YZFwuWsvFuOixDQ7Jg2HjjwsGSNbQLlo8hWTBsWuM6wtK09bVL+1RR0NAumGhIFgybz7imsAStivF5zGcn70562erthaVjSBYMW8a4vrDUbGXtgmEDTFEtq9cNw7I0LjQsKaMLYpsxJAuGrWtcdFgiRv/DUjckC4alY1yAWApG58MSNSQLhqVpXIzY6rbmc0Z13NPRWFGGZMGw9I0LE1vX1n/OaPUmwFIwJAuGbcu4TrEVbeUOd/nxcl3HTySrn6dcDcmCYds1rllsLVtfu2zC9bKJSm7IkCwYlodx/WKrWPX2w51pCxcvapef//zzz3/++af/+sk066cZl68n3pdJDNWCYZkZFzK2vFXvP9Wt6drF6pST9FFRu3z+dGfdsvn+j+/vP31esZm24h9K1pAsGJa3cVFjS1rX7/IbNWlIuwyYn3Tt8vz0fPe9vvtef/nl+f0HtMv2DMmCYeUYFzi2mB2ekf5/9edPd29/896b7tAXlXnI7K++bcsU7XL/l/u7X+/ufrn78svz5093I7WLUoeYywzt0re1kSwYVqBxsWPLWNUIl+en58+f7n73T7+TE4XUSRszld/l8693P/3XT58/3X3545fGemkXt8LiRnxt0S6RzY5kwbDCjQsfW8Cqz5/umpWwunZxO6KoXYLblkWud/nyy/PeAfPr3edf73Z/24UPrCtWzFCvFdqlryFZMAwzjUEAm9uq56fnZlnJlz9+8WmXfVKPx8JM0HcO82mXv//P37//4/v3f3y/+7X+8svzl1+eWx3T3NuKkS9i5YfVFu0iNimSBcMw0RgTsFmtOq6HVbVL384Xmd6nXXZ/2zVPSjcPS3/+9a6u6/rT5/rT+8+f7u5+0eRLUE7pNUS76IZkwTAsxhgfsPmsateUfP70OXjPqDrceRGlgI6Yc+Q9o712qeu6rnd/27398P7tb95HrixWPoqvKtqlb4thGIYxUGAzWXX3vW7uy/z47z8qaqCzT2jFrhUqpmiXxiH0/R/f774ftMun9/WH93Vdv//09vOnu7cfwrVVJlpf3dAuMW3ISIRhWKQxaGCTW9UuKAlql7bnKdrFVQZ6Z9W1SyNc7r7Xpifm+el597fd51+1J7p91bvH7xLfM5AsGIZNZAwg2LRWff509+O//9iYTw1YHc7nxvBpGqW/KtqlFS53vx60y4f39Ye3f/+fv7//9DaoXVqZFTP1Bi+ncrQLkgXDsDmMwQSb0Kq3v3n/u3/6XWtR+wx90ti1sHb5tX7/69svf/zS/jjA/V/uf/7zz/Fv0tM/clOW6XdBsmAYNrcxsGBTWYq/I908SdS8oa6xvXb58Lb+8Pbul7u3H94q2kWXVj7tokT66pmBIVkwDFvSGGSwSSxR7fL2w/t/+b//8vbD+8Ya7bJ/N92nu+bZqAHrXdoLpnJuaZmXU/baBcmCYdhaxpiDjbcUtYtrjVJxLbV6Jm5IFgzDUjDGH2ykbUO7rG5bqafPUC0YhiVlDETYGEtCu9QwD4pkWbtqAFA6DEowGNRuhoaXBcOwrRgDFDbAqsuPlzH27Yc3mG6RLTmfKZJl9bphGIb5jMEK62vVybuTGFtdGaRvkS05uSmSZa0qYRiG9TIGLqyXxd5iXF0ZpG+z3ttzUSTLwjUBABgPgxjEU+2+3t1/vQuG7QwtfnppLLmNyW3h8HLOFcELaxckCwDkCmMaRFJFTv/tDB0UBymIFUVaTc4y2gXJAgAlwPgGMeB3Gcvc2gXVAgBFwUAHQfC7jGUm7YJkAYBiYdADHfwuY5lWuyBZAAAaGADBR6J+l6qKFVV5+F2QLAAALgyGIJKE36WqYiVUZn4XJAsAgA4DI7gk4XeZ1suSvt8FyQIAEA+DJFjM7ndpepu13Wy0wsVMY3163/21C1/Om/C7IFkAAIbBmAkm8/pdTIFixlTdm0SuBLGkjBWKOSfrd0GyAACMh/ETWub1u5j9TFndoseYcsf11rj7puN3QbUAAEwIAyk0LOR3EYXIJH6XBNe7IFkAAGaCQRXqxda7tJKlcta7uGtc2l0Uv4uVcwp+FyQLAMAyMMAWThLPGc0dzq1dkCwAAAvDYFsySbzfZe5wVu2CZAEAWAUG3mLB7zKW1u8yU/4AAOAD+VIm+F3GMvfvSAMAgALypUCqy4+XMdbO0L4ErTiIzHBhQ7sAAOQKN+5Lozp5dxJj7QytpKnrOjK3VWymFkS7AACsDvKlKKZZ79KGlfMulnTCmVoQ7QIAkALIl3KIPbvBGfrk3cn917vdX3b3X+8TDOfrx2gXAIB0QL6UwJTPGTUejvu/3N9/vU8txO8CAFAIyJfsmfI5I/wuAACQAsiXvMHvMha0CwBAgiBfMga/y1jQLgAAaYJ8yZXZ/S7Wwm/8LgAAsBg8fJQls/tdqqrC7wIAAGuBfMmPJfwurHcBAIAVQb5kxhJ+lxb8LgAAsArIl5xY9Dkj1rsAAMCKIF/yYNHnjFZc+4LfBQAAauRLFiy63gW/CwAArA7yZess4XdhvQsAACQF8mXT8F7dsaBdAAC2CKt3twvv1R0L2gUAYKMgXzYKfpexoF0AALYL8mWL4HcZC9oFAGDTIF82B36XsaBdAAAyAPmyIarLj5cx1s7QvgT4XWbKHwAAlgH5shWqk3cnMdbO0Eoa/C4AALBpkC+bYJr1LmZYVVWa4UwtiHYBAMgJ5Ev6xJ4YZmgftAwAQGawejdx0C5joWUAAPID+ZIyvbUL5rNZzxMAACwM8iVZ0C5oFwAAkEG+pAnaBe0CAAAayJfU4DQAAAAEQL4kRXX/9Q7DMAzDMN1M+bJ6ZQo39CMAAEAUeF8SAfGIYRiGYbGG9yUFo+kxDMMwrIdZDx+tXp8CjUbHMAzDsH6GfFm5/SN/RxrDMAzDsNYs+bJ6fYqy2N+RxjAMwzDMMlO+rF6ZcmyyldIn706myio/MmuczA4HYEIyuzoyO5zB6O1Q+MNHq3SSavf17v7r3eovpcUwDMOwjZopX1avzFq2qHa5/3q3Q7tgGIZh2AhDviyqXfC7YBiGYdh4K1y+LKpdLL9LI2X6hpcfL9s7XsNyyDg0GyeF+owMOdeEhL4ws6sjs7FrmXZwn51evf5z9/l1tEtTfFs2XXyOU8twRkhYQpjZ1ZHZ2LVYO5jaJYX6z93ns/W7jDyFW1ev+nBmdXHzSNNU7pGX8Zia9+0t5QwThImHa032M/X/taTYfFf0sHFpQDtMMnpP0g5zzyCZ+1305gs27qanJWU4izmu1I49/jJeuOapiTzCAkPl6pi7f86R/ypSbO5xY0D+mbXDtDnn7HcJNlawKTc9LY0czlI79vjLeOGapybyCAsMR35RSa3/r+J3SVDkZdYO0+acrd/FdZ1ZTjDRLTYmjVKWr25KzjFpgqdWHM7cnMU8xRil84ntYO0Vk6bXuRZbSTy6Jv823q2JWIeYM6vXPOY8xqQhJOx7dcRcC2P6XvDqcK8ycS83FMcu5ZptyxVLFENfrXxH7ZYl5qPEuGch2MJptoMbui3j5iDWp2/pVp/P0O9inlRfjLUduZcSo+QjXvZ6zm4YmXNwONPr7ItRjldJY8W4YWTOI891ZFkD+kPMuVjgXBMWHsb7XYZdLwN6tXiVRfZqRYrpZYkjjBuKNdTHn51HlEzbqum3g28Mn2RO6TXW5el38Z0Sq4nFxjXTxOdjTWZumshO0+6ldBE9Z/PUxruRgzFm0fHDmVnnNt4MI3Mecxm7JYpnTbm0lB4SvNSXOdeEhYfxX1Tca0G8XgaMYOJe1lWmX+NtOPiLijjCuKFvpNJr5baGOHZZMcqouN12iBkD3XzEEVhsvcg+j9+lx15iPr40MZdBr87Xaxqbye+ihMF2c8PInCc518ELzNcfxl/qc59rwsLDvl9UxIlnqhHMDfv26gT9Db6WDOasHHuwxJTbITgGjplTYvpJnn6Xe0nTxag8K42bXkkj5uM7Me2nvhr6Op+ec8xwprSM2Sa+tqo8Hc5tE19uldT1lZyDl7HvWKx4cS+3nr4zJZ4jN59VzjVh4WHMCxHMfqVcQfF9z+zA4l7i1RGTs77OY9d/hIlpE7Ed9FYS492jtmKCZaXcDvfOSCWmt1rAive1XnzL7HL1uxDuinldlXt5+C7RFI6CkHCOsNdI6E4zq9ffCjMbu2iHmfp8nn6XdMLKYbFTO5+wcw9qlcs4pvQl23ytc01YeBg5EsZ/P163V084dg0bqZYf32iHAX0ev0ue4SaEHeeakHB8mNnVkdnYRTvM1Ofxu+QZMpwREhYSZnZ1ZDZ20Q4z9fl1tMvlx0uz7ObfAdae2sE5ZGyZNU5mh4NhE1pmV0dmh0M7zGHraJeTdycn707aspt/h1ld12N2z9sya5zMDgfDJrTMro7MDod2mNw2vN6FsLSw8ry9gJCQsAlTuE4JCRcI19EuzZ/xZZ+8O7n/ejdRrTJkl1fj3H+92/1ld//1npCQ0AmzutgzG7sGQzv42LDfpbkdyKlVyGw4q6rq/uv9/V/uCQkJrbCqqrUv0CnJbOwaDO3gY/PPGXFqFTITdvhdCAn9YVYXe2Zj12BoBx/4XXIms+EMvwshoS/E75IltIMP/C45k5mwG+N3qaoqgW/GWwqXbLH5yirpvGd1sWc2dg2GdvCB3yWuxlXVfK1pNzbBMsPZYm0i+l2qLsq3UnevJr7dy81HibFKd2tllW7uFXkUvfaKyaeJiSxryRYTy3KP3dxLPAqx5X2tN0loter4fOL7jJuD79pscCPbf63Qt+OS+Mau4OFkBu3gI2e/y7Rn0brUN4Ei7GZqnFkR/S7N4B78hm192lzkTXx1mJKtPGNixHLbPK2U1rZ4FL32MkuPKdE8CjfUj2vuFht2XEopSq9Q2nNAGNkD4/MZWkPvJGduWLOdElq7L4w4dvkq736aDbSDj5z9LmiX5YXdrFTqd1Dr00r1hZgTcHX43qz7TtwclG/2Ykoxz15lKUc9psTI7cVaTDmumLPcqyeMD/XjGpDPsBr6rsGR2mUtgj7jQuZssR3QLnXGfpfqgBtpJVBixKzENGniE3bzNY4vHyt+GMp6lyrie6qZpqmM5SMxt8UYcbsKfbP3bbtejbZWkXvF+CfE4/LlWTm+llVaTDyutvTgXsE0ZjtbR+c7F8peVmuIRzcsH+W8S2HUxV5Jk5yVZpKrdST6l1K3quvWdj70RRHltINLQX4X6+p1w8EbyRLvd5mvcSZsrsr/vbaK+57a5lAZngNrX7cUay9rW6yVmDKynm6tlL30uinH5abR95q7xax4N4fKuD2ke2uU+ih7icfo1rlXjHJm9b0i+3O83yWoXcQrdMUhDr9LQ+QYnn07uGTrd6ml6dlUpiVol17CbqrGMfNxMxmDz+9SRa8zqLrf5s1Q90m0KRvMNGLpZg6+bd0/FLlX1cdPo6TxteFiLWbFu8dldi3lKNw08Z4Y9xjdOveKUc6svldMP4n3u/iuxJiLdJIrdwDBhzCUw8kJxXfu+zfLdnAp0e9i/jtsehYzTJABfhfz3zGNY+U2SVtVoe/rVejbqpXSDd1PxZj9PBfhLYj8Ph1Tevyxj9leq8WCLRk8UqUnWD0n5lO3/sH6BPthZM5z+F3cy1n5KIWJkHUeDcF2cGOybAeXnP0utXpn1Dc9uxNtZeBLkybBe6WTN46YbKq28j1nZBL85lp5vlubmSirE5Q0bXxwL5/XIbhX5Vkn4avPsKNYvsXcssS9rO2YNL7+YB2p1WJW6DuDVj3FYw/6XZR8Kk8fjve7tPmY17sZaV6hlXMJV+uNcvFr9Vav6qz4njNyz1He7eCSs99lSM3yOvHTvt9l9capPH6X5cP9vJJATbYSbr3F0ul7Sg3XvTynJbNX7Q2GdvCRud+lX7Wy060TCrsUGkd5zmhbYeWQQq0Ig+dr9Zr09btsF94n20A7+MDvkjOZDWfpf/clJFwrzOlLV53d2DUY2sEHfpecyUzYZeN3ISScIczqYs9s7BoM7eADv0vOZDac4XchJPSF+F2yhHbwsY52ufx4efnxsi27+XeA4XfRyUzY4XchJPSHWV3smY1dg6EdfKyjXU7enZy8O2nLxjAMwzAM62uLahdrvQuGYRiGYVhfW1S7NH9WP2YMwzAMw7Zri2qXYYtzec6oL5ndK2W9CyGhP8zqYs9s7BoM7eBjlZapxgsXnjOKIb/h7H7tpzkICdMMMxsJMxu7BkM7+FilZfC7LER+w1kC324JCdMMs7rYMxu7BkM7+MDvkjP5DWf3Q7+V8m6YlFtsvrLKOe+ZjYSZjV2DoR184HeJq7HzW6ybYNbhbPlfOBL9LtYPA917vpVW0i8A77q/J+zmo8RYpbu1skrXf7dIPIpee8XkUzm/0qyUtWSLiWW5x155fnvZildynioUj2LafMRWcttE97u0uwyLXBHf2JVaPecmvh18LZNrW+Xsd5n2nFXGT41PmO2sKMJuqqNYsjVEv0t1+HXiSv2GbX3aTgz7DSOfdjsmRiy3zdNKaW2LR9FrL7P0mBLNo3BD/bjmbrFhx6WUovQKpT17hXPnE9kHdL+Lq1Hc7QQHN58UszayR2+Hdls8rfXWvmz3Ime/C9plAWG3ZGvo610q/3d037d289utnl7MQSxXSSnm2ass5ajHlBi5vViLKccVc5Z79YSRXpNZ84nsA4dwoHZJc0ATx640qzorwXZQtEvK53c82fpdqgNupJVAiRGzEtOkiTKcTdg4YuZicSMbTVnvUkV8AzbTNJVppzrRX+LGiNtV6Ju9b9tK3xK/l1m6kt49Ll+e1rGs1WLicbWlB/cKpjHb2To637nw7SWeR/3MxvTe4y7dOis9YbDfpUpyKNNvgaVZ5znQvQtuO2zl/I6nIL9LJalR6+wO20iWeL/LsMYJ5uPbaxiK36WK+wZcdb/Nm6HPfxP0bbjplW/MMfV0a6XspddNOS43jb7X3C1mxbs5VAevT9Bbo9QnxscjHmlMO/vqHDzvwXzies5Y7ZKULIj0N2RPL9+52D65NlS2fpdaumjNi7ME7dJL2A1oHDEfMc0kbeXzu1T+b7S+lJWxTqKK8Em0KRsm97uIZU3ld4mpia8NF2sxK949LrOLBn0q+tHpe4lHGtPOvjTB/hmZj95zJvG7pDOmRa7zyJ5ISeqLMUf1zCjR72L+G5yeYzaSZYDfxfw32DhKPnO0ks/vUsV9u438hh0T005IQW9B5LfnmNKH+V36bq/VYpF+F73mvp5QxfldFA/TsNIrj4dJOfuz+l2saSzlMQ2/S0Pkuh+lNXJtqJz9LrV0rbYxvunZVamVgS9NmgTvlY5pnKpLMNvxLeZ7zsgk0vcghsdM/CsVlDRtfHAvMYzZy8pBr7PvuIJHsXyL+bw11l7Wdkwa3dfitqTid4lpMd+xm/lE9l6zRDGNFfomOQv3QhYv29XptVYvY4Lrfqxzmv6ZnYqc/S5DapbXOZ5WmQ5rnGq6r0r6c0ZLhu2ksnpNthJuvcWqQe+JqTxepXnCrF5itsq36gShHXxk7nfpV63sFP2Ew9mYxpmqYZXnjLYVut+GU6gVYfB8LbxvrzCzSS4zKTYY2sEHfpecyW84W/37NyFhqmFWF3tmY9dgaAcf+F1yJr/h7D6Bb+GEhAmGmY2EmY1dg6EdfOB3yZn8hrMEvt0SEqYZZnWxZzZ2DYZ28LGO3+Xy4+Ukht9FJ7/h7H7tb7eEhGmGmY2EmY1dg6EdfKzjdzl5dzKVcWoV8hvOEvh2S0iYZpjVxZ7Z2DUY2sHHhte7EBISEhISEhYYLi9c6rrO5yFkAAAAKAG0CwAAAGwJtAsAAABsCbQLAAAAbAm0CwAAAGwJtAsAAABsif8Pa6xyoFTC0zkAAAAASUVORK5CYII=" alt="" />

图1-4

由于笔者的测试的两台服务器测试机均为4块R5 15K磁盘,可以认为测试过程磁盘IO环境相同.通过测试我们可以看到,新版本中的tempdb的这个规避一定主动写的行为可以使得tempdb很多情形中(select into,create index,etc)写的压力得到极大缓解,提高的单个操作效率的同时也使得整体性能提升.

注:Sql Server的CSS团队声称在sql 2012版本的后续补丁中可能实现此功能.

Sql Server在面对很大内存压力时,惰性写(Lazy Write)同样会将数据页刷入磁盘.、

Tempdb中非临时对象仍然需主动写.(感兴趣朋友可以自行测试)

结语:关系型数据库发展至今,个人认为理念上很难再有大的突破,产品的细节实现更能决体现产品的优秀程度.微软在根据使用的场景对特定库的不同操作依据其特点采用不同的实现方式让我觉得SqlServer还是一直在进步.虽说很多不如意,但这里我为微软点个赞.