Mmene Mungakhalire ndi Tsatanetsatane Wopindulitsa mu SQL Server 2008

Zotsatira zimakulolani kuti muwone zochitika zomwe zikuchitika motsatira ndondomeko ya SQL Server. Amapereka chidziwitso chofunika kwambiri pa mavuto okhudzana ndi mavuto okhudzana ndi mavuto omwe ali nawo komanso momwe akugwirira ntchito. Mu phunziro ili, timayenda kudzera pakupanga SQL Server Trace ndi SQL Server Profiler, sitepe ndi sitepe.

Zindikirani : Nkhaniyi ndi ya ogwiritsa ntchito SQL Server 2008 ndi kale. Ngati mukugwiritsa ntchito SQL Server 2012 , werengani nkhani yathu yina popanga maulendo ndi SQL Server 2012 .

Mmene Mungapangire Tsatanetsatane ndi SQL Server Profiler

1. Tsegulani SQL Server Management Studio powisankha kuyambira payambidwe.
2. Kuchokera Zida zamkati, sankhani SQL Server Profiler.
3. Pamene SQL Server Profiler imatsegula, sankhani Zatsopano kuchokera ku Fayilo menu.
4. SQL Server Profiler adzakulimbikitsani kuti mugwirizane ndi SQL Server chitsanzo chomwe mumafuna kuti mumve. Perekani zowonjezera zowonjezera ndipo dinani Pulogalamuyi kuti mupitirize.
5. Pangani dzina lofotokozera lazomwe mukuzilemba ndikuliyika mu bokosi la malemba la "Trace Name".
6. Sankhani ndondomeko yanu kuchokera pa menyu otsika. (Onani Zothandizira Zachinyumba pansipa kuti mudziwe zambiri pazithunzi zomwe zimagwiritsidwa ntchito kawirikawiri)
7. Sankhani Kusindikiza Kuti muzisunga ndondomeko yanu pa fayilo pa hard drive. Perekani dzina la fayilo ndi malo mu Save monga zenera zomwe zikuwombera chifukwa cha kuwonekera kabokosi.
8. Dinani pazithunzi Zosankha za Zochitika kuti muwonenso zochitika zomwe mungayang'ane ndi ndondomeko yanu. Zochitika zina zidzasankhidwa mwachindunji malinga ndi zomwe mwasankha. Mungasinthe zosankha zosasintha panthawi ino. Mungawonenso zosankha zina mwa kuwonekera pa Zowonetsera Zonse ndi Zowonetsera Zonse za Ma Columns.

1. Dinani Bwerani Kuthamanga kuti muyambe kufufuza kwanu. SQL Server iyamba kuyambitsa tsatanetsatane, ndikupereka tsatanetsatane monga momwe asonyezedwera mu chithunzichi. (Mungasindikize pa chithunzi kuti mukulitse.) Mukamaliza, sankhani "Lekani Tsatanetsatane" kuchokera ku Fayilo menu.

Malangizo a Template

1. The template ya Standard imasonkhanitsa mauthenga osiyanasiyana okhudza kugwirizana kwa SQL Server, njira zosungidwa, ndi ndemanga za Transact-SQL.
2. Chithunzi cha Tuning chimasonkhanitsa mfundo zomwe zingagwiritsidwe ntchito ndi Advisor Database Tuning Advisor kuti awononge machitidwe anu a SQL Server.
3. Pulogalamu ya TSQL_Replay imasonkhanitsa zambiri zokwanira pa liwu lililonse la Transact-SQL kuti libwerenso ntchitoyo mtsogolomu.