Qhov wikiHow qhia koj yuav siv SQL Server Query Store li cas txhawm rau saib xyuas qhov ua tau zoo ntawm koj cov lus nug database.
Cov kauj ruam
Ntu 1 ntawm 3: Pab kom Lub Khw Muag Khoom
Kauj Ruam 1. Qhib SQL Server Management Studio
Koj tuaj yeem siv Query Store feature ntawm SQL Server los tshuaj xyuas koj lub database rau teeb meem kev ua haujlwm. Cov yam ntxwv no suav nrog SQL Server 2016 thiab tom qab, tab sis koj yuav tsum tau pab nws tus kheej.
Kauj Ruam 2. Qhib Object Explorer
Yog tias koj tsis pom Object Explorer twb dhau los lawm, nyem rau Saib cov ntawv qhia zaub mov nyob rau sab saum toj ntawm qhov screen, tom qab ntawd nyem Lub hom phiaj Explorer.
Kauj Ruam 3. Txoj cai-nias lub database koj xav tshuaj xyuas
Cov ntawv qhia zaub mov yuav tshwm.
Lub Khw Muag Khoom tsis tuaj yeem siv los tshuaj xyuas tus tswv lossis tempdb databases
Kauj Ruam 4. Nyem Properties
Kauj Ruam 5. Nyem Lus Nug Khw
Nws yog nyob rau ntawm Properties dialog box.
Kauj Ruam 6. Xaiv Hauv qab ″ Hom Kev Ua Haujlwm (Thov)
″ Lub Khw Muag Khoom yuav pib taug qab txhua cov lus nug.
Kauj Ruam 7. Rov ua dua cov ntaub ntawv hauv Pawg Ntseeg Vaj Huam Sib Luag
Qhov no ntxiv Query Store nplaub tshev rau ntawm lub vaj huam sib luag.
Kauj Ruam 8. Kho kom haum thaum Cov Lus Nug Qub sau cov ntaub ntawv tshiab
Lub Khw Muag Khoom yuav suav cov stats tshiab txhua 60 feeb los ntawm lub neej ntawd. Nov yog yuav hloov pauv li cas (siv 15 feeb ua piv txwv):
- Hloov DATABASE
- SET QUERY_STORE (INTERVAL_LENGTH_MINUTES = 15);
Ntu 2 ntawm 3: Nrhiav Cov Lus Nug Sab Qaum Teb uas Siv Tau Zoo
Kauj Ruam 1. Nyem rau - ze rau ″ Query Store ″ hauv Object Explorer
Qhov no qhia tag nrho Cov Lus Nug Khw Xaiv.
Siv txoj hauv kev no txhawm rau nrhiav seb cov lus nug tshwj xeeb twg yog siv cov peev txheej feem ntau ntawm cov server
Kauj Ruam 2. Nyem Qhov Kev Pab Cuam Sab saum toj
Qhov no qhib kab lus uas qhia txog 25 feem ntau cov lus nug-siv cov khoom siv hauv lub hauv paus. Cov txiaj ntsig no tau nthuav dav zoo nkauj, tab sis koj tuaj yeem hloov kho lub teeb kom tau txais cov ntaub ntawv muaj txiaj ntsig zoo dua.
Kauj Ruam 3. Nyem Configure
Nws nyob ntawm kaum sab xis saum toj ntawm tsab ntawv ceeb toom. Lub qhov rooj sib tham yuav tshwm sim.
Kauj Ruam 4. Xaiv koj li txheej txheem kev siv peev txheej
Hauv ntu sab saum toj (eria Cov Cai Siv Cov Khoom Siv ″), xaiv cov peev txheej twg koj xav tshuaj xyuas (piv txwv li, CPU Sijhawm, Nco Kev Siv), thiab cov ntaub ntawv xav tau (piv txwv li, Avg, Tag nrho).
Kauj Ruam 5. Xaiv lub sijhawm
Hauv qab ″ Sijhawm Sijhawm ″ ntu, xaiv lub sijhawm sijhawm uas koj xav pom cov txiaj ntsig. Koj tuaj yeem xaiv qhov kev xaiv los ntawm cov ntawv qhia zaub mov nco lossis ntxig cov hnub tshwj xeeb rau hauv cov thawv muab.
Kauj Ruam 6. Xaiv pes tsawg tus txiaj ntsig kom pom
Txhawm rau pom txhua cov lus nug rau lub sijhawm xaiv, nyem Txhua hauv qab ″ Return ″ header. Txhawm rau tso tus lej tshwj xeeb ntawm cov lus nug, xaiv Sab saum toj thiab sau tus lej (piv txwv
Kauj ruam 10., 100).
Yog tias koj xav lo rau saum 25 tus neeg ua phem phem tshaj plaws, tsis tas yuav hloov dab tsi hauv qab ″ Return ″ header
Kauj Ruam 7. Nyem OK
Cov txheeb cais tam sim no yuav rov ua dua tshiab los tso saib qhov koj xav pom.
Kauj Ruam 8. Kho qhov pom (yeem)
Siv cov duab me me (kab sib chaws, kab ntawv, thiab kab duab kab) kom pom cov txiaj ntsig hauv ntau yam qauv. Cov nyees khawm no yog nyob rau ntawm kaum sab xis saum toj ntawm cov txiaj ntsig.
Ntu 3 ntawm 3: Txheeb Xyuas Cov Lus Nug Tsis Zoo
Kauj Ruam 1. Nyem rau - ze rau ″ Query Store ″ hauv Object Explorer
Qhov no qhia tag nrho Cov Lus Nug Khw Xaiv.
Siv txoj hauv kev no txhawm rau nrhiav cov lus nug tshwj xeeb uas ua tau qeeb dua li lawv tau siv
Kauj ruam 2. Nyem Regressed Queries
Qhov no qhib lub Regressed Queries panel, qhov twg koj yuav pom cov lus nug thiab cov phiaj xwm hauv Khw Muag Khoom.
Kauj Ruam 3. Xaiv txoj kev npaj los ntawm thawj cov ntawv qhia zaub mov
Nws yog cov ntawv qhia zaub mov sau ″ Txheeb xyuas qhov rov qab los hauv ″ saum toj kawg nkaus-sab laug ntawm lub vaj huam sib luag. Txhua ntawm cov phiaj xwm yuav tso tawm cov ntawv qhia ua haujlwm sib txawv rau koj cov lus nug.
- Piv txwv li, yog tias koj xav tshuaj xyuas cov teeb meem nrog rau lub sijhawm nws siv rau cov lus nug los khiav, xaiv Ntev.
- Txhawm rau pom cov teeb meem ntsig txog kev siv RAM, xaiv Nco Kev Siv.
Kauj Ruam 4. Xaiv qhov kev txheeb cais los ntawm cov ntawv qhia zaub mov thib ob
Nov yog cov ntawv qhia zaub mov sau tias ″ Raws li ″ (mus rau sab xis ntawm cov ntawv qhia zaub mov dhau los. Qhov no rov qhia cov txiaj ntsig.