SQLServer 2012之AlwaysOn —— 指定数据同步链路,消除网络抖动导致的提交延迟问题事件起因:近期有研发反应,某数据库从08切换到12环境后,不定期出现写操作提交延迟的问题;
事件分析:在排除了系统资源争用等问题后,初步分析可能由于网络抖动导致同步模式alwayson节点经常出现会话超时等待提交的问题导致。
PR3zgjz+6Z0XDocX7nx6E60CAAAAAAA3y43q7PvT67cOh8Phj/7jL65bzrx68UcfR6n9we2rQxuvva8LV+J3er1cyHff+f3OTu7V2csJmvIJr0/1vtzM/gIAAAAAAFBuTmd/+cmPX7w6HK6urg6Hqxfv3Kso7et7d168OhyuXvzxJ1+eTqfT79/57uFwuPrKc8+v/Okr//prh8Ph2e/+6L/dvXv37t2P/vHzzz///A8PzHI36+x4rqd+fe0KnQ0AAAAAAG5MZ0eR/dzt6YtFQN96fVJPhQjW9PfVSz81ngQ5rfqy8NyFrz/JRfrhDSaUe+jsmg5ezm8T4umv6w9/8Ozh6tWfPyg+FHODz8sAAAAAAADKTejs+x+++Y1VZC/SehXQt15//4tyVvv63p2XX37HS3130dm2LL66/cHyh1a/hh7WtV5cZz/4+atXh2d/8OG1WWOhMQAAAAAA4Ea4tM7+8pO3v3frcDhcfYN9q/H63k9eeuZwONz63tvLYyF7qOlseaqlN3/1oz8+HNhXJ3//znfVwxqWzm5Qz4diQeZzI406+8G7rxwOX3vr17lzZREPAAAAAABumEvq7Psf3/nercPhcHjmpTtaTV/fe2dR4M+9XNXabZrWULesAK03r3/1o68dDt9++3fpyJf//F9euSJfg3w0dfbv3v42aTZ0NgAAAADAo8d+nf0Xf/EXh4N3+Zefvff9bz5zOBwOV9948+/dp0Puf/jD5axnvvn99z6LYpvpxhfufHopnb181fLW7Q8efPTms+z6mCnu89wIuawqxGsnvHDn09Pp12+x3QGeGwEAAAAAePTYqbMXkW3p7Osv/uFnq8Q+PPPNH/oaO53/i7deWk6/eu7lt/72Nw+utc62KT434snWWOq937776q34zPiDd1+Jn1x95et/Tp4IfwR1NvkGZLHGykcAAAAAAOCS7NHZSWRrnf3//tf3b0XNfOcXX9writ2sJD9J6e/D4eo7/3lN1NZ+x+Ucnf0ffvKX3/r6y3c+rr3zpPi+kfsf33n5m7enB+yK897r1/DcyIMPbt86XL34k8JXOWuNAQAAAAAAl2azzqYiW+vs0+n+dPtbL9/5xZLGLovdrLM/PZ1Opy8/e++Hf/YvX303Sd+zdLZ5slaxHk3v9Xvwwe1bh8OtNz+6LlZECurzfPb1r370tcPVd9/B89kAAAAAAI8s23S2ENmWzu7I+Tr70zsvHA7PvvnR6Uyd7T43cv/dV65Kr9+u18Zl9J/8+J47AOx9I9Prz8bX+kFnAwAAAAA8gmwQylpk37TObvg6JJfdpARHZ2uZzpV19fnsT++8cGh5WnrD1xydFvK/Pnrz2cPV6xN/f/and144HL72o1+xZ+Lvf/zWd77+8k9//f/MQQYAAAAAABehVSibItvU2W3PirgQhdpfZ7Nq+ujsJbVMxO1lf3c9/fXg3Vdi+pvU+Lu3v30gT5Sc7n/81kvPHK6ee+3d31a+jwoAAAAAALrSpLM9kX14GDrbfVDE0M0f3L46HF57PyV9L6GzT6ffvf3q9+IT6ft1tny3YEVnX7//WiyP1nj90Zu3FqV9/dv3v//NZ878KSAAAAAAALCTJp391a9+1ZSAX/3qV9tq+fKTH794RX54vY2zdfbyuj6isy/w3IhCVdSy8Xh9svS5/9zI9Rc/e+XKfvR8+VH7q2eeuTocnnnpreobVQAAAAAAwCW49O+un06n+x//6MUrKfmu7935zncqipAIy+vfvvvWf/10q86+9+M/SRnhS7xvxGSnziZf2XR6tPz1yit/nK5aHwuXNS5K+3D4o7/830hkAwAAAAA8JC6ss6+/eP/2c1fG88H3P77z8nNX5YcaosxcHzK+/cFGnf3g3VcOh6urq8PVi3fuvf/QdDbp9PT6N19//4vr07rPIL9Gv6TeX3mXvYvb0tk//vFri8b+yrd++OF9WeP1g9+89/1/99PlR3jiW8zxZDYAAAAAwM1zQZ29/vb6re+9/cmX1w/+8HniHz+6e/fu3bt3//vbP/jWvyh8SW9J8X7jG7cO60kbdfZHbz57OLzyNz+/fWuR2zfw3Mj1F//z33/N/Pj6i/dfv3U4XL3440++PJ1On/70pWcO+UmaBz9/9epw+O47vy/0yH3N4aKz3/vsb996+bmrw+FwdfuD0+n6i79/8xtXh8PhcPXcn/3wvd88gNoGAAAAALhJLqWzf/OfvnVVfVoi8cxLd3Ra+/7P/k38dH3AZNv7Rj5689lFul7fu/Pi0pivvXrnf/zysz9s0Jx1nf1PP3mx1IrT6XQ6ffnJ298jIvt0Op1O1/d+8tIzh8Phub/6pXpNyHLCF++99myDzv71W19LFXNNHb8KeTjQn9kEAAAAAAA3wMXy2cuLLxadfOv5559//k9feeONN95446//5u7du3f/7pefff7555//4cF1+uLeN/7q/7A3PC8p3sOtV3O2e4vOvv7wB0SkfvnJ20uudwN//KNfNfWUvyjk6itf//N37lEh/39//tpzV4fDMy/95J7Q99f37rx8e7p///3Xns0/Kyl0+/qO7JOrs+P5z3zz+z/7B+MZkS8/e+/73/r6tm+gAgAAAACAc7mB70HWub535zvfUSr09OlPXr79PlWOW54buf7wB88evv02zeF++c+//Nlf/9t/9SfPP3/rmbrMFt9JPKN3X7x/+1v+C6z/6acvXR0Ot15PQjjvJsgz2Kp/pPx7d15+Ge/uAwAAAAB4tHgkdPZl+N07d37+oH7aQ+f+dPtb3//gcWgpAAAAAABo5gnW2QAAAAAAADw0oLMBAAAAAADoD3Q2AAAAAAAA/YHOBgAAAAAAoD/Q2QAAAAAAAPQHOhsAAAAAAID+QGcDAAAAAADQH+hsAAAAAAAA+gOdDQAAAAAAQH+gswEAAAAAAOgPdDYAAAAAAAD9gc4GAAAAAACgP9DZAAAAAAAA9Ac6GwAAAAAAgP5AZwMAAAAAANAf6GwAAAAAAAD6A50NAAAAAABAf6CzAQAAAAAA6A90NgAAAAAAAP2BzgYAAAAAAKA/0NkAAAAAAAD0BzobAAAAAACA/kBnAwAAAAAA0B/obAAAAAAAAPpzAzp7CsfjMUzy8DwO+uBy/LhAPp7HYRjnVBrDLEU0IJ9Dqo3HWZHDONM2HI9hon+Rk2RzJeSkXZjj5lenh0QPlT1ubHzkIJ0KJRVKKB+vti2NXb1tO/GbpqjXOI9Dkxm6JjEF8ZHbPHVmXhqySeqw6khqkm1WrADZIntUGoa1ZMJnrpknesloCzLmuKMhbRk30zxk22oFKtdbqnQeB8da0sj7huisGdGJui23+KJ5HEp2bTbFa59CNbh5Oe/GcWPOvKVTvS5VuroWW266nqgpDONUc8py9i7RhZJwabX4PvO2hdxq1bcNcZNeU2KzH4zNKi2/eH2DPuvlukpcWmev7tBcnFGdiE5YQye6nkcmDjWbSrXo4hFrwsOUI06shvy7uHRaIm/LBpmzhXkcjscQQsM2IiNCp9xf2CPI/r+e1axl1xp36Wy3BtrUM9pWwdHGSn60RdOpOlMlma3qKA2c5QOcNcNqtM9ztwjKgll5frStmr17zplr5klfMm07nQsYUsvVlrVUJrN1uv2ltVjkJGIgP1cEl6RDW3W2r+cbBqym3KymrHvFeZ7pgWpoywcusrjKtZZYDXKjSE2dpipXBm6/OWqR6Vzahm7s64L4TNXWpCM2Ug9DTdDGFLygrrxLZE71usWlNq0nmUvEWApGcL+o68pcVGcvkS8buh62qruW0jjuUeJZJCedKyo5IzOf7ejs9YQbz2eTcSu5ecV+0ZC31mR/IcoW3aND5w6UOyob8tn1tjUOTrVtKacZO+We01DcKr6qleYRWXbo5bPSHDv1q5hNTLvo59WhvAbqpILLHS6LnLNCzZO+ZHhZln2SJdPfkGrj1mRdgrbp3rTcWyO9rDo238lnp2XU7EO8NPYU5EEey45GkGwMbfXE8N7FVe91XnjahoRIbfEn1J04em/puMzQBddls8ycr7M7dsFoW2mF9BGpF9DZomnkjw2robHpjaWJHcpMzJq5CzGmtiu5nOuiXE5na5eijyhatox0YNJx7oxG/74ZN3+dC8/BcyKbphvMZ6t731o3SJOUodM5zbLaKaweYB6DygzR0u0QVEzOrfU3pe2s8WpuWxM1R8ZDlp0TZE5mS1RrSRXmEp2m0vlcVTz3hlRTl3D1biGP0UZ5VCoF714zT8GS4SJ/EdKeF+pnSPvGje0/fJqmexoHN9+ZRHDZzv2+k7OWTjs622tbOIYQnNAt0z/aSOkoOB+KZhRDG8vxaavtmM/2FrltksVk8Fx+LKSms9fj9fyd1Nlq2a6nd+9CXkyWneaLPJfdMUG8AdFT+mfBw5+3VWiPz3Tba2yUnFLiCMvmX8x1MS6js323EbV27rUdqYSV5Y6R1AMdtgvks8d4WU1nO43f7taWstzIaN8oYwmRrck52lGiBXcm50RfwrQGBltQ6HwEL7u9bRtoEYJ2W/n/NpfAYkSxDcbekRXFp9HVzKxAq9XFhDXfZurZYStlrtSk6nUX/ObJeVqWjNDZIah9nB66HobUNm5GWrWioLw2yzbSp/r0p3Lmt+ezmToNIXg5USMNnYN9ZcdNJr/UFI+t+WxbkN6MzjaGrCBS16eoh3E0ZLHrj3jH46YzdtKZN62mSBlcXXTqAi1u9bOFtGnDEhXl0ow5UcH0AYK4gRPmR6+bvIcJ/ZrrmwM6eLVzVAdqVjrnG0W+zl67zZq6uFXpNC7lugT9dXb0QPYAx0+cjYM64uVTJOy8MIm4xGMFP9PV2W3PjXRDRQ3pwM0syZmiYQrHJbRPMnfQpicd0UA2Q6JkXr8R7+j257y2lRrMICs3niQmQjatyXtQ5yfmxY4qKT9XUvXLxZt2d2Wd7Y0Djds6yWfr7FI62ElMlRpU4ylaMiqfzQ/xPVNHQ2oZN2Y3XLDnbdDGeJtHND0G0zC8phA1qjD9jrreUdDT8szQlO+ZOJs9GuyncJRrs7RY6HA0hja2Y2DclM628UTqOro81KpLPbfB3RDR2UR904tEPntm/aiNzd4upA3xPA7DUHo8obxPthpEzCl7OaGzk1GSM04x05nL2aKzSzvZ1l1uuYxyfJ7H4TgMalLpuWpBEKcaPREbgP6uS/NQ3+vXoLOND6R/EnGUyTR2JBYU/6jks2c+P9q9NY2/c6OvYZb8REm7aCi2zHDWepDSAbPJlmggMZFkHXSQKYxgLqyhbZsgQ5Qql6Mcv6y+ZbJ85xH9mjMb2hjLs0Xd58nK6TXvAQwZOVqu34zbts4uDLup9Jwh2+3YntwlwxtGgw7XEz0NqXHcmIhIw8BbZM1K2XREwnKeDaVaGGm5cfZ2LZN82oq5Hv3KHXYGH53l0yE/G1/akssdUmE8GkMbXa/G1uEcnV1Zj0m2mt00RWoeduZmuAHGApVB5W7xOs1YmySZPGSMfNcuTOEYJqrq3ZFzXGFZZwvfnRc90dOsMamL5pVtNdMPGvaJ9qP2JZOsxecpkDFt0tl5UvJn8dhlXJfFJXR260b9VDZCtv/0QmPJ9ejPTpbO5l7E1dksgLn6oFfO4FQRDeZy5eGEt8ZQVVI0FJSgNu2lLika6MZZ11LIadaCTEWlNkPK8abK+IqXVw851RaNs3ULyswHGdeLQ9FOC6LdGhG2ZRcf0NZL6U2jh5YWe3V21TectYCe3CXDD+dm5WAioxjv/F5Dahg3+rh4rqluGIUzuGmy3h753sDYMKqy5/jWKKNt3KnLKR7Pcuhcb0dE+BCrsLjVKYa2C+ps1aCiqxaOQ4lUFgiky2FfdlvGfwxR7BrdyudO5N9TSz6byS5+Vo8uzGNgtqkml1zmbmScuCP3JOlvrrONXYF7pSzfm2Jf+Q/jRCKFMHNqMyUn0RCfrUmln7EFMZJTaCBbyriA63K4cD7bnkbyqWeErNeBZD7FA3vFLb4syzTnEFhKI1kji5hx9VnGz5pqR6VdFEWDOahKNDj+XBShi5v3Jedy3NPDHD8gK8T1LmSMG9q2idIjb7Fp7IzYUqtOqYnU1IuURqkNS1kFGZrM2w7Ljk2sC9D6lBr7Wqans3VLhM4uTaU1BE6LfZNv48ldMp7O1rX3NaS2cVvPHAbDfFwKwdyL0Kmi6ES8vR435JCsW0nONFpStub5Yf2nWR9ubcwAJvfVIdJAlXxUY9IU2mrr9WZ0tmVrXKRGQWDaZ/xgmZEsgaKIK+ns4/F4HEIo5LOFiuIy188C7O4Cn5WizvbGuVVn0yVR19nCqRV1NrXYyfmSNg8g3MtYPaF/yUGox+dtOnu2P+N0c10+F9XZdKqtpuX1M8oRY86FfwtC2nfayMlIosuKtdL0hqUteGPn/KDgqPwgNcSOvuy0R3QwIxWNOVs0CNM2dztGF8zjNFqxCtJDo/t1tvQkskUVISbHMG/RjFh+LG0IeGdrbainIcXFyaUtEd+qnQ6F3vEaYsHT2dpJ2ivFwzjLtG5/ENt4cpfMVp1dL3OLIVntsfSgY0o29hlGxsVfsclAfZ2dNVIMDcxIbAVAFgtfN8L6qeZyfxiFhCZ7jbLGa/fVGNpom4wRUzJ8/0Lbls92+lk+vu6NTH9EKpNDSwSzGIsp8KdKaHaNrtB+XZCf9dbZ/AkwIouLOnu5lF7p6Gy+TSGVyICxbG94Vepxq4LqlvNaic8nMami7dwRNursTq6rxOV0tm7LZL1+y799mT1eCHTGTRo3/cxtTuEolLOtHib65dWZ3oZfnOIUTfch62xWveG/zxMNan7OEg0pTaHf9MvSx9t1dlmrlZU/XefMIcUD3MOsUx/dz36dHa1cBdiCPMonWSGYe2J6rp1KSMXoj02d7XbOwki/eA8Dn7d+nuglY5eT6mLusp8h2cihivHdm9mWMhy8yJvn2hpp5q7FX/7OKqs3aa5KftlKwtglVMZ0JjeEqKaxbK0Y2irDKUJbzYuW2JbPFvV77So2ev2/V3bqjaOzZ/n0ntjM0Onr3AWms0v+wMD/vumy3lOJ3I2XdfaJr3Sdfjmp0CdjyZRuORz1KPNld+TPYqXrZawqONZ0jt5xFVIKsY91D3NB10W4kM42XV/a+Mvxsv0TTy/azrTkxMgVrmpLU6z8MVmUU7BCaBhH/m3oLW1roVk05HXDPIm5e87tlEkayw+kUq1NE9sf2d20V03hZXRqeTS0raVKa7AKE6U0tvxAmHGxxHm9YeN3Ib0Tyu/nMfvVMFmmvV48jIUvjJEBCPZrYFh38spLGi4fTqfZNYlBYQrC2Gtbk7CDJ3bJCJEvpiB1Y+pqSO3jpvJVRqXFMgr4qo7siI2Nh3cV9/cq82bPjJTeJdFnRp5C95yhKMV9q4INy7mtZV5XLVbDtoJr3VE062x3m2rq7NGbTLYrZU3r3wWms033UlqqnhWZ6ngXNY/J9n9Gr2IhLau5aSffEJ8tnS3KlnLbKfHCrovwUN83AgAAAAAAGjlHZ4tvJJ5