Traces cia koj mus taug qab cov kev ua tau tawm tsam SQL Server database. Lawv muab cov ntaub ntawv tseem ceeb rau cov teeb meem cov teeb meem database thiab tuning database engine performance. Hauv no nyeem, peb taug kev los ntawm tus txheej txheem ntawm kev tsim SQL SQL Trace nrog SQL neeg rau zaub mov Profiler, step-by-step.
Lus Cim : Cov tshooj no yog rau cov neeg siv ntawm SQL Server 2008 thiab yav dhau los. Yog hais tias koj siv SQL neeg rau zaub mov 2012 , nyeem peb lwm tsab xov xwm ntawm kev tsim khoom nrog SQL neeg rau zaub mov 2012 .
Yuav ua li cas los tsim ib txoj lw nrog SQL neeg rau zaub mov Profiler
- Qhib SQL neeg rau zaub mov Management Studio los xaiv nws los ntawm Start tshuab raj.
- Ntawm cov ntawv qhia zaub mov, xaiv SQL Server Profiler.
- Thaum SQL Server Profiler opens, xaiv Cov Ntawv Tshiab ntawm Cov Ntawv Ceev Npe.
- SQL neeg rau zaub mov Profiler yuav ces kom koj txuas mus rau qhov SQL Server instance koj xav profile. Muab cov ntaub ntawv txuas thiab nias lub khawm Txuas mus txuas ntxiv.
- Tsim ib lub npe tseem ceeb rau koj tus lw thiab sau nws rau hauv lub npe "Lub Npe Tawm".
- Xaiv ib lub qauv rau koj lub tais ntawm daim ntawv qhia zaub mov. (Saib Cov Tswv Yim Cov Ntawv Qhia hauv qab no rau cov lus qhia txog qee cov qauv siv rau kev sib tw)
- Xaiv qhov Txuag Txiaj Ntsim rau Kev Tshawb Xyuas kom txuag tau koj tus lw mus rau hauv cov ntaub ntawv ntawm lub zos tsav. Muab ib lub npe thiab qhov chaw hauv Txuag Raws li qhov rai uas tshwm sim los ntawm txhaj lub checkbox.
- Nias rau ntawm Cov Kev Xaiv Hnub Nyoog tab los saib xyuas cov xwm txheej koj tuaj yeem soj ntsuam nrog koj qhov cim tseg. Qee cov txheej xwm yuav raug xaiv raws li cov qauv koj xaiv. Koj tuaj yeem hloov cov kev xaiv ntawm lub sijhawm no. Koj tuaj yeem saib cov kev xaiv ntxiv los ntawm txhaj Cov Qhia Tag Nrho Cov Rooj Sablaj thiab Qhia Tag Nrho Txhua Lub Sijhawm.
- Nias lub khawm khiav los pib koj lub cim. SQL neeg rau zaub mov yuav pib tsim txoj kab, muab cov ntsiab lus raws li qhia hauv daim duab. (Koj tuaj yeem nias ntawm daim duab los ua ntug dua.) Thaum koj ua tiav, xaiv "Stop Trace" los ntawm Daim Ntawv Teev Cov Ntawv Tawm.
Tswv yim pab tswv yim
- Tus Standard template khaws ntau yam ntaub ntawv hais txog SQL neeg rau zaub mov kev sib txuas, cov txheej txheem khaws cia, thiab Transact-SQL cov nqe lus.
- Lub ntsiab template sau cov ntaub ntawv uas siv tau nrog Database Cav Tuning Advisor los qhib koj cov neeg SQL Server qhov kev ua tau zoo.
- TSQL_Replay template khaws txaus cov ntaub ntawv hais txog txhua Transact-SQL tsab ntawv mus rau recreate cov kev ua ub no yav tom ntej.