Kuumba Maitiro Ne SQL Server 2012

Kushandisa SQL Server Profiler kuongorora Dhiyabhorosi Dhigiridziro Dzekuita

SQL Server Profiler chirongwa chekuongorora chinosanganisira Microsoft SQL Server 2012. Inokubvumira kuita SQL tsanangudzo dzinoona zviito zvakasangana neSquL Server database. SQL tsanangudzo inopa ruzivo rwakakosha rwekutarisana nehutano hwehupfumi hwemashoko uye kugadzirisa dhigirii yenjini yekushanda. Semuenzaniso, vatungamiri vanogona kushandisa tsananguro kuti vazive kugadzirisa mubvunzo uye kukudziridza kugadziridza kwekuvandudza kushanda kwemasvomhu.

Kuumba Trace

Nhanho-nhanho nzira yekusika SQL Server Trace ne SQL Server Profiler inotevera:

1. Vhura SQL Server Management Studio uye shandisai SQL Server chiitiko chekusarudza kwako. Ipa zita revavha uye zvakakodzera kukwanganisa-muzvikwereti kunze kwekuti uri kushandisa Windows Authentication.
2. Mushure mekunge mazarura SQL Server Management Studio, sarudza SQL Server Profiler kubva pane Zvirongwa menyu. Cherechedza kuti kana iwe usingaronga kushandisa dzimwe shanduro dzeSQL Server munharaunda iyi yekutonga, unogona kusarudza kutanga SQL Profiler zvakananga, panzvimbo yekuenda neBlack Studio.
3. Ipa zvikwangwani zve-log-in zvakare, kana iwe uchikurudzirwa kuita saizvozvo.
4. SQL Server Profiler inofunga kuti iwe unoda kutanga mutsva uye unovhura Trace Properties window. Iwindo harina kubvumidza iwe kuti unyatsotsanangura tsanangudzo yemutsara.
5. Gadzira zita rinotsanangurwa rekutsvaga uye uise iyo muTrace Name text box.
6. Sarudza template yemutsananguro kubva pakushandisa kweDeveloped down menu. Izvi zvinokubvumira kuti utange mararamiro ako uchishandisa imwe yezvifananidzi zvakafananidzwa muraibhurari ye SQL Server.
7. Sarudza nzvimbo kuti uchengetedze migumisiro yako yekutsvaga. Une zvingasarudzwa zviviri pano:
   • Sarudza Chengeta kuFaira kuti uchengetedze tsvaga kune faira pane dambudziko rekushandisa. Ipa zita refaira uye nzvimbo munzvimbo ye Save sewindo iyo inokurudzirwa semugumisiro wekutsvaga bhokisi rekuongorora. Iwe unogonawo kuisa huwandu huwandu hwefaira muMB kuti udzikise kukanganiswa kwatingaita pane kushandiswa kwe diski.
   • Sarudza Chengeta kuTebheek kuti uchengetedze tsanangudzo patafura mukati meSquL Server database. Kana ukasarudza sarudzo iyi, unokurudzirwa kuti uungane kune database uko iwe uchida kuchengeta mitsva yekutsvaga. Iwe unogonawo kuisa hukuru hwekutevedzera ukuru-muzviuru zvemazera ematafura-kuti udzikise kukanganisa kwaungaita pane yako database.

1. Dzvanya paChechi Chisarudzo chebhuku kuti uongorore zviitiko zvaunotarisa nekutora kwako. Zvimwe zviitiko zvinosarudzwa zvakananga zvichienderana ne template yawakasarudza. Iwe unogona kugadzirisa izvo zvisarudzo zvisingagoneki panguva ino uye tarisa zvimwe zvasarudzo kuburikidza pakuratidza Show All Events uye Ratidzai Ma Columns chengetedza mabhokisi.
2. Dzvanya bhodhi Run kuti utange kutsvaga. Kana wapedza, sarudza Stop Trace kubva paFirimu menyu.

Kusarudza Template

Paunotanga tsanangudzo, unogona kusarudza kuidzika pane imwe yema templates inowanikwa muraibhurari yekutsvakurudza yaSQL Server. Zvitatu zvezvinonyanya kushandiswa zvinotevera ma templates ndezvi:

• The Standard Standard template, iyo inounganidza mashoko akasiyana-siyana pamusoro pekubatana kweSQL Server, maitiro akachengeterwa, uye zvinyorwa zveTransact-SQL
• The Tuning template, iyo inounganidza ruzivo runogona kushandiswa neGoogle Engine Tuning Advisor kuti tongorore SQL Server yako
• Iyo TSQL_Replay template, iyo inounganidza ruzivo rwakakwana pamusoro peshoko rimwe nerimwe re Transact-SQL yekudzorerazve basa munguva yemberi

Cherechedza : Nyaya ino inotaurira SQL Server Profiler yeSQL Server 2012. Kwemashanduro apfuura, ona How To Create Trace na SQL Server Profiler 2008 .