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:
- 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.
- 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.
- Nika iziqinisekiso zokungena ngemvume futhi, uma ukhuthazwa ukuba wenze kanjalo.
- I-SQL Server Profiler iqala ukuthi ufuna ukuqala umkhondo omusha bese uvula iwindi le- Properties window. Ifasitela ingenalutho ukuvumela ukuthi ucacise imininingwane yomkhondo.
- Dala igama elichazayo lomkhondo bese ulifake ebhokisini lombhalo we- Trace Name .
- 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.
- 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.
- 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 .
- 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:
- Ithempulethi ejwayelekile, eqoqa imininingwane ehlukahlukene mayelana nokuxhumana kwe-SQL Server, izinqubo ezigcinwe, nezitatimende ze-Transact-SQL
- Ithempulethi yokuThuthukisa, eqoqa imininingwane engasetshenziswa ne-Database Engine Tuning Advisor ukuze ihlole ukusebenza kwakho kwe-SQL Server
- Ithempulethi ye-TSQL_Replay, eqoqa ulwazi olwanele mayelana nesitatimende ngasinye se-Transact-SQL sokuvuselela umsebenzi esikhathini esizayo
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 .