Yadda za a ƙirƙirar Trace tare da Profiler a cikin SQL Server 2008

Harkuna ya ba ka damar yin waƙa da takamaiman ayyukan da aka yi akan SQL Server database. Suna samar da bayanai mai mahimmanci don magance matsalolin al'amurran bayanai da kuma sauya aikin injiniyar bayanai. A cikin wannan koyo, muna tafiya ta hanyar aiwatar da SQL Server Trace tare da SQL Server Profiler, mataki-by-mataki.

Lura : Wannan labarin shine ga masu amfani da SQL Server 2008 da kuma a baya. Idan kana amfani da SQL Server 2012 , karanta wani labarinmu akan samar da alamu tare da SQL Server 2012 .

Yadda za a ƙirƙiri wani fasali tare da SQL Server Profiler

1. Bude Gidan Gidan Ayyukan Sadarwar Sadarwar ta hanyar zaɓar shi daga menu Fara.
2. Daga Tools menu, zabi SQL Server Profiler.
3. A lokacin da SQL Server Profiler ya buɗe, zaɓi Sabon Trace daga Fayil din menu.
4. SQL Server Profiler zai tozakar da ku don haɗi zuwa misalin SQL Server da kuke so don bayanin ku. Samar da cikakkun bayanai kuma danna maɓallin Haɗi don ci gaba.
5. Ƙirƙiri sunan da aka kwatanta don ganoka kuma rubuta shi a cikin "Sakon" sunan akwatin rubutu.
6. Zaɓi samfurin don alama daga menu mai saukewa. (Dubi Template Tips da ke ƙasa don bayani game da wasu samfurori da aka yi amfani dashi)
7. Zaɓi Ajiye zuwa Fayil don adana hanyarka zuwa fayil a kan rumbun kwamfutarka. Samar da sunan fayil da wuri a cikin Ajiyayyen As taga wanda ya tashi saboda sakamakon danna akwati.
8. Danna kan Zaɓin Zaɓuɓɓukan Events don duba abubuwan da za ku iya saka idanu tare da alamarku. Wasu abubuwa za a zaɓa ta atomatik bisa ga samfurin da ka zaba. Kuna iya canza wadanda aka zaɓa a wannan lokaci. Kuna iya duba ƙarin zaɓuɓɓuka ta danna kan abubuwan da ke faruwa a Show All Events da Nuna Dukkanin akwatunan ginshiƙai.

1. Danna maɓallin Run don fara bayaninka. SQL Server zai fara samar da alama, bada cikakkun bayanai kamar yadda aka nuna a cikin hoton. (Za ka iya danna kan hoton don karaɗa shi.) Lokacin da ka gama, zaɓi "Tsaida Tsaya" daga Fayil din menu.

Shafin samfuri

1. A samfurin Template ya tattara nau'o'in bayani game da haɗin SQL Server, hanyoyin da aka adana, da ƙididdiga Transact-SQL.
2. Tunanin Tuning yana tattara bayanai da za a iya amfani dashi tare da Mashawarcin Tuntuɓa na Masarrafar Intanit don yaɗa aikin SQL Server.
3. Tsarin TSQL_Replay ya tara cikakken bayani game da kowane bayanin Transact-SQL don sake yin aikin a nan gaba.