Tsis ntev los no, nrog qee qhov kev xav tsis thoob, kuv tau kawm tias nyob rau hauv ib lub tuam tsev ntawm lub tuam txhab loj uas kuv ua haujlwm, lub community launch ntawm SQL Profiler thaum lub sijhawm ua haujlwm.
Kuv tsis paub yuav ua li cas lawv tawm los txheeb xyuas cov teeb meem kev ua haujlwm uas tshwm sim hauv cov sijhawm ua haujlwm xwb. Tom qab tag nrho, kev ua tau zoo saib feem ntau tsis muab cov duab meej, tshwj xeeb tshaj yog yog tias ib / ob txoj kev / cov lus nug qeeb, tsis tshwj xeeb tshaj yog thauj cov neeg rau zaub mov. Tiny Queer uas khiav ob peb zaug ib teev thiab khiav rau 10 vib nas this tsis yog ib qho (tab sis ua tseem ceeb heev tus neeg siv khoom ntshai heev) yuav tsis nkag mus rau hauv DMV views. Thiab xaiv nrog CROSS APPLY raws li cov ntawv ntawm cov lus nug nws tus kheej loads tus neeg rau zaub mov robustly.
Txawm li cas los xij, kuv xav nkag siab qhov kev ntshai no los ntawm qhov twg. Hauv qee lub tuam txhab SQL Profiler - cov cuab yeej ua haujlwm, qee qhov lawv ntshai nws, zoo li hluav taws (rau qee lub sijhawm kuv tau koom nrog kev sab laj thiab tuaj yeem sib piv). Kuv paub tseeb tias nws mus zoo li no:
Houston, peb muaj teeb meem. Lub hauv paus qeeb qeeb. xav txog nws
Muaj ntau zuam ntawm no⦠Kuv xav tau dab tsi?
Okay, Kuv yuav zuam tag nrho cov thawv thiab tom qab ntawd kuv mam li txiav txim siab.
Dab tsi tseem nyob hauv lub taub hau ntawm cov tub ceev xwm siab? Ib tug neeg launched SQL Profiler thiab txhua yam tau poob rau hauv qhov chaw. Thiab tom qab ntawd lawv qhia rau ib leeg dhau kev ua si ntawm golf.
Los ntawm txoj kev, sim sau cia xws li 'peb sau txhua yam' kab tsis mus rau ib cov ntaub ntawv, tab sis mus rau lub database ntawm tib neeg rau zaub mov - Kuv ib zaug pom cov ntaub ntawv no.
Thiab cov khoom zoo li cas nrog koj? Thov koom nrog hauv daim ntawv ntsuam xyuas
Tsuas yog cov neeg siv sau npe tuaj yeem koom nrog hauv daim ntawv ntsuam xyuas. thov.
Koj puas tuaj yeem khiav SQL profiler ntawm PROD?
-
Peb yog ib lub tuam txhab me me, txhua yam yooj yim rau peb
-
Production admins tau kawg
-
Cov neeg tsim khoom tuaj yeem, tom qab pom zoo thiab ntaus
-
dawb huv dawb huv
4 cov neeg siv pov npav. 3 cov neeg siv tau txwv.
Tau qhov twg los: www.hab.com