Ho sebelisa SQL Server Profiler ho shebella litaba tsa Tshebetso tsa Tshebetso
SQL Server Profiler ke sesebelisoa sa ho hlahloba se kenyelletsoeng le Microsoft SQL Server 2012. Se u lumella ho theha litsela tsa SQL tse latolang liketso tse itseng tse etsoang khahlanong le dintlha tsa SQL Server. Litsela tsa SQL li fana ka tlhahisoleseding ea bohlokoa bakeng sa lintlha tsa bothata ba litlaleho tsa lits'ebetso tsa marang-rang le lisebelisoa tsa theknoloji ea basebelisi . Ka mohlala, batsamaisi ba ka 'na ba sebelisa mokhoa o khethollang bothata ba potso' me ba ntshetsopele ho ts'oanela ho ntlafatsa tshebetso ea ditshwantsho.
Ho theha Tlhahiso
Tshebetso ea mohato oa mohato oa ho bopa SQL Server Trace le SQL Server Profiler e latelang:
- Bula SQL Server Management Studio mme u ikopanye lekhetlong la SQL Server la khetho ea hau. Fana ka lebitso la seva le litokomane tse nepahetseng tsa log-in ntle le haeba u sebelisa Windows Authentication.
- Ka mor'a hore u bula SQL Server Management Studio, khetha SQL Server Profiler ho tswa ho Lisebelisoa tsa menu. Hlokomela hore haeba u sa rera ho sebelisa lisebelisoa tse ling tsa SQL Server nakong ena ea tsamaiso, u ka khetha ho qala SQL Profiler ka ho toba, ho e-na le ho feta ka Management Studio.
- Fana ka boitsebiso ba ho kena-kenana le li-log-in hape, haeba u khothalletsoa ho etsa joalo.
- SQL Server Profiler e nka hore o batla ho qala mocha o mocha mme o bula fensetere ea Matlotlo a Trace . Fensetere ha e na letho ho u lumella hore u hlalosetse lintlha tsa setšoantšo.
- Etsa lebitso le hlalosang bakeng sa lethathamo mme u le tšele ka lebokoseng la Trace Name text.
- Khetha template bakeng sa lethathamo la ho sebelisa Sehlopha se theoha sa Template . Sena se o nolofalletsa ho qala mokhoa oa hau ka ho sebelisa e 'ngoe ea li-templates tse boletsoeng esale pele tse bolokiloeng laebraring ea SQL Server.
- Khetha sebaka ho boloka liphello tsa mokhoa oa hau. U na le likhetho tse peli mona:
- Khetha Save ho Files ho boloka lethathamo ho faele ka hard drive ea moo. Fana ka lebitso la fono le sebaka sa Save As window e hlahelang ka lebaka la ho tobetsa lebokose la ho hlahloba. U ka boela ua beha boholo ba file ho MB ho fokotsa tšusumetso e ka 'nang ea e-ba le eona mosebetsing oa disk.
- Khetha Save ho Lethathamo ho boloka lethathamo tafoleng ka har'a database ea SQL Server. Haeba o khetha kgetho ena, o khothalletsoa hore o hokahane sebakeng seo u batlang ho boloka sephetho sa hau. U ka boela ua beha boholo ba mekhoa e mengata-ka lihlopha tse likete tsa litafole-ho fokotsa tšusumetso e ka 'nang ea e-ba le eona molareng oa hau.
- Tobetsa tabeng ea Selection ea Liketsahalo ho tla hlahloba liketsahalo tseo u tla li shebella ka tsela ea hau. Liketsahalo tse ling li khethoa ka mokhoa o itšetlehileng ka setšoantšo seo u se khethileng. U ka fetola tse khethiloeng ka nako ena 'me u shebe dikgetho tse eketsehileng ka ho tobetsa Lintho Tsohle li bonts'a' me u bonts'a lebokose la li- Columns kaofela .
- Tobetsa konopo ea Run ho qala ho latela. Ha o qetile, khetha Stop Stop ho Files menu.
Khetha Setšoantšo
Ha u qala ho latela, u ka khetha ho e theha ho litlhahlobo leha e le life tse fumanehang laebraring ea trace ea SQL Server. Tse tharo tsa li-templates tse tloaelehileng ka ho fetisisa tse sebelisoang ke:
- Setšoantšo sa Standard, se bokellang boitsebiso bo sa tšoaneng mabapi le li-connections tsa SQL Server, mekhoa e bolokiloeng, le lipolelo tsa Transact-SQL
- Template ea Tuning, e bokellang tlhahisoleseding e ka sebelisoang le Moeletsi oa Database Engine Tuning ho shebella ts'ebetso ea hau ea SQL Server
- Tempele ea TSQL_Replay, e bokellang tlhahisoleseding e lekaneng mabapi le polelo e 'ngoe le e' ngoe ea Transact-SQL ea ho tsosolosa mosebetsi nakong e tlang
Tlhokomeliso : Sehlooho sena se bua le SQL Server Profiler bakeng sa SQL Server 2012. Bakeng sa liphetolelo tsa pele, bonang joang ho etsa Trace le SQL Server Profiler 2008 .