Imikhawulo ikuvumela ukuba ulandele izenzo ezithile ezenzelwe imininingwane ye-SQL Server. Banikeza ulwazi olubalulekile ekuxazululeni izinkinga ze-database kanye nokulungiswa kwe-engine engine ukusebenza. Kulesi sifundo, sihamba ngenqubo yokudala i-SQL Server Trace nge-SQL Server Profiler, ngesinyathelo ngesinyathelo.
Qaphela : Lesi sihloko singabasebenzisi be-SQL Server 2008 nangaphambilini. Uma usebenzisa i- SQL Server 2012 , funda esinye isihloko sakho ekudaleni imidwebo nge-SQL Server 2012 .
Indlela Yakha Umkhondo Nge-SQL Server Profiler
- Vula Is Studio Studio SQL Server ngokuyikhetha kusukela Imenyu Qala.
- Kusukela kumenyu yamaThuluzi, khetha iSQL Server Profiler.
- Uma i-SQL Server Profiler ivula, khetha u-New Trace kusuka kwimenyu yefayela.
- I-SQL Server Profiler izokukugqugquzela ukuthi uxhumeke kusibonelo se-SQL Server oyifisa kuphrofayela. Nikeza imininingwane yokuxhumana bese uchofoza inkinobho ye-Connect ukuze uqhubeke.
- Dala igama elichazayo lomkhondo wakho bese ulifakela ebhokisini lemibuzo "Igama lomkhondo".
- Khetha ithempulethi yomkhondo wakho kusuka kumenyu yokudonsa. (Bheka Amathiphu Ethempulethi ngezansi ukuze uthole ulwazi kwezinye izifanekiso ezithandwayo ngokuvamile)
- Khetha Gcina kufayela ukuze ulondoloze umkhondo wakho kwifayela kwi-hard drive yendawo. Nikeza igama lefayela kanye nendawo ku-Save njengewindi evulekayo ngenxa yokuchofoza ibhokisi lokuhlola.
- Chofoza kuthebhu yokukhetha yezenzakalo ukuze ubuyekeze imicimbi ongayibona ngokulandelela kwakho. Ezinye izenzakalo zizokhethwa ngokuzenzekelayo ngokusekelwe kuthempulethi oyikhethile. Ungashintsha lezo zikhetho ezizenzakalelayo ngalesi sikhathi. Ungabuka izinketho ezengeziwe ngokuchofoza okuthi Bonisa Zonke Izenzakalo bese ubonisa ibhokisi lokuhlola lamakholomu.
- Chofoza inkinobho yokuqalisa ukuqala umkhondo wakho. I-SQL Server izoqala ukudala umkhondo, inikeze imininingwane njengoba kuboniswe esithombeni. (Ungase uchofoze esithombeni ukuze ukwandise.) Uma usuqedile, khetha "Misa ukulandelela" kusuka kwimenyu yefayela.
Amathiphu wesifanekiso
- Ithempulethi ejwayelekile iqoqa imininingwane ehlukahlukene mayelana nokuxhumana kwe-SQL Server, izinqubo ezigcinwe, nezitatimende ze-Transact-SQL.
- Ithempulethi yokuThuthukisa iqoqa ulwazi olungasetshenziswa ne-Database Engine Tuning Advisor ukuhlola ukusebenza kwakho kwe-SQL Server.
- Ithempulethi ye-TSQL_Replay iqoqa ulwazi olwanele mayelana nesitatimende ngasinye se-Transact-SQL sokuvuselela lo msebenzi esikhathini esizayo.