Umphumela Omkhulu we-SQL nge-VPN: Lapho Imigqa Ilinda Khona

Imibuzo ingaqeda ngemizuzwana kodwa ithathe amaminithi ukufika kukhompyutha ephathekayo nge-VPN. Iseva ibhala imigqa kumabhafa, uxhumano luyayithwala, neklayenti iyayisebenzisa, futhi lezi zigaba ziyahlangana esikhundleni sokulandelana. Noma yisiphi sazo singaba umkhawulo. Thola isigaba esilinda ngempela ngaphambi kokushintsha umkhawulokudonsa noma ukuvula ukucindezela.

Izigaba Ezintathu, Isikhathi Sokumisa Esisodwa

Hlukanisa isikhathi sibe yizinombolo ezimbili ezinencazelo ehlukile: isikhathi lapho umugqa wokuqala utholakala khona kanye nesikhathi lapho umugqa wokugcina usetshenzisiwe. Igridi edweba ikhasi lokuqala ikhombisa kuphela ukuthi umbuzo uqalile. Isikhathi somphumela ogcwele yilokho umsebenzisi akuhlangabezayo lapho ethumela ngaphandle noma eqaqa kuze kube sekupheleni.

Rekhoda zombili izinombolo kanye nombhalo wombuzo, amapharamitha nezilungiselelo zoxhumano. Ngaphandle kwalowo mongo, ukuqhathanisa kungaphakathi kwemisebenzi emibili ehlukene, hhayi izindawo ezimbili.

Funda Ukulinda Ngaphambi Kwenethiwekhi

I-SQL Server ibhala imigqa yomphumela kumabhafa okukhipha ukuze iklayenti iwathole, futhi iklayenti elisebenzisa kancane lingenza iseva ilinde kulokho kuthumela. Uhlobo lokulinda yi-ASYNC_NETWORK_IO, futhi inothi lika-Microsoft lokuxazulula izinkinga libala imiphumela emikhulu nokucubungula ohlangothini lweklayenti phakathi kwezimbangela. Ukulinda kusho ukuthi indlela yokuthumela ivaliwe, hhayi ukuthi kungani.

I-VPN enensayo ingaba nomthelela, kodwa neklayenti elihlela umugqa ngamunye, elibhala efayeleni noma elimisa phakathi kwamaqoqo lingaba nomthelela. Igama lokulinda liyinkomba yokulinganisa okulandelayo, hhayi isinqumo ngoxhumano.

SELECT wait_type, wait_time_ms
FROM sys.dm_os_wait_stats
WHERE wait_type = 'ASYNC_NETWORK_IO';

Funda isibali ngesikhathi umthwalo olinganiselwe usebenza, hhayi ngemva kwehora lokungenzi lutho, ngoba izibali eziqoqekayo zihlanganisa yonke isikhathi kusukela i-instance yaqala. Qhathanisa umehluko phakathi nokugijima hhayi isamba sokuphila konke. Umehluko okhulayo ngesikhathi sokudlulisa unciphisa umbuzo ekusetshenzisweni noma ekulethweni.

Beka Womabili Amaklayenti Esiwathini Esisodwa

Gijimisa umthwalo olinganiselwe kusukela eklayentini eseduze kwedathabhezi nasemklayentini okude. Gcina umbuzo, amapharamitha, usayizi womphumela nezilungiselelo zoxhumano zifana. Sebenzisa isilinganiso esifanayo ezinhlangothini zombili, ngoba isikhathi sokusebenza kweseva, isikhathi sokubonisa igridi nesikhathi sokuthumela ngaphandle zingamawashi amathathu ahlukene. Ukuqhathanisa inombolo yohlangothi lweseva nesikhathi sokuthumela ngaphandle sohlangothi lweklayenti kuveza isiphetho esingeke sihlolwe.

Lapho indlela ibonakala inecala, cela umnikazi wenethiwekhi ukuthi abheke ukulahleka, ukuthunyelwa kabusha kanye nomthamo otholakele walowo mfudlana othile ngesikhathi sokudlulisa. Ukuhlolwa kwejubane okujwayelekile kungase kusebenzise enye indlela, iphoyinti lokugcina noma iphethini yokwenzeka kanyekanye. Isicelo esincane esiphumelelayo asisho lutho oluningi ngokudluliswa komphumela oqhubekayo.

Nciphisa Amabhayithi Ngaphambi Kokusola Indlela

Ukuhlunga, ukuhlanganisa nokukhetha kuphela amakholomu adingekayo kunciphisa ivolumu yokudlulisa kanye nomsebenzi iklayenti eliwenzayo kumugqa ngamunye. Gcina umphumela ohlosiwe, ngoba umbiko ungase udinge imininingwane isifinyezi esikusikrini esingenayo.

Okokuthumela ngaphandle okuphindwayo, indawo yokusebenza egunyaziwe eduze kwedathabhezi ingabhala umkhipho ochaziwe osele uthunyelwa kanye. Lokho kushintsha ukuhamba komsebenzi nezilawuli zalo zokufinyelela, futhi akusona isigunyazo sokushiya i-dump engavinjelwe kumsingathi owabiwe.

Ukucindezela akusona isixazululo esizenzakalelayo. Ukusekelwa nokuphepha kuncike kuphrothokholi yangempela nokwetshiwo, futhi umfudlana ocindezelwe iklayenti ewuvula kancane ungayenza isipiliyoni sibe sibi nakakhulu. Linganisa isigaba kuqala, bese ukhetha ushintsho olusekelwayo lwaleso sigaba.