Imizila ikuvumela ukuba ulandelele izenzo ezithile ezenziwe kwi-SQL Server database. Banikela ngolwazi olubalulekileyo malunga neengxaki zeenkcukacha zeenkcukacha kunye nokulungiswa komsebenzi wenjini. Kule tutorial, sihamba kwinkqubo yokudala i-SQL Server Trace kunye ne-SQL Server Profiler, isinyathelo-nge-nyathelo.
Qaphela : Eli nqaku liyabasebenzisi be-SQL Server 2008 nangaphambili. Ukuba usebenzisa i- SQL Server 2012 , funda enye inqaku lethu ekudaleni umkhondo ngeSQL Server 2012 .
Indlela yokudala umkhondo nge-SQL Server Profiler
- Vula iSkrini soLawulo lweSquL yeService ngokuyikhetha kwimenyu yokuqala.
- Ukusuka kwimenyu yeThuluzi, khetha iSQL Server Profiler.
- Xa i-SQL Server Profiler ivula, khetha iNew Trace kwimenyu yeFayile.
- I-SQL Server Profiler iya kukucela ukuba uxhumeke kwimeko ye SQL Server ofuna ukuba iphrofayili. Nika iinkcukacha zoqhagamshelwano kwaye nqakraza iqhosha lokuxhuma ukuze uqhubeke.
- Yakha igama elichazayo lomkhondo wakho kwaye ulifake kwi "Igama lomkhondo" ibhokisi leencwadi.
- Khetha ithemplate yakho yomkhondo kwimenyu ehlayo. (Jonga iiNgcebiso zeSetekethi ngaphantsi ngolwazi malunga nezinye iifomati zengqondo ezisetyenziswa ngokuqhelekileyo)
- Khetha Gcina kwiFayile ukugcina ulandelelwano lwakho kwifayili kwi-drive yendawo yangoku. Nika igama lefayile kunye nendawo kwi-Save njenge window ephumayo ngenxa yokuchofoza ibhokisi yokukhangela.
- Cofa kwiTebhe yoKhetho lweZenzo ukuhlaziya iziganeko ongazibeka esweni ngokulandelelana kwakho. Ezinye iziganeko ziya kukhethwa ngokuzenzekelayo ngokusekelwe kwithempulethi oyikhethile. Unokuguqula ezo zikhetho ezikhethiweyo ngeli xesha. Unokujonga iinketho ezongezelelweyo ngokuchofoza i-Show All Events kwaye Bonisa zonke iibhokisi zokuhlola zekholomu.
- Cofa iqhosha laseKhaya ukuqala umkhondo wakho. I-SQL Server iya kuqala ukudala umkhondo, ukubonelela iinkcukacha njengoko kuboniswe kumfanekiso. (Unokuqhafaza umfanekiso ukuze ukwandise.) Xa usugqibile, khetha "Yeka Umkhondo" kwimenyu yeFayile.
Iingcebiso zeSetekethi
- Ithemplate ye-Standard iqokelela iinkcukacha ezahlukeneyo malunga noxhumano lweSQL Server, iinkqubo ezigcinwe kunye neengxelo ze-Transact-SQL.
- Ithemplate yeTuning iqokelela ulwazi olungasetyenziselwa nguMcebisi we-Intanethi yokuThunywa kweeNjini zokuThuthukisa ukusebenza kwakho kweSQL Server.
- Ithemplate ye-TSQL_Replay ibutha ulwazi olwaneleyo malunga nesitatimende ngasinye seTransact-SQL ukuphinda uphinde wenze umsebenzi kwixesha elizayo.