Pogwiritsa ntchito SQL Server Profiler kuti ayang'ane Nkhani Zokambirana za Database
SQL Server Profiler ndi chida chozindikiritsa chomwe chinaphatikizidwa ndi Microsoft SQL Server 2012. Ichi chimakupatsani inu kupanga SQL tsatanetsatane kuti kufufuza zochita zinachitikira SQL Server database. Masalimo a SQL amapereka zambiri zofunika pa mavuto okhudzana ndi mavuto okhudzana ndi mavuto a mudothi komanso kugwiritsira ntchito magetsi a ntchito. Mwachitsanzo, olamulira angagwiritse ntchito tsatanetsatane kuti azindikire momwe mungayankhire pafunso ndikukonzekeretseratu zokhazokha kuti mugwirizane ndi ntchitoyi.
Kupanga Tsatanetsatane
Ndondomeko yowonjezera pakupanga SQL Server Trace ndi SQL Server Profiler ili motere:
- Tsegulani SQL Server Management Studio ndikugwiritsani ntchito SQL Server chitsanzo cha kusankha kwanu. Perekani dzina la seva ndi zovomerezeka zoyenera kulowa mulowepokha ngati mukugwiritsa ntchito Windows Authentication.
- Mutatsegula SQL Server Management Studio, sankhani SQL Server Profiler kuchokera ku Zida zamkati. Zindikirani kuti ngati simukukonzekera kugwiritsa ntchito zipangizo zina za SQL Server pa nthawiyi, mungasankhe kukhazikitsa SQL Profiler mwachindunji, m'malo modutsa mu Management Studio.
- Perekani zidziwitso zamalowanso, ngati mukulimbikitsidwa kuchita zimenezo.
- SQL Server Profiler amati mukufuna kuyamba tsatanetsatane ndi kutsegula zenera la Trace Properties . Fenera ilibe kanthu kuti ikuloleni kuti mudziwe tsatanetsatane wa tsatanetsatane.
- Pangani dzina lofotokozera la tsatanetsatane ndi kulilemba ilo mu bokosi la Trace Name .
- Sankhani kachipangizo kogwiritsa ntchito Masewera otsika pansi. Izi zimakuthandizani kuti muyambe kufufuza momwe mukugwiritsira ntchito maofesi omwe asungidwa kale mulaibulale ya SQL Server.
- Sankhani malo kuti muzisunga zotsatira zazomwe mumachita. Muli ndi njira ziwiri:
- Sankhani Kusindikiza Kuti muzisunga ndondomeko ku fayilo pa disk hard drive. Perekani dzina la fayilo ndi malo mu Save monga zenera zomwe zimatuluka chifukwa cha kubisa bokosi. Mukhozanso kukhazikitsa kukula kwa mafayilo mu MB kuti muchepetse zotsatira zomwe zingakhalepo pa disk ntchito.
- Sankhani Pulogalamuyi kuti musungire tsatanetsatane ku tebulo m'data la SQL Server. Ngati mutasankha njirayi, mumalimbikitsidwa kuti mugwirizane ndi malo omwe mukufuna kusunga zotsatira. Mukhozanso kukhazikitsa kukula kwapadera-mu zikwi za mizere ya tebulo - kuchepetsa zotsatira zomwe zingakhalepo pachinsinsi chanu.
- Dinani pazithunzi za Kusankhidwa kwa Zochitika kuti muwonenso zochitika zomwe mudzayang'ane ndi ndondomeko yanu. Zochitika zina zimasankhidwa mothandizidwa ndi chithunzi chomwe mwasankha. Mungasinthe zosankha zosasinthika panthawiyo ndikuwonanso zosankha zina powonjezera Zowonetsera Zonse ndi Zowonetsera Makalata Onse .
- Dinani batani Kuthamanga kuti muyambe kufufuza. Mukamaliza, sankhani Imani Kuchokera ku Fayilo menu.
Kusankha Chikhomo
Mukayamba tsatanetsatane, mungasankhe kukhazikitsira pazithunzi zilizonse zomwe zimapezeka mulaibulale ya SQL Server. Zithunzi zitatu mwazomwe zimagwiritsidwa ntchito kwambiri ndi:
- Mawonekedwe a Standard, omwe amatha kudziwa zambiri zokhudza SQL Server, njira zosungidwa, ndi mauthenga a Transact-SQL
- Chithunzi cha Tuning, chomwe chimagwiritsa ntchito mfundo zomwe zingagwiritsidwe ntchito ndi Advisor Database Tuning Advisor kuti awononge machitidwe a SQL Server
- Tsamba la TSQL_Replay, lomwe limasonkhanitsa zambiri zokwanira pa liwu lililonse la Transact-SQL kuti libwerenso ntchitoyo mtsogolomu
Zindikirani : Nkhaniyi ikukamba SQL Server Profiler kwa SQL Server 2012. Kwa Mabaibulo akale, onani Mmene Mungapangire Tsatanetsatane ndi SQL Server Profiler 2008 .