Nguva pfupi yadarika, nekushamisika, ndakadzidza kuti mune rimwe remadhipatimendi ekambani hombe kwandinoshanda, hazvibvumidzwe kutanga. SQL profiler panguva dzebhizimisi.
Handizive kuti vanokwanisa sei kuongorora matambudziko ekuita anoitika panguva dzebhizinesi. Mushure mezvose, maonero ekuita kazhinji haape mufananidzo chaiwo, kunyanya kana imwe kana maviri maitiro / mibvunzo iri kuderera, pasina kunyanya kurodha sevha pachayo. Mubvunzo mudiki unomhanya kakawanda paawa uye unotora masekonzi gumi pachinzvimbo cheimwe (asi inoita zvakakosha zvikuru client kutya zvikuru) hazvizoperi muDMV maonero. Uye sarudza neCROSS APPLY zvichibva pane zvinyorwa zvemibvunzo pachayo inoremedza sevha zvakanyanya.
Zvisinei, ndinofarira kunzwisisa kuti kutya uku kunobva kupi. Mune mamwe makambani SQL profiler - chishandiso chekushanda, mune vamwe vaichitya semoto (kwenguva yakati ndanga ndichiita zvekubvunzana uye ndaigona kuenzanisa). Ndine chokwadi chekuti zvakafamba seizvi:
Houston, tine matambudziko. Hwaro hunononoka. Zviratidze
Kune zvikwekwe zvakawanda pano... Chii chandinoda?
Zvakanaka, ndichatarisa mabhokisi ese uye ndozofunga.
Chii chinoramba chiri mupfungwa dzevakuru vakuru? Pane akazvitanga SQL profiler uye zvinhu zvose zvakaungana sedanda. Uye vozozviudza kune mumwe nemumwe pamusoro pemutambo wegorofu.
Nenzira, kuedza kunyora kwakadaro 'tinonyora zvose' inotsvaga kwete kufaira, asi kune dhatabhesi pane imwechete server - ndakamboona nyaya yakadai.
Zvinhu zviri kufamba sei newe? Ndapota tora chikamu muongororo
Vashandisi vakanyoresa chete ndivo vanogona kutora chikamu muongororo.
Zvinoita here kumhanya SQL profiler paPROD?
-
Isu tiri kambani diki, zvese zviri nyore kwatiri
-
Production admins vanogona hangu
-
Production admins vanogona mushure mekubvumidzwa uye kurova misoro yavo
-
Mutsvene mutsvene mutsvene
4 vashandisi vakavhota. 3 vashandisi vakaramba.
Source: www.habr.com