Ukudala iNkqubo ngeSQL Server 2012

Ukusebenzisa i-SQL Server Profiler ukuPhatha imiba yokuSebenza kweDatabase

I-SQL Server Profiler isixhobo sokuxilonga esifakwe kwi-Microsoft SQL Server 2012. Kukuvumela ukuba wenze impawu ze-SQL ezilandelelanisa izenzo ezithile ezenziwe kwi-SQL Server database. Iimpawu ze-SQL zinika ulwazi oluxabisekileyo kwiinkcukacha zeenkcukacha zeengxaki kunye nokulungiswa kweenjini zenjini. Ngokomzekelo, abalawuli bangasebenzisa umkhondo ukuchonga isikhombululo kwindawo yokubuza nokuphucula ukuphucula ukuphucula ukusebenza kweenkcukacha.

Ukudala Umkhondo

Inkqubo yenyathelo-nge-nyathelo yokudala i-SQL Server Trace kunye ne-SQL Server Profiler yile ndlela ilandelayo:

1. Vula iSkripthi yeSilawuli soLawulo lweSQL kwaye udibanise kumzekelo we-SQL Server ozikhethile. Nika igama lomncedisi kunye neenkcukacha zokungena ngemvume ezifanelekileyo ngaphandle kokuba usebenzisa iWindows Authentication.
2. Emva kokuba uvula iSquL Server Management Studio, khetha iSQL Server Profiler esuka kwimenyu yamathuluzi. Qaphela ukuba ukuba awuyi kuceba ukusebenzisa ezinye izixhobo ze-SQL Server kule seshoni yolawulo, ungakhetha ukwandisa i-SQL Profiler ngokuthe ngqo, kunokuba ungene kwi-Studio Studio.
3. Ukubonelela ngeenkcukacha zokungena ngemvume kwakhona, ukuba unyanzelekile ukuba wenze njalo.
4. I-SQL Server Profiler ithatha ukuba ufuna ukuqala umkhondo omtsha kwaye uvule iWindows Properties window. Ifestile ayinanto yokukuvumela ukuba uchaze iinkcukacha zengcaciso.
5. Yakha igama elichazayo lomkhondo uze ulifake kwibhokisi yombhalo we- Trace Name .
6. Khetha itemplate yoluhlu ukusuka kwi-Imenyu yokuhlaselwa kweTemplate. Oku kukuvumela ukuba uqale ulandelelwano lwakho usebenzisa enye yezifanekiso ezilungiselelwe ezigcinwe kwilayibrari ye-SQL Server.
7. Khetha indawo ukugcina iziphumo zomkhondo wakho. Unokukhetha ezimbini apha:
   • Khetha Gcina kwiFayile ukugcina ulandelelwano kwifayili kwi-drive yendawo yangoku. Nika igama lefayile kunye nendawo kwi-Save njenge window ephumayo ngenxa yokuchofoza ibhokisi yokutshekisha. Ungakwazi kwakhona ukubeka ubungakanani befayili enkulu kwi-MB ukukhawulela umphumo onokuthi ube nawo kwi disk usetyenziso.
   • Khetha Gcina kwiThebula ukuze ulondoloze umkhondo kwitheyibhile ngaphakathi kwenkcukacha yeSQL Server. Ukuba ukhetha olu khetho, uyacelwa ukuba uxhume kwi database apho ufuna ukugcina iziphumo zekhondo. Ungakwazi kwakhona ukubeka ubungakanani bokulandelela-ngamawaka emigca yeetafile-ukunciphisa impembelelo enokuthi ibe nayo kwi-database yakho.

1. Cofa kwiTebhe yoKhetho lweZenzo ukuphonononga iziganeko oza kubeka esweni ngokulandelelana kwakho. Ezinye iziganeko zikhethwa ngokuzenzekelayo ngokusekelwe kwithempulethi oyikhethile. Uyakwazi ukuguqula ezokhetho ezikhethiweyo ngeli xesha uze ubone iinketho ezongezelelweyo ngokuchofoza i- Show All Events kwaye Bonisa zonke iikholomu zitshekishe ibhokisi.
2. Cofa iqhosha laseKhaya ukuqala umkhondo. Xa ugqibile, khetha u- Stop Trace kwimenyu yeFayile .

Ukukhetha iSifanekiso

Xa uqala ulandelelwano, unokukhetha ukuyibeka kuyo nayiphi na iemplates ezitholakala kwilayibrari yokulandelela i-SQL Server. Ezi zithathu zeetemplates ezilandelwa kakhulu zilandelwa:

• Ithemplate ye-Standard, eqokelela iinkcukacha ezahlukeneyo malunga noxhumano lweSQL Server, iinkqubo ezigcinwe kunye neentetho ze-Transact-SQL
• Ithemplate yeTuning, eqokelela ulwazi olungasetyenziselwa nguMcebisi weNjini yeDrive yokuThumela ukuThumela ukusebenza kwakho kweSQL Server
• Ithemplate ye-TSQL_Replay, eqokelela ulwazi olwaneleyo malunga nesitatimende ngasinye seTransact-SQL ukuphinda uphinde wenze umsebenzi kwixesha elizayo

Qaphela : Eli nqaku lijongana ne-SQL Server Profiler ye-SQL Server 2012. Kwiinguqulo zangaphambili, funda njani Ukwenza Ulandelelwano nge-SQL Server Profiler 2008 .