SQL Server 存储引擎-剖析Forwarded Records我们都知道数据在存储引擎中是以页的形式组织的,但数据页在不同的组织形式中其中对应的数据行存储是不尽相同的,这里通过实例为大家介绍下堆表的中特有的一种情形Forwared Records及处理方式.
概念
堆表中,当对其中的记录进行更新时,如果当前数据页无法满足更新行的容量,此时这行记录将会转移到新的数据页中,而原数据页中将会留下指针(文件号,页号,槽号)链接到新的数据页中.
Code 创建测试数据
create database testpagegouse testpagegocreate table testtb(id int identity(1,1),str1 char(100) default replicate('a',100),str2 varchar(2000) default replicate('b',500),str3 varchar(2000) default replicate('c',1000))goinsert into testtb default valuesgo 20
Code 查看相关数据页 如图1-1
DBCC TRACEON(3604)GODBCC IND(testpage,'testtb', 1)---find the data pageGODBCC PAGE('testpage', 1, 79, 3)-----view data page find slot 2(ID=3)GO
ipgxMDAsBHDCvo7ABhFMGJgYNiIYQX9HQCMWk4wevv2i9/45gvD8MrRh/W7H9ZvvnbjBWv8jVffHrrFo5e78S/dfvO1G996Y2S8Orz6kpz/N1987V/e/bB+98O3vvWNYSbBp7x0++jlG6++7bdTeda7H9avvmS13yxFm3LLh8WsV7sfuz0y4xDYv8P8X/jGN194+a15FjHsfbnKb99+cc17dqWvrmFjyk0aeF/Psj21YQX9HQCMWlrF6I1XhuPTG6/IbDQkmzde6fvKo5eH41nbk7aThcZHjx9Df21ll7dvv9hFH3kA6A+ub752o89qb752YzjoqgdFuYLD4tTglXT8GB0WNZ+ZFj3vIfnN12688PJb777xytzBaNgI1j6yX0szL+Xo5WFNrfl/WB+9PPRaW/bw1rcS9sICXyfOFjDbWXtfz7A9/WEF/R0AjFpJMBJ9ohuM+k+i6qf80Pj4weMb1rGzX5z5vzw2h8sAXYODh6JXX1IOk6++ZJcr3E/Y4inyIXsRooJ1wzQvMJ9XX/rmC9+48eprrygVuDdeUcsqonhmnmgeDbdHWa+Zh7mDkd0qfUcnBojRwT2Qz100chN/t/Fj+1Hsl2+9IdZL3b8zvd4mbIEP9fe1UmHVSoMEIwBbYUXBqP/T7kO7A1voeDnLcTRYMeqOo9bRJTT/sfq/tZR+UGsV6id42bA3X7uhfQQWn7bD8xGb8e3bLw6b9C2xEYYD5PD/t2+/KI5eofZE1muWYYHByAnNomL05ms3Es/yBIYuO7q7/q1vfcM5eTp5cD4YiO2v7ke5RPtUWmD/hl8nsf0baW08GKl10+Tt6Q4r6O8AYNQagpFVMWr7/QUHI+1jq2jPcE5kmL94VtfOWMVIRpCxQTlQeZ/sxYFctt96YigYyYPisHntRQwjxeoMh71YexY6LC4Y+VebySy7kNNJfhz0yoTWi01st9D4WDBS9qOzueTuU/fvLK+3kY2cEowSK0aj8XoF/R0AjFrrqbT+z9BJillOXgRrOfrFpPbn3f4KpJGy/5zBKPFcj6iCBObjXgDebV6rtmGlJblcmQtXc1Xv4oJRNPosanXc+ajnTycN4WCk7cdgMArs3+CWmXGDJJ5Km3l7OsMK+jsAGLWaYDSEFfdakK5/tz9NvvUtcSmGOj7W+SqRxT/CmWmcA1IoGHkHGz1+qcOwCHGxaujTs9Ue+yCkzse5LNq00ystiFNp8tziN+Vpu8mRpb3MZdK1R2owmmE+0YvP3Kukp8xfRh954X+30xdwKk1W6axTaUoItl5mw6nV8P4NvU5mOxk6FozG3wXR7ekOK+jvAGDUar6ubzpHv+Ruh4/QqQF9fKgjdq9gHRrTjhFXH7/tnWVQLoTSTz1MKB4M18k6p8aU+asjI/N59aUb33r5hr89xSqYCfxTbC++dCO0/VNOtRy9/M0XkoOCW7ETIWDSfPq1cze+uBj5BbcKOGn+4V92WMg39uWrUVz8HtqP9nq90l9mFNy/E19vqftL/7p+ylsg9ksZzrCC/g4ARvEDj7MOSZedLn3wfktpwjDxPIi/6MVckb2o+Sx7/kv9uv48+3FnhhX0dwAwimA0+7D2g5n8acplP8sdplxltYr5rKCdS7sMazF7ZPuHFfR3ADCKYMTAwLARwwr6OwAYRTBiYGDYiGEF/R0AjCIYMTAwbMSwgv4OAEZtRDBawXoCAACMIhgBAAAYBCMAAACDYAQAAGAsMRjJX2fpb7XxrvxR3e5XW1awngAAAKOWFYzkvZnefO3GC+KeaP0PRr/52o02G61gPQEAAEYt7V5p6m/4euPb2yysYD0BAABGLScYqTdRD9ys+8XX/mUF6wkAADBq2cFI3Fv75bcIRgAAYJMt7VSafed5c/E1p9IAAMAGW9bF186d5/tvpXHxNQAA2FhL+7r+27df7E+ifWMIQ3xdHwAAbCx+4BEAAMAgGAEAABgEIwAAAINgBAAAYBCMAAAAjKUEIwAAgG1EMAIAADAIRgAAAAbBCAAAwCAYAQAAGAQjAAAAg2AEAABgEIwAAAAMghEAAIBBMAIAADAIRgAAAAbBCAAAwCAYAQAAGAQjAAAAg2AEAABgEIwAAAAMghEAAIBBMAIAADAIRgAAAAbBCAAAwCAYAQAAGAQjAAAAg2AEAABgEIwAAAAMghEAAIBBMAIAADAIRgAAAAbBCAAAwCAYAQAAGAQjAAAAg2AEAABgEIwAAAAMghEAAIBBMAIAADAIRgAAAAbBCAAAwCAYAQAAGAQjAAAAYxODUZE1Wb7shfgeFDdvZof3mqap7tzMbh6WX6y+DYux7e2PKw9vZjdvZjdv5vdWuIZl99ovtUeLwPiVuHd4aG+JqsmyJk9v0NTpA3MpsizL8rJ2xtdlnrWKavbxX9w7PLw3Zwvrssmyxl7ailR3zIvWDHceNE3TfHEvlyNv3klp2rB95t5lM6mKm1l2uKJFV3ey7KYY2i30RZnLkTeTdml9LzfTr6rx2F6bGIyapikSglGZN4vu4h4UXedbHi4sWJSHSf3dzPNRxy+w/cH2LGj7T9o+1Z0+Dz0obt4sHiyiBenKZQag2T4MPLhz8463FXIt6ORFeNHzBqO6zLOiaqrCDUZV0R+/q0JEnanjAys6vZ3rCUZm6fcO3TT/4E7Wr9WDO6PZqCqGPFSXuR9DV6IqErJFebiwLV3fy/N79po+KLJ+Uz0oRrNRdWfIQ8rcANtSgpH8ZFYVw8fRMm+yrCnLJsvMMLyv6ybvRhaVCEbVMPHQdYuJ+6coD6UcacSHtuKBHYwe9A9ZIaOvWIx/wnM/EYoDuXzI/ig8zP/wMG8fCs0nPP9I+0PavdNut7zfdOr2jGz/yPzT16ubOL/3RX3vMLSp63uHhfngfXjTY6ooeVfmKe0Xby1ezv169RP3Dzn9px+MIpWkQsw/72ZViZmL1/Mwsh0q7SHt9XzvUIsLub1L6tLaW1nmRtp8QYUULxhZI+oy75YydXzTTCgamVdylwPbLqh99dZlU5TDq3eYe6DfaGeVl8MmrKLTx40Eo26C2OtZzm3WYNTWTtr3TluSaYNCeZhlN/PyXtFVYvKh3xBFmuKBCEYP+omzIW24FZ1M9HvioeTKzUgw6iYYakJi8DMQwQijllUxsj6ZVUOmaTsa2bm0/y9ESLJOpVVD51XmVu+tVizKfJhPXY72WQ+KITQMp9Iac2DuHvriXt4dmMtDcQbnwZ0soacerejU9w77+cius7pjZaaJfso9/SF1Oeyjqhi2W2R7TqoYzbBezYM7Q2p8cMcrDg0pdkQlUkXVZY5chJ7Sy0am0d6LPVQx8scXTVOIRzMRjHq596cv1E4jUEaRb6dhVuGKkTr9DEaD0VANmja+aZqmeXBHiQea2l3XqjDr1+ab/v+yXwr2G5VIP5Xpgib2M92UY8HI/VPXnrSc61RafS8f3lAPij4olIfizNQXZX6z+3g7hCT7VNqDauifDzP5JlUrRuVhLvq9PDEbjQYj909dVXAqDWnWEIycj7JFZU3QNE1TByoW2Vgw8ioZ/mdjy4M7Vj/1xb1cBCP5JjfFiS/u5Xa3Vd0ZL8YoB36vUiIqIg+KwDUHU4OR0v6owt9o0e058VTa5PVy9470xb1clJdGPmFXXmrxKzT9i9oJK6X3Z2IwCh0p60BlSH1KpJ3DmiefX4oEo0VZbjAKlMc07YuzzE1k6SvQer8U7zcq7zTj1H6mf15aMEqsGFVFf0VXd8h3L7sJjY8FI7vfyIsH1gRN0zRflHmfLezi0Egw8ipJ6ZcHpQSjxIpRdUcZCUhrCEay5xwNRvKjrHN9gHpgTrk4aRALRlbiWXAwSqx22BWpea4xSglGg2r4BBzZnrNfY5S2XqFgVN87nHZpuR+MmnBwkRWaZgnBSJ6eK8eCUWQ+rS0IRuI6IeuU2bTxrfS1bUtERd5URVNWw6qH+qVYv+EHo6n9TCfxVFry/Kpi1qJROBjldr8RD0aykmTPU68YJV2cpLY25VRa8vxmbAYujyUGI/lpzDqVpp2OKcRHruFUjlc6coJR93lp+MRWFZOuIn1QiOqFPMVTHorTPdapNHlIdvLNgzs3b970uu7hKeLiSnERcWDixu001fmExofaH2IF1sq6PiO0PdXtH5z/9PVSg5FzGi6JGoxC3yPL7SziHP8mnUqTY9riUC1mWGsVI3kdUrydxpQrkvO8m38x7OD4vJWXc5R/8XVdFt0YJ/RMG28alHYqrWmaqinal27V5KJKHQpGsX5DC0YT+5lu6SPByOqOVO017l0b3C/0TWlJlyS+KHNRVikPrTNNXbipClHaGS5k9kpHdjDqMpO4OHq2as1YMLKap5KVsOpOlnDeDZfa0r6VJqrN7dXW/fXXRaFdTy0uss6K4TIjedlo+0TZr6l17OEi4pQSd3shi/kO7Z32MqP26+7FncPuIXFQt8+C2WWYwJFkWIRzCkk5laaOjM/HHx9rf0BkowUfCmx/ff7T1kued0u62DwodFFz011O5J9KK8TIMjCfbGy8M/8hxoqRhf1QFXiHqe3sTCgZVcXwBkvw4I56Aic078wiUkP/7XLnKD51/LRv7NdN3hWbi8y6wMj0IZXbBamvc3l+2T+Vn97PpH1dP+VblmJLz/NFwuGslrnaurv+Oi/uDCekhjgiLrLO7hT9ZUbi7JV5oixEqefLysMJp9LSvq6fJW236Rd949Ja9df1nVNpwGZxTqVtvoV8i11z7zC9PrMKS1tRDJxTacDltNJgJL8QDmycvjazVa9P7wceF2HS1UsrsIgfeETcUMuhpoLLbUN/4BEAAGD1CEYAAAAGwQgAAMCYFIwAAAB2GcEIAADAIBgBAAAYBCMAAACDYAQAAGAQjAAAAAyCEQAAgEEwAgAAMAhGAAAABsEIAADAIBgBAAAYBCMAAACDYAQAAGAQjAAAAAyCEQAAgEEwAgAAMAhGAAAABsEIAADAIBgBAAAYBCMAAACDYAQAAGAQjAAAAAyCEQAAgEEwAgAAMAhGAAAABsEIAADAIBgBAAAYBCMAAACDYAQAAGAQjAAAAAyCEQAAgEEwAgAAMAhGAAAABsEIAADAIBgBAAAYBCMAAACDYAQAAGAQjAAAAAyCEQAAgEEwAgAAMAhGAAAABsEIAADAIBgBAAAYBCMAAACDYAQAAGAQjAAAAAyCEQAAgEEwAgAAMAhGAAAABsEIAADAyH4PAACA3//+97//fXY65qTzySef/OM//uMbb7zx3e9+97vf/e7fCP4YAACArZP9e7Jf//rXb7zxxmefffb111+fAwAA7JzsN2P+o/Pw4cO//du//d3vfnd+/vX5+fnTp8Nwdvb07OypHMPAwMDAwMDAsHVD9vnnn3/++ecPHz5s//P48eOzs7PHjx9/7nn06NHh4eHXX//u/Pz87Ows/aptANhhT5+ef/31777++nfqf9bdOgDTWMGoTUV/+qd/enZ2FgpG5+dfP3ly9vjxV19++YiBgYGB4enT8/+U58VLLzn/+a9/9VdPn56vvXkMDAyThiEYtanoD//wD7/97W9Hg9H546+efPnlo4cPv2BgYGBgODt7+p//4i/+x+uvO//5hx/84Ozs6dqbx8DAMGnI5Bm0P/iDP/iTP/mTv/u7v4SEO6dPzx89evzw4Re//e3nDAwMDAxPnjz5L9/+9ltvveX855133nny5Mnam8fAwDBpMMHo6dOnf/RHf/THf/zHf/mXf/n9738/Eow+//zhr371yS9/+fGDB79gYGBgYPjss1+3ecj5zzvvvPPZZ79ee/MYGBgmDVbF6M/+7M++853v/OhHP4oEo9/+9vOTk//30Uf/9+c//z8MDAwMDJ988mmbh5z/vPPOO5988unam8fAwDBpcK8x+uu//ut33303Eox+85vf/vKXH//bvz34yU9+xsDAwMBwevqr18ry+PjY+c+Pf/zj09Nfrb15DAwMkwblW2lVVUWC0X/8x28++uiXP/3pz99//0MGBgYGho8/Pv2HH/zg/fffd/7zs5/97OOPT9fePAYGhknD5N8x+vdPP/vJT372z//8v//pn37MwMDAwPDTn/78F7+of/GLWv3P2pvHwMAwaXCDUUQbjD7++PS99/7pnXf+1/88fo+BgYGBgYGBYZeG7MsxX3S++uqrN9988/33P/jXf/23Dz/81/v3f8LAwMDAwMDAsEtD9vjx48ePH3/11VePxzx58uSnP/3p97///f8OAACwi7KHAAAAePjw4cOH2esAAAB4/fXXX389W+stbAEAADYIwQgAAMAgGAEAABgEIwAAACP7b9/5my0a1r25AADALsua7UEwAgAAS+UGo/fee++99977oe311/9+LUnIQTACAABL5QajW7fuO2MePnxY3Lq1qvATQzACAABLFQxGZ2dn979s7n/ZfO/9J0VBMAIAALtPD0YfffTR/fv3P/jgg++9/+TWrftzBqMsC17JFHnIRzACAABLpQSjW/fv//CHP7x16/7rr/99O0wKRn3Wif8nhGAEAADWZfwao++9/8SUju7fv3X//snJydRsJP91Jgg9kWAEAABWTwlGn376aXuD2fv3m++9/+R77z+Rj167VqRko3jcoWIEAAA2kBKMTk5O3uv88Ic/vHX/fvtAc6u4dev+Bx98EMlGTlkolHuoGAEAgA00firNBKOmaZrm5OTkWlFcu1Zcu1aE4ksk/XCNEQAA2GR6MGq/q//w4cP7X3bB6FbRFEXTNMWta7du3b9WBIORjEFUjAAAwBYJBqM2Fd3/0qohnZ2dnZyc3Lp/P1IxiqQcKkYAAGCT6cGoT0X373fBqCia4tqnn35a3Lo2Goz6r6Gl5J54GCIYAQCAlYkGo/tNcf9af6O0hw8ffvTRR++991773bR4KlITT6Z9jT/+FIIRAABYGSUYffDBB+3PPLaDCUbFtaa49sEHH1wrrkWCURb9saJQMIqMJBgBAICVUYLRtaL48z//82tF0Q5tMDI/8HjrfvuL2DNcY9SfSnPCk3OijWAEAADWZfz6njYG+cP