知方可补不足~sqlserver中使用sp

回到目录 在SQLSERVER中每个会话，即每个查询分析器窗口都会产生一个SQL进程，对于那些持续时间短的进程，它们转瞬即失，而对于持续时间比较长的，我们需要希望查看它的运行状态，就可以借助SQL提供的sp_who命令，下面是对它的具体介绍，主要选自MSDN. sp_wh

回到目录

在SQLSERVER中每个会话，即每个查询分析器窗口都会产生一个SQL进程，对于那些持续时间短的进程，它们转瞬即失，而对于持续时间比较长的，我们需要希望查看它的运行状态，就可以借助SQL提供的sp_who命令，下面是对它的具体介绍，主要选自MSDN.

<strong>sp_who</strong> [ [ <strong>@loginame = </strong>] <strong>'</strong><span>login</span><strong>' | </strong><span>session ID</span><strong> | 'ACTIVE' </strong>]<br>你可以在sp_who后面加你的SPID号（sessionID),登陆名，线程状态等<br><br><img src="/static/imghw/default1.png" data-src="/inc/test.jsp?url=http%3A%2F%2Fwww.cnblogs.com%2Flori%2Fp%2Fdata%3Aimage%2Fpng%3Bbase64%2CiVBORw0KGgoAAAANSUhEUgAAAkoAAACnCAIAAABhBOS7AAAgAElEQVR4nO1du24kObLNr1msI0F2WmMssLYAyV5nUL4GEIT1%2Bg9UAwho7CdcoLHGFZDfMLhWG%2B3Vx9Q18sEg48FHMjMjVDxIDHqyyGAwGMHDYJXI7tfPv759%2B%2FZbQ0NDQ0PDF0K30Nt1M2wqfM9W9unIPrDVF1vaKkR1A7YRqQiLxjShs0dvv37%2BVf2B3LmF%2FN1a2acj%2Bzy2%2BmJLW4VPdQO2Ean4WDSmFZ0bvSlqYrfHVl9saavwafSm%2BbFoTCs6N3pT1MRuj62%2B2NJW4dPoTfNj0ZhWdLZDb58vD%2Fcvww7mZhqyMqLlgyJauGlr90k14PgmwbDxWEgW1Z4d5i7VOm%2F0fL483L9opTcu9qqbO7mhpCYEJTWF%2BlrC2Lcv1ehN0xDs%2BTR60%2Fw0eqvQO8aZtdJb5shpyd5uhN6Maqu1g1oM2OhNz%2BiUPTdLb0zhw%2BhteL3ruq7ruofXH78%2BXx7uH5%2FvxxeP32FPPl8euhkF9Oaq3719ji%2Ffn2d5zx8ZDSV05P3t3lX%2FrSI654%2FfriP4CDN%2Fassb2jROY7Z4rH76EZQRc%2BXx7uX96elj7%2B9Svs9V9wZBf7TH0khiZb26B1rDk9OntpruThDUgFnfPP9%2BfMWKD8hGjidixfPjqL%2FfPMIk2SO3rU43c8UuQc4ioGM89Ui5tdQ5WYafwoent%2FXtx9sgXoz9P7rO6Pt%2Ft55vp4zKe3H2%2F3wLiBwJ%2Fvz93d20dqQ6kdwXWDWYMYV1%2FIkd7pmWIaC2gc2JfPl4fOf0%2F2ehxZ%2BI%2BplWBo8rUNW8eaM6Ozl%2BZKnqgBvaBzPslSCB9ufhCRTdyS5ctHh5ypWLMkTZK7eNQ4QOTEO79ZfCOcBnGthNk1lOCZ4ih6%2BxGuPmBXl56QDJ9nboiFzJBdEhoq6gi1WqHHFQg50DtJU3BvIusvpteAGr2h4Rfj8b01Vh9mdPbSXMmTZEAYdGPPnt4rj0gwQ92A5euMDjZXYJa0SXI%2FneWJV5hVwvHlZ9fgYWQe%2FN3b96euI52%2BGr35yZCwYCykN64jYPEbz958Icd65yp6S%2Bi1c%2BXUnq6gN2Z09tJcyZNnwKmDMHuoNyI3Zvk6oxO8sUFv%2FMQr0Rs9vgRNBI8uevv009gP1zFuc3J4vSvanITfygRBS29Ocg2ldsTR2zxUYTJOfYST%2BsO8M2dzkpiqmF6H%2F8BDUxpLgubc6OyluZInuvijNiel3kXDbQoirombsXz56LAzlWQWeZLcw6Om1vFIgUXMtIOKxh3XYmdX9DCm0PPTkruHZXciGMLp%2FV129jZ5RrCVEftpCdNQUkcm4Y%2Ffwfu5U9RHc1tKf1oCZyK8fUQtG8Nes1MVOTRlsSRpTo%2FOXporeeJb90w2MLzekX2M%2F7RkdGyuiZuxfPnoeJ1FM1XRJLmHR7nW0Uh9PHKTHlA7rMXNrqFKjCl0%2FGHA6py6nVqyU18%2BHoWvZNRp255tDNhGpOJj0ZirdN5rB%2FWXllNLGr3t%2B2T2xa0iD1k1fyXLH%2FI0etP8WDTm0fQGZ6QR9E61Dnqz0IpFL%2FwafbGlrcKn0Zvmx6Ixrejs0du3bbAYYiP5u7WyT0f2ga2%2B2NJWIaobsI1IRVg0pgmdHb1tiuv1unUT%2B7SyT0f2ga2%2B2NJWIaobsI1IRVg0pn6dHb0dnki2pz3taU972lPr8ejtug02FQ6xQyv7dGQf2OqLLW0VoroB24hUhEVj6tc5pLfq%2FLk1d0I0esuCrb7Y0lYhGr1phkVj6te50Zu6JnaDrb7Y0lYhGr1phkVj6te50Zu6JnaDrb7Y0lYhGr1phkVj6tc5hd7A4WBb0Ntwmv4y7zQEL5Y3iRBaKZaZ3sSuuJz7%2FnxZV0ZLX9KQNbjMcA%2BncPjxm3KByJHzauG2pheXcw%2F%2BftXV9N9HXbt6dHACnbREzRKR6PM1moViqugeBT86gYvO%2F0v2VO7%2BcOo6Z0F6mHKcaof5diVkepsv4dyQ3obTbIHh1PXny%2BXcw7HKMg7biguMlBApamJnNHqbQTgMMdxL1C4Ohd%2BsEzi67%2FSveQKK1SLakuSgGnB8i4e7NDpi%2FkMvHfLbyanF2SpH1OXcByyQNAutm1pK6G1pDvoX3%2F3h1J1OJ6SjLz%2BnFzvMtytxdPbmgplArm2kVsAstGY9oYUSGr1RmHrMDndq9rZCoKuUWQsP1%2FyCo7GwQqQv1aOjnN7KUODzXBVJVOmMfCC90S8x252G64D4bQN6qzffrsTB9CYmaNWyN3KhUwapI13Xjck%2F1R4qcDoFy3%2B3LeAmtbOwTxXkA8syAZdZ0xd%2FE%2BNAT02gt8lh%2BOHOpbcCgVTKl1ILe%2FvygqOxStlbcXRk0RsRINkePr2RHJKxlV9llkhKExhRCk9PJlV4jHfW2TbI3vy6I7sR3atPbxXn25U4nt7wPL98JM%2FOGMfRG9wQPw1Ee6jA3DdiMlyCH8b8NCvMb6asF9UiyqzrC%2FzkUFeN0tti1Fr0ViBwnNbGV1n0Fng7lIPMjlZMaWuPQ%2BmNChDZw1P8GavL2Sp4QfZT%2BCglPF0RsnDEriX05oY%2BmAQItSd2IyyC6C3ZqRq9JWRvwTwfvs%2FAcfQ2OQWx4QyilC0AFn%2FOXwckBItNqbWyL1ff47XSG3SYMnqbVvEwly4ReC3I%2BRhvp9JAWN17jxcjIQ6lN8r%2FSX%2BOvrkSDunGTrAVrBIGIPMRtFF6eMqFs42ZsjkJ9KSzN18nLsPjxGbq3OhtBtgK9tyjyCRCK%2Ft89zacuo7O3mIF5FRJordYrZV9gWtmrdlb6DCrv3tbIXCqDjN2uZbg7W5pBAvAOGGUJFE9OrI2J5dXzv8L6U10SNpWqIorhqVRXp4VnnJhBrwx%2Fcrc6EvdB7kbUah997btLyfd%2BmLeJi80CNsKuW9QsQk3RY3y%2FeH1dicu574%2FD%2BSP8%2FxXTArojOW%2FATlDUKZ2X3LMVRFSLLGzSZQBqOgrEohHIkkN1JYoB30uLMMRqkdHBr1h%2F6epC%2FcO%2B7PokLStqHh09BZK8wNnHKGE8PTMyBfON6Y3rnC%2BjNCbZzqS9bD4OvRWb75dicPpDXy3O3tix6XRMcgukrCZXN7EkvyH%2BxN93y8xsxS4nPu%2B78MeLjrOFYRtmVlsWIsuU6kvueNRFZy2pMMww51Eb8UC0UjEa8ltgdnSgV2Fx%2FYnq0dHVvaG%2FD914xH7s%2BSQjK1QlbHH87oSSYMv4UrEFaLTyqU4X7jEmEAdeW%2BG7j5aBXieIn%2F3JkX8DvPtSrRTS45o4uA1zYR9BqUWbGmrENUNuO2IHLurtTssurd%2BnRu9HdFEo7d82NJWISzQG8xmFUTIjrDo3vp1bvSmrondYKsvtrRVCAv0druwaEz9Oof0tsWN4I3edMJWX2xpqxCN3jTDojH16%2BzR24pbvyNo9KYQtvpiS1uFaPSmGRaNqV9nj96sP13X7fDf9rSnPe1pj%2F4n3JzcAntmb%2Fzv%2F%2B36dN13Q4d2Qf7DEot2NJWIaobsI1IRVg0pn6dv9RPS7qu25re9I9oOmz1xZa2CtHoTTMsGlO%2Fzl%2BK3lr2lgX93glhS1uFaPSmGRaNqV%2FnL0VvLXvLgq2%2B2NJWIRq9aYZFY%2BrXOUJv35%2FmP7J8et%2BK3vxDua4rDnThsrc%2Ff7%2FzD5p5%2FLfy7C16VmwN6PdOCEFb7DBrDuUqFogcOa8WbgucW%2BhAnHOVFi5ZBkwBJzA4aawgkGmkhABnq%2Fym6uoeBT86KRfixFxlqUqdAehVyHGq6h5VHRK9Da93M6v9eLvvnj%2B2oDd3pqw7fBifUpvYmZTs7T9%2FO2ff2rP3hq9IXDapp1lvEQtPoYwdLFCge5gP3xlCVuLaEuSg2rwB%2BWmG3CPI5XZFnOQSG%2BkrXJEUUcqV1KPRwm9kSd28t0fTt3phC7rvvkjlSeqe3j9UZ%2FexEPoc23DZW%2Fw%2Bfc%2F7%2F71H%2FXfvTV6Q0jR1p1tm3p%2FTeRkw3yBrlLhNTr4BUdjtW4M2PFCnFXIpje%2BiiSqNNIOpDf6JWa703AdEL%2Fd%2BoU4G2ZvYoK2Qfb2nz%2F%2B9vc%2Fqz%2B3dvl7C4dp67JOMPtJvzG3yiYy%2Fi3mBNHqq%2Bluy9Hb5fce0Rj0VcgkEr5Umphb19ecDRWKXvj9Ywgi964GwPOwk4sc4dAGCxcZ4AOfpVZIilNYESoRKi8J5MqPIYz62wbZG9%2B3ZHdiO7Vp7dij6qOJHobXu%2B6%2B5dhg%2B%2Fe8DQOP8qdwKPZ25%2B%2F3%2F3jWzm3sdnboise2At1aX3wJrSIV8afYkGF1Y7zxehNGIS5SB69FQgcp7Vl4NLpLfB2KAcNNMjqOojIUvBQeoPfGIHrTMM%2B4q1X8CZyuxv5hkmJyX4KH%2BG4I%2BMa78i5whG7ltCbG3puTvB0wm5JyM9xqq9Ab2u4LSl7c%2Fb3vxjJt0oXyd7%2B%2FMeKH5XEsje0esLRwr25oiVqUMafETrs1kX4SvQGHaaM3qZVPFjsFgm8FuR8jLdTaSCs7r1HyR%2FCofQ2Oa43%2F9cKFjh2gq2k%2BGI%2BgjYK4m7gVZULZxszZXMS6Elnb75OXIbHic3U2Qy9reS2KL3BrWDPPYpMImdvf%2F5%2B97ff%2F7uG26TsbRW9gXWpXCs%2BieWZq5KkPSBoGzrM6u%2FeVgicqk%2BjmlBL8HacsYO3aOaIfcshxOBu370Np3knr5zeULDABmhbCfGFpVETMo47QVW5MAPemH5lbvSl7oPcjSh0s9%2B9fTx2K%2B7pTqI3f30xb5MXGkTM3v77r7%2Bv%2BlFJUvYWDGxGxKJawS%2FqXOyFP7UrxhehN%2Bww5DbRVDSB3ooEEgOTogZqS5SDPheW4QisAVk9I8igN8fhl3M%2FZzNEIODeuTezDBQsdF%2BuwFZCVBLS%2FAXHOEJoWKS4FgvnGzP8OxJmk5HvPst6WHwdeiv1qOqQ6M390VvXdV23yS8nr%2BGf%2BQR%2FjZFlGyl7%2B%2FbYrfh7gNTsDe4C9H36fou3d9D7m5DhYm2x0Fq%2F%2BRr0RjoM82c3SfRWLBAPTLSW3BaYLR3YVXhsvSNPoJSeEWRlb0snXIJE7mGRng8DCgcLbJOxFaoy9nhaPGBp8CVcibhC9CJ1Kc4XLjEmUEfe9aO7j1YBnqfI371Js0x1j6qOdmpJjezNJmz1xZa2ClHdgNuOyLG7WrvDonvr1%2FlL0ZuUvVV6unbm5EGwpa1CWKA3mM0euam1Pyy6t36dvxS9tewtC7b6YktbhbBAb7cLi8bUr3NIb982QMvedEK%2Fd0LY0lYhGr1phkVj6tfZo7ffNkPL3hTCVl9saasQjd40w6Ix9evs0dsXeLqu2%2BG%2F7WlPe9rTHuVPuDm5BfbcnPwCTewGW32xpa1CVDdgG5GKsGhM%2FTp%2FqZ%2BWNHrLgq2%2B2NJWIRq9aYZFY%2BrXudGbuiZ2g62%2B2NJWIRq9aYZFY%2BrXudGbuiZ2g62%2B2NJWIRq9aYZFY%2BrXOUJvy7lcZZe9JdHbENz4VH6gS8zc%2FgmBHlJb0jKiKWe5xcpo6UsaBG2xw6w5lKtYIHLkvFq4LdJZiXOu0pw4y4Ap4AQGJ40VBDKNRJ%2Bv0Sx1KNe24Ecn5UKcmKssVYPDNPEw5ThVdY%2BqjtiRytN1Ae%2FPpWcrJxyp7I5pIw8TTgffyjJolDzvOO3iJvZFo7cZaWcZYwdgXaJQoDvYD19ZwtYi2pLkoBr8QbnpBtzjSGW2xRxk%2Bzw%2FgYiiqCOVK6nHo4TeyBM7%2Be4Pp%2B50Qpd13%2ByRyuD58XZ%2F9%2Fa5Ab3hM78Bcm1TFm%2F4evYVTeyFRm8U3Nm2qffXRE42zBfoKhVeo4NfcDRW68aAHS%2FEWYUCn%2BeqSKJKZ%2BQD6Y1%2BidnuNBCz3c1eiLM8ny8P22RvYoJWMXsbQZk60ymljnRdBw9E9%2BWjAuiScnDXwDKpnYV9qvCEdeq089uit0vuPaKx6CsQSKV8KbWwty8vOBqrlL3xekaQFW7cjQE5Hu5fXsql3pSt%2FCqzRFKawIhSeHoyqcJjvLPOtkH25ted9qhw9%2BrTW7FHVUfabd2bffdGzvPLR7mnqhbQW87GpNAE3BCn7oLCBcJLykGdJfiD2%2B7hDDhlvagWUSa3L0oR1XYxai16KxA4Tmvjqyx6C7wdykEzBFoxMVN9gEPpjQoQ2cNT%2FBmry9kqeEH2U%2FgoJTzJHTlXOGLXEnpzQx9MAoTay0SH%2BidfiFOyH2CJ3ubNyUKGi2dvwTwfvs9APr1lp85ME5NTEBvOIErZAmDx5%2FxVuO3%2B6sVYpFZ2X5RC1hY6TBm9Tat4mEuXCLwW5HyMt1NpIKzuvUfJH8Kh9Eb5P%2BnP0TdOGMrAAqNDHYIqYQAyH0EbpYenXDjbmCmbk0BPOnvzdeIyPE5sps7m6O2v4fVuk%2BtMwVaw5x5FJsmltwLTy00Mp66js7dYATw7JQZ%2FtFZpX7RB0DZ0mNXfva0QOFWHGbtcS%2FB2tzSCBWCcMEqSEGJwt%2B%2FePP8vpDeQxEWzN66KK4alUWGTFZ5yYQa8Mf3K3OhL3Q82qUS%2FqUFvNr57G17vuqf3TbO3YH0xb5MXGiQz3koWFnQTbooaZfrD6%2B1OXM59fx7IH%2Bf5r5gU0BnLfwNyhqBMZl%2B0QooldjaJMgAVfUUC8UgkqYHaEuWgz4VlOAJrQFbPCDLCDfs%2FTV24d9ifUXDRfbkCW1Hx6OgtlOYHzjhCCeHpmZEvnG9Mb1zhfBmhN890JOth8XXordSjqiP1797KUrcEegPf7c6e2HFpdAx59Fa0rpB2WYHCbi%2Bg7%2FslZpYCl3Pf933Yw6XrcwVhW2YWG9aiy%2BT1RSc4bUmHGRL%2B4Ix5Uy4QjUS8ltwWmC0d2FV4bH9SnkApPSPICjfk%2F6kbj9ifPXtgeqNshaqMPZ7XlUgafAlXIq4QnVYuxfnCJcYE6sh7M3T30SrA8xT5uzdpBq7uUdXRTi05oomD1zQTvga9NSSiugG3HZFjd7V2h0X31q9zo7cjmmj0lg9b2iqEBXqD2ayCCNkRFt1bv86N3tQ1sRts9cWWtgphgd5uFxaNqV%2FnkN6%2BbYBGbzphqy%2B2tFWIRm%2BaYdGY%2BnX26O23zdDoTSFs9cWWtgrR6E0zLBpTv84evbWnPe1pT3va8zWecHNyC7TsTSds9cWWtgpR3YBtRCrCojH169x%2BWqKuid1gqy%2B2tFWIRm%2BaYdGY%2BnVu9Kauid1gqy%2B2tFWIRm%2BaYdGY%2BnVu9Kauid1gqy%2B2tFWIRm%2BaYdGY%2BnVOorfvT%2FsdynVdcaBLzNz0EUpZjWgZ0ZQ%2FDI%2BV0dKXNAjaYodZcyhXsUDsUVm1cFvg3EJ80hJxflLZjQG8nhFwAoOTxqqdzJTo8zWapQ7l2hb86KRciBNzlaUqdQagVyHHqap7VHUk0Nvny8OGZ066M2Xd4cP4lNo08K0sg4aPYcs7%2FEcLJTR6m5F2ljFyAOLNOoHYoxJqEW1JclAN%2FqDcdAPucaQy22IOsn2en0BEUdSRypXU41FCb%2BSJnXz3h1N3OqHLum%2F5SOVfP3%2B83d89PxXehhOnN3zmN0CubdLjLfCNepeA7IVGbxTc2bb0fRyp2dsKga5S4TU6%2BAVHY7VuDNjxQpxVKPB5rookqnRGPpDe6JeY7U7DdUD8dqsX4vz6%2Bdevj8fu6b34srcovYkJWsXsbQR5lYa%2FVittgjgQffmAvjEAXVIObhlYJrWzsE%2BF7iYgTju%2FLXq75N4jGou%2BAoFUypdSC3v78oKjsUrZG69nBFn0xt0YkOPh%2FuWlXOpN2cqvMkskpQmMKIWnJ5MqPMY762wbZG9%2B3WkVj7tXn96KPao6ZHp7f%2B4ev6%2B4yzSF3vA8v3yUe6pqVrzNbt2fTutDGm6Ik1e1oQLhJeWgzhL8wW33cAac6BnVIsrk9kUpotouRq1FbwUCx2ltfJVFb4G3QzlohkArJmaqD3AovVEBInt4ij9jdTlbBS%2FIfgofpYQnuSPnCkfsWkJvbuiDSYBQ%2BzLvUaH%2ByRfilOwH2KC3hdW2zd6CeT58n4Gy3ZIYC6Q0MTkFseEMopQtABZ%2Fzl%2BF2%2B6vXoxFamX3RSlkbaHDlNHbtNyBuXSJwGtBzsd4O5UGwuree5T8IRxKb5T%2Fk%2F4cfeOEoQwsMDrUIagSBiDzEbRRenjKhbONmbI5CfSkszdfJy7D48Rm6myC3n683XujVMZw0e%2FeaO8tMkkRvcXnhfQmhlPX0dlbrADWIjH4o7VK%2B6INgrahw6z%2B7m2FwKk6zNjlWoK3u6URLADjhFGShBCDu3335vl%2FIb2B5Wg0e%2BOquGJYGhU2WeEpF2bAG9OvzI2%2B1H2QuxGFbvm7Nz%2BNq09v%2Fvpi3iYvNEh6vDkPzGyObsJNUaN3oC%2F5ggID%2BeM8%2FxWTAjpjBVs3LmcIymT2RSukWGJnkygDUNFXJBCPRJIaqC1RDvpcWIYjsAZk9Ywgg96w%2F9PUhXuH%2FZn8Bh335QpsRcWjo7dQmh844wglhKdnRr5wvjHD71SYTUa%2B%2ByzrYfF16K3Uo6rjcHoD3%2B3OnthxaXQMWcvJAf2V0pomluQ%2F3J%2Fo%2B36JmaXA5dz3fR%2F2cNForiBsy8xiw1p0mby%2B6ASnLekwA%2F1nN0n0ViwQjUS8ltwWmC0d2FV4bB9CnkALgiEr3JD%2Fp248Yn%2F27IHpjbIVqjL2eF5XImnwJVyJuEJ0WrkU5wuXGBOoI%2B%2FN0N1HqwDPU%2BTv3qQZuLpHVUc7teSIJg5e00z4GvTWkIjqBtx2RI7d1dodFt1bv86N3o5ootFbPmxpqxAW6A1mswoiZEdYdG%2F9Ojd6U9fEbrDVF1vaKoQFertdWDSmfp1Devu2ARq96YStvtjSViEavWmGRWPq19mjt982Q6M3hbDVF1vaKkSjN82waEz9Onv01p72tKc97WnP13jCzckt0LI3nbDVF1vaKkR1A7YRqQiLxtSvc%2FtpibomdoOtvtjSViEavWmGRWPq17nRm7omdoOtvtjSViEavWmGRWPq17nRm7omdoOtvtjSViEavWmGRWPq1zl6Ic6Cu7fPbegNnY5VfKBLzNz8KUHVmtgLKX8YHiujpS9pELTFDrPmUK5igfiYt6xauC1wbiE%2BaYk4P6nsxgBezwg4gcFJY9VOZkr0%2BRrNUodybQt%2BdFIuxIm5ylKVOgPQq5DjVNU9qjqS7nvbMntzZ8q6w4fxKbVp4FtZBg2e8QqbXd%2FEvmj0NiPtLGPkAMSbdQKdH%2BErS9haRFuSHFSDPyg33YB7HKnMtpiDbJ%2FnJxBRFHWkciX1eJTQG3liJ9%2F94dSdTuiy7ts9Uvnz5eH%2BZdiU3kRyybVNRrwB0VUvAdkLjd4ouLNt6fs4UrO3FQJdpcJrdPALjsZq3Riw44U4q1Dg81wVSVTpjHwgvdEvMdudhuuA%2BO1mL8T5fHmYU8wNrzNle18xexsBTb0MY579pY50XQcPRPfbQQXQJeXgloFlUjsL%2B1TobgLitPPbordL7j2isdEvEEilfCm1sLcvLzgaq5S98XpGUP5dALgxIMfD%2FctLudSbspVfZZZIShMYUQpPTyZVeIx31tk2yN78uiO7Ed2rT2%2FFHlUdIr19PHZT9vbj7b57%2FtiE3vA8v3yUe6pq3nLy4l0gvK4JuCFOXtWGCoSXlIM6S%2FAHt93DGXDKelEtokxuX5Qiqu1i1Fr0ViBw9KnxVRa9Bd4O5aAZAq2YmKk%2BwKH0RgWI7OEp%2FozV5WwVvCD7KXyUEp7kjpwrHLFrCb25oQ8mAULty3yhKeqffCFOyX6AEXoDT%2FGVb%2FHsLZjnw%2FcZKNqczLM%2F04RPlcTwigXA4s%2F5q3Db%2FdWLsUit7L4ohawtdJgyeptW8TCXLhF4Lcj5GG%2Bn0kBY3XuPkj%2BEQ%2BmN8n%2FSn6NvnDCUgQVGhzoEVcIAZD6CNkoPT7lwtjFTNieBnnT25uvEZXic2EydG73NAFvBnnsUmSQ93jYK6eHUdXT2FiuAZ6fE4I%2FWKu2LNgjahg6z%2Bru3FQKn6jBjl2sJ3u6WRrAAjBNGSRJCDO723Zvn%2F4X0BpK4aPbGVXHFsDQqbLLCUy7MgDemX5kbfan7IHcjCt3qd2%2FD61339P7r51%2B%2Ffr4%2Fb%2FWHAd76Yt4mLzRIRrw5r44ve%2BNNuClq9A7UUFBgIH%2Bc579iUkBnLP8NyBmCMpl90QopltjZJMoAVPQVCcQjkaQGakuUgz4XluEIrAFZPSPI2ywJ%2FJ%2BmLtw77M9kFOO%2BXIGtqHh09BZK8wNnHKGE8PTMyBfON6Y3rnC%2BjNCbZzqS9bD4OvRW6lHVEcnevj9N6exGPy25XsF3u7MndlwaHUPWcnKo%2Brc%2BS%2FIf7k%2F0fb%2FEzFLgcu77Hv3Z3aLRXEHYlpnFhrXoMnl90QlOW9JhmMFNordigWgk4rXktsBs6cCuwmMLNXkCrRgLQKqfpHr%2Bn7rxiP3ZswemN8pWqMrY43ldiaTBl3Al4grRaeVSnC9cYkygjrw3Q3cfrQI8T5G%2Fe5Nm4OoeVR3t1JIjmjh4TTPha9BbQyKqG3DbETl2V2t3WHRv%2FTo3ejuiiUZv%2BbClrUJYoDeYzSqIkB1h0b3169zoTV0Tu8FWX2xpqxAW6O12YdGY%2BnUO6e3bBmj0phO2%2BmJLW4Vo9KYZFo2pX2eP3n7bDI3eFMJWX2xpqxCN3jTDojH16%2BzRW3va0572tKc9X%2BMJNye3QMvedMJWX2xpqxDVDdhGpCIsGlO%2Fzu2nJeqa2A22%2BmJLW4Vo9KYZFo2pX%2BdGb%2Bqa2A22%2BmJLW4Vo9KYZFo2pX%2BdGb%2Bqa2A22%2BmJLW4Vo9KYZFo2pX%2BcYvX08Tn9kOR0%2BuQG9%2BYdyXVcc6CK0gmVucxDRXkj5w%2FBYGS19SUONwU09UrlMIHLkvFq4LXBuIT5piTg%2FqezGAF7PCDiBwUlj1U5mSvT5Gs1Sh3JtC350Ui7EibnKUpU6A9CrkONU1T2qOmR6e3%2Fupmvevj8VHjuZcKSyO6bNPwQ%2F77Djq3wgZOpxt4VN7I1GbzPSBneJWnwMYehihQLdwX74yhK2FtGWJAfV4A%2FKTTfgHkcqsy3mINvn%2BQlEFEUdqVxJPcddN4kAAA3MSURBVB4l9Eae2Ml3fzh1pxO6rPt2j1R215lutjmJz%2FwGyLVNynztjj%2Fd5BKQvdDojUJscFOztxUCXaXCa3TwC47Gat0YsOOFOKtQ4PNcFUlU6Yx8IL3RLzHbnYbrgPitXYizGb2JCVq17A3LJJc%2Ba5ogDkT3paMC6JJycMvAMqmdhX0qdDcBcdr5bdFbdHBz6a1AIJXypdTC3r684GisUvZWPRZCPWfJYYBke7h%2FeSmXelO28qvMEklpAiNK4enJpAqP8c462wbZm193ZDeie%2FXprdijqiNCbw9Pjw%2FjMG3z3Rs5zy8f5Z6qGp0BF5m1QxpuiJNXtaEC4XVzoM4S%2FMFt93AGnLJeVIsok9sXpagxuHn0ViBwnNbGV1n0Fng7lIMcFK2YmKk%2BwKH0RgWI7OEp%2FozV5WwVvCD7KXyUEp6uCFk4YtcSenNDH0wChNqX%2BUJT1D%2F5QpyS%2FQAz9DZvTv54u5%2B%2BhKufvQXzfPg%2BA3K8QZm1Q3pyCmLDGUQpWwAs%2Fpy%2FCrfdX70Yi9TK7otS1Bhcid6mVTzMpUsEXgtyPsbbqTQQVvfeo%2BQP4VB6o%2Fyf9OfoGycMZWCB0aEOQZUwAJmPoI3Sw1MunG3MlM1JoCedvfk6cRkeJzZTZxv09uvjcfk5yfB6t8lPS8BWsOceRSYR4i2Uuc33DcOp6%2BjsLVYAz06JwR%2BtVdoXbagxuKnZ2wqBU3WYscu1BG93SyNYAMYJoyQJIQZ3%2B%2B7N8%2F9CegNJXDR746q4YlgaFTZZ4SkXZsAb06%2FMjb7UfZC7EYVu9bu3Xz%2Ffn7vH71tmb8H6Yt4mLzSIZG7W4fKWF3QTbooapfnD6%2B1OXM59fx7IH%2Bf5r5gU0BnLfwNyhqBMZl%2B0osbgptFbkUA8EklqoLZEOehzYRmOwBqwbiyQ%2BmD%2Fp6kL9w77Mwouui9XYCsqHh29hdL8wBlHKCE8PTPyhfON6Y0rnC8j9OaZjmQ9LL4OvZV6VHWo%2B7u34K8xsmzDtULKHKr%2Brc%2BS%2FIf7E33fLzGzFLic%2B773KnhqzhWEbZlZbFiLLpPXF52oMbhJ9FYsEI1EvJbcFpgtHdhVeGx%2FUp5AK8YCkBr%2FaUl04xH7s2cPTG%2BUrVCVscfzuhJJgy%2FhSsQVotPKpThfuMSYQB15b4buPloFeJ4if%2FcmzcDVPao62qklRzRx8Jpmwtegt4ZEVDfgtiNy7K7W7rDo3vp1bvR2RBON3vJhS1uFsEBvMJtVECE7wqJ769e50Zu6JnaDrb7Y0lYhLNDb7cKiMfXrHNLbtw3Q6E0nbPXFlrYK0ehNMywaU7%2FOHr39thkavSmErb7Y0lYhGr1phkVj6tfZo7f2tKc97WlPe77GE25OboGWvemErb7Y0lYhqhuwjUhFWDSmfp3bT0vUNbEbbPXFlrYK0ehNMywaU7%2FOjd7UNbEbbPXFlrYK0ehNMywaU7%2FOjd7UNbEbbPXFlrYK0ehNMywaU7%2FOsRsDPIznT9amN%2F9QruuKA12EVpJPaSpvYlek%2FGF4rIyWvqQha3DXHMpVLBA5cl4t3BY4txCftEScn1R2YwCvZwScwOCksWonMyX6fI1mqUO5tgU%2FOikX4sRcZalKnQHoVchxquoeVR3J2dvny0PRsZMJRyq7Y9r8Q%2FAjZ%2BhhcK1QMpdhbPRmAxmDS5zoioebdYBCge5gP3xlCVuLaEuSg2rwB%2BWmG3CPI5XZFnOQ7fP8BCKKoo5UrqQejxJ6I0%2Fs5Ls%2FnLrTCV3WfdNHKs%2FP96e7t88NNifxmd8AubZJma%2Bl07IrNbEHGr1RcGfb0vdxpGZvKwS6SoXX6OAXHI3VujFgxwtxVqHA57kqkqjSGflAeqNfYrY7DdcB8dvtXogDUrfpXtPK9CYmaNWyN15mNXojDkRfPqBvDECXlINbBpZJ7SzsU6G7CYjTzm%2BL3i6594jGHKBAIJXyJS2qkLfDjQaSxiplb7yeEWTRG3djQI6H%2B5eXcqk3ZSu%2FyiyRlCYwohSenkyq8BjvrLNtkL35dUd2I7pXn96KPao6kuhteL0ru%2Bwthd7wPL98lHuqanQGRDJr0RvcECevakMFwkvKQZ0l%2BIPb7uEMOGW9qBZRJrcvSpE%2BuLXorUDgOK2Nr7LoLfBMKAfNEGjFxEz1AQ6lNypAZA9P8WesLmer4AXZT%2BGjlPAkd%2BRc4YhdS%2BjNDX0wCRBqX%2BYLTVH%2F5AtxSvYDbNHbcqnpNtlbMM%2BH7zMgxxslsxa9TU5BbDiDKGULgMWf81fhtvurF2ORWtl9UYr0wS2jt2kVD3PpEoHXgpyP8XYqDYTVvfco%2BUM4lN4o%2Fyf9OfrGCUMZWGB0qENQJQxA5iNoo%2FTwlAtnGzNlcxLoSS%2FffZ2EJf6tZW%2FD693D648ybovSG9wK9tyjyCRCvDEyK3%2F3Npy6js7eYgXw7JQY%2FNFapX3RhozBXf3d2wqBU3WYscu1BG93SyNYAMYJoyQJIQZ3%2B%2B7N8%2F9CegNJXDR746q4YlgaFTZZ4SkXZsAb06%2FMjb7UfZC7EYVu%2Bru3H2%2F3hT8qSaI3f30xb5MXGkQyNy2zEr25KWr0Dn94vd2Jy7nvzwP54zz%2FFZMCOmP5b0DOEJTJ7ItWZAyuM12UASgHKBKIRyJJDdSWKAd9LizDEVgDsnpGkEFv2P9p6sK9w%2F6MgovuyxXYiopHR2%2BhND9wxhFKCE%2FPjHzhfGN64wrnywi9eaYjWQ%2BLr0NvpR5VHTF6%2B3jsiv4eIJnewj%2FzGU5BYp9hG64VXuY2Py2BewF93y8xsxS4nPu%2B70NtFjXnCsK2zCw2rEWXyeuLTmQN7kD%2F2U0SvRULRCMRryW3BWZLB3YVHtuflCdQSs8IsrI35P%2BpG4%2FYnz17YHqjbIWqjD2e15VIGnwJVyKuEJ1WLsX5wiXGBOrIezN099EqwPMU%2Bbs3aQau7lHV0U4tOaKJg9c0E74GvTUkoroBtx2RY3e1dodF99avc6O3I5po9JYPW9oqhAV6g9msggjZERbdW7%2FOjd7UNbEbbPXFlrYKYYHebhcWjalf55Devm2ARm86YasvtrRViEZvmmHRmPp19ujtt83Q6E0hbPXFlrYK0ehNMywaU7%2FOHr21pz3taU972vM1nnBzcgu07E0nbPXFlrYKUd2AbUQqwqIx9evcflqirondYKsvtrRViEZvmmHRmPp1bvSmrondYKsvtrRViEZvmmHRmPp1bvSmrondYKsvtrRViEZvmmHRmPp1jtDb8Ho3%2Fo1l8anKuYdyXVcc6CK0gmWiZtc2sStS%2FjA8VkZLX9JQNrgFh3IVC8QelVWL9UzhUC7%2FKSyGwN4PSPgBAYnjVU7mSnR52s0Sx3KtS340Um5ECfmKktV6gxAr0KOU1X3qOoQ6e3z5WG6Cuf9udvmtm5wpqw7fBifUpsGrhVCpjuGLe%2FwHy2U0OhtRtpZxkvU4mMIw9EvFIg9KqFWkmcmHqlcPNw7HKnMtpiDbJ%2FnJxBRFHWkciX1eJTQG3liJ9%2F94dSdTuiy7ts9Uhlc0v39qSu70TR6IY5w%2BE6ubVLmaySzbkjvhUZvFNzZtvR9HKnZ2wqBrlLhNTr4BUdjtW4M2PFCnFUo8HmuiiSqdEY%2BkN7ol5jtTsN1QPx2uxfiLLfhlN9oGr%2FOlO19texNkpnZiNSRruvggejLB%2FSNAeiScnDLwDKpnYV9KnQ3AXHa%2BW3R2yX3HtFY9BUIpFK%2BlFqCZ3I0Vil74%2FWMIIveuBsDcjzcv7yUS70pW%2FlVZomkNIERpfD0ZFKFx3hnnW2D7M2vO7Ib0b369FbsUdUR%2B2nJ58tD13WlO5Mp9Ibn%2BeWj3FNVozNgIHN0whoMCjfEyavaUIHwknJQZwn%2B4LZ7OANOWS%2BqRZTJ7YtSpA9uLXorEAg9KoveJM8MZwi0YmKm%2BgCH0hsVILKHp%2FgzVpezVfCC7KfwUUp4uiJk4YhdS%2BjNDX0wCRBqX%2BYLTVH%2F5AtxSvYDjNCb25wsv9Q0nr0F83z4PgNyvDEy89I3ponJKYgNZxClbAGw%2BHP%2BKtx2f%2FViLFIruy9KkT64ZfQ2reJhLl0i8FqQ80U8Myl7i7vxofRG%2BT%2Fpz9E3ThjKwAKjQx2CKmEAMh9BG6WHp1w425gpm5NATzp783XiMjxObKbONuhteL1bfjAJ%2F12R3uBWsOceRSYR4k2QWTGkh1PX0dlbrACenRKDP1qrtC%2FakDG4q797WyFwqg4zdrlW3DODcYRxwihJQojB3b578%2Fy%2FkN5AEhfN3rgqrhiWRoVNVnjKhRnwxvQrc6MvdR%2FkbkShm%2F3u7eOxc9nbNj8t8dcX8zZ5oUEkc7PfuNXI3twUNXqHP7ze7sTl3Pfngfxxnv%2BKSQGdsfw3IGcIymT2RSvSB9ffkpEZgIq%2BIoGER6WokeKZXJbGLtVpsAZk9Ywgg96w%2F9PUhXuH%2FRkFF92XK7AVFY%2BO3kJpfuCMI5QQnp4Z%2BcL5xvTGFc6XEXrzTEeyHhZfh95KPao6It%2B9fX%2Ba89mn9wJuS6C38M98gr%2FGyLIN1wopc3lZpYkl%2BQ%2F3J%2Fq%2BX2JmKXA5933fh837GpF5mJPSg%2Fj0BRFl8vqiE2WD60%2F4SfRWLBB7VLRWkmf6G0vsKjy2UJMnUErPCLKyN%2BT%2FqRuP2J89e2B6o2yFqow9nteVSBp8CVcirhCdVi7F%2BcIlxgTqyHszdPfRKsDzFPm7N2l6rO5R1dFOLTmiiYPXNBO%2BBr01JKK6AbcdkWN3tXaHRffWr%2FP%2FAz6hUhNIRLh%2FAAAAAElFTkSuQmCC&refer=http%3A%2F%2Fwww.cnblogs.com%2Flori%2Fp%2F3303550.html" class="lazy" alt="知方可补不足~sqlserver中使用sp" ><br>

下面对status执行状态作一个简单的说明，选自MSDN

background：会话正在运行一个后台任务，例如死锁检测。

rollback： 会话具有正在处理的事务回滚。

pending： 会话正在等待工作线程变为可用。

runnable： 会话的任务在等待获取时间量程时位于计划程序的可运行队列中。

spinloop： 会话的任务正在等待调节锁变为可用。

suspended： 会话正在等待事件（如 I/O）完成。

注意：如果你的代码处理数据比较大，SQL会创建子线程进行并行处理，子线程的标示为ecid。

别外，如果希望查看SQL进程的详细信息，可以使用下面代码

SELECT * FROM sys.sysprocesses

查看被锁住的对象，可以使用下面代码

SELECT * FROM sys.syslockinfo

 如果希望查看指定会话（SQL进程）的语句（从客户端发过来的SQL语句），可以使用下面语句

dbcc inputbuffer(Session_ID)

如果希望查看正在被阻塞的语句（sysprocesses的blocked），可以使用下面语句

dbcc inputbuffer(Blocked)

 

回到目录