Ukudala Umkhondo Nge-SQL Server 2012

Ukusebenzisa i-SQL Server Profiler ukulandelela izinkinga zokusebenza kwedatha

I-SQL Server Profiler iyithuluzi lokuxilonga elifakwe ne-Microsoft SQL Server 2012. Ikuvumela ukuthi udale amathrekhi we-SQL olandelela izenzo ezithile ezenzelwe imininingwane ye-SQL Server. Imidwebo ye-SQL inikeza ulwazi olubalulekile lokuxazulula izinkinga zezinkinga ze- database kanye nokulungiswa kwe-engine engine ukusebenza. Isibonelo, abalawuli bangase basebenzise umkhondo ukukhomba umgogodla kumbuzo bese uthuthukisa ukulungiswa ukuze kuthuthukiswe ukusebenza kwedatha.

Ukwakha Trace

Inqubo yesinyathelo ngesinyathelo sokudala i-SQL Server Trace ne-SQL Server Profiler kanje:

  1. Vula iSystem Management Studio Studio bese uxhuma kusibonelo se-SQL Server ozikhethelayo. Nikeza igama leseva kanye nokufaka ngemvume kokungena ngemvume okufanele ngaphandle kokuthi usebenzisa i-Windows Authentication.
  2. Ngemuva kokuthi uvule SQL Server Management Studio, khetha iSQL Server Profiler kusuka kumenyu yamathuluzi . Qaphela ukuthi uma ungahle uhlele ukusebenzisa amanye amathuluzi we-SQL Server kule nkathi yokuphatha, ungakhetha ukuqala i-SQL Profiler ngokuqondile, kunokuba uhambe nge-Studio Studio.
  3. Nika iziqinisekiso zokungena ngemvume futhi, uma ukhuthazwa ukuba wenze kanjalo.
  4. I-SQL Server Profiler iqala ukuthi ufuna ukuqala umkhondo omusha bese uvula iwindi le- Properties window. Ifasitela ingenalutho ukuvumela ukuthi ucacise imininingwane yomkhondo.
  5. Dala igama elichazayo lomkhondo bese ulifake ebhokisini lombhalo we- Trace Name .
  6. Khetha ithempulethi yomkhondo kusuka kusetshenziswa Imenyu yokuhlaziya ye-Template . Lokhu kukuvumela ukuba uqale umkhondo wakho usebenzisa esinye sezifanekiso ezichazwe ngaphambilini ezigcinwe kulabhulali ye-SQL Server.
  7. Khetha indawo ukugcina imiphumela yomkhondo wakho. Unezinketho ezimbili lapha:
    • Khetha Gcina kufayela ukuze ulondoloze umkhondo kwifayela kwi-hard drive yendawo. Nikeza igama lefayela kanye nendawo ku-Save njengewindi evulekayo ngenxa yokuchofoza ibhokisi lokuhlola. Ungasetha futhi usayizi ophezulu wefayela ku-MB ukuze unciphise umthelela ongase ube nawo ekusebenziseni disk.
    • Khetha Gcina kuThebula ukuze ulondoloze umkhondo etafuleni ngaphakathi kwedatha ye-SQL Server. Uma ukhetha le nketho, uyacelwa ukuxhuma ku-database lapho ufuna ukugcina imiphumela yomkhondo. Ungakwazi futhi ukusetha ubungako bokulandelela-ezinkulungwaneni zemigqa yetafula-ukukhawulela umthelela ongase ube nawo ku-database yakho.
  1. Chofoza kuthebhu Yokukhetha Yezehlakalo ukuze ubuyekeze imicimbi ozoyiqapha ngomkhondo wakho. Ezinye izenzakalo zikhethiwe ngokuzenzekela ngokusekelwe kuthempulethi oyikhethile. Ungashintsha lezo zikhetho ezizenzakalelayo ngalesi sikhathi bese ubheka izinketho ezengeziwe ngokuchofoza ku- Bonisa Zonke Imicimbi bese ubonisa amabhokisi amasheya onke ekhombisa Amakholomu .
  2. Chofoza inkinobho yokuqalisa ukuqala ukulandelela. Uma usuqedile, khetha u- Stop Trace kusuka kwimenyu yefayela .

Ukukhetha Isifanekiso

Uma uqala ukulandelela, ungakhetha ukukusekela kunoma yimaphi ama-templates atholakala kulabhulali yomkhondo we-SQL Server. Izifanekiso ezintathu ezisetshenziselwa ukulandelana kakhulu ziyi:

Qaphela : Lesi sihloko sibheka i-SQL Server Profiler ye-SQL Server 2012. Ukuze uthole izinguqulo zangaphambilini, bheka Indlela Yokudala Umkhondo nge-SQL Server Profiler 2008 .