Umsebenzi omude we-SQL: wugcine ugijima lapho i-VPN iwa

I-VPN iwa emva kwemizuzu engamashumi amabili kuqalwa ukwakhiwa kabusha kwenkomba, iklayenti lakho le-SQL likhombisa uxhumano oluphukile, futhi umbuzo osobala awunayo impendulo kulelo phutha. Ingabe isitatimende saphela, sahlehliswa, noma saqhubeka sisebenza ngaphandle kwakho? Ukuxhuma kabusha nokuthumela kabusha kuyisinqumo esibi kakhulu kwezintathu, ngoba kuguqula umphumela owodwa ongaqinisekile ube yimiphumela emibili engaba khona. Hambisa umsebenzi entweni enomnini oqhubekayo ngaphambi kwefasitela elilandelayo.

Lokho iphutha lokuxhumana elingakutsheli kona

Iphutha ohlangothini lweklayenti lichaza iklayenti. Libika ukuthi isokhethi ivaliwe, hhayi ukuthi iseva yenzani nokuthengiselana. Isitatimende kungenzeka sisasebenza, kungenzeka sagcinwa ngqo ngaphambi kokushona kwesixhumanisi, noma kungenzeka sahlehliswa ngesikhathi isikhathi saso sihlanjululwa. Zontathu zikhipha umyalezo ofanayo kukhompyutha yakho ephathwayo.

Isimo seseva kuphela esingakuxazulula lokho. Bheka lapho ngaphambi kokunquma noma yini.

Nikeza umsebenzi kumnini ohlangothini lweseva

Emsebenzini ongadingi muntu ozowugada, vumela umsingathi wesizindalwazi ukuthi ube ngumnini wokwenza. I-SQL Server Agent igijimisa imisebenzi ngokucela noma ngokohlelo futhi iqopha ukugijima ngakunye, ngakho umjikelezo wokuphila womsebenzi awuncikile kusikhathi sakho se-VPN. Ubunikazi bomsebenzi budinga izimvume ezifanele ezidingwa umsebenzi, hhayi umongo ogcwele wokuxhumana womlawuli. Khona-ke ikhompyutha ephathwayo iqala umsebenzi futhi ifunde imiphumela esikhundleni sokuba inqubo ewugcina uphila.

EXEC msdb.dbo.sp_start_job @job_name = N'nightly-customer-reindex';

Ukutholakala kwe-Agent kuncike kuhlelo nesevisi oyisebenzisile. Sebenzisa indlela yesikhulumi sakho langempela esiyihlinzekayo esikhundleni sokucabanga ukuthi le ikhona yonke indawo.

Umsingathi wokugxuma oseduze kwesizindalwazi wehlisa indlela futhi kufanele ube khona, kodwa awushintshi umbuzo wobunikazi. Isikhathi sisaphela lapho inethiwekhi iphela. Yisebenzisele ukubuka, hhayi ukuba yinto egcina umsebenzi uphila.

Shiya irekhodi isikhathi esilandelayo esingalifunda

Bhala igama lomsebenzi noma isihlonzi, isizindalwazi esihlosiwe kanye nomphumela owulindele. Yilo rekodi elivumela esinye isikhathi, noma omunye umuntu, ukuphendula umbuzo iphutha elingakwazanga ukuwuphendula. Ngaphandle kwayo kusala inkumbulo engacacile yokubuyekezwa futhi ayikho indlela yokuqinisekisa.

EXEC msdb.dbo.sp_help_jobhistory @job_name = N'nightly-customer-reindex';

Umlando ukhombisa umphumela nesikhathi sesinyathelo ngasinye, okuwusizo kakhulu kunefulegi elilodwa lokuphumelela. Emisebenzini eshintsha idatha, engeza nokuqinisekisa kohlelo lokusebenza uqobo: inani lemigqa, i-checksum noma umugqa wesimo obhalwe umsebenzi. Amarekhodi amabili azimele yiwo enza ukuphindwa kube kuphephile, futhi umlando womsebenzi oqoshiwe ungowokuqala kuwona.

Vumelanisa ngaphambi kokuthumela futhi

Lapho uxhumano lokubuka lunyamalala, thola ukugijima okukhona ngaphambi kokuqala okunye. Funda imiphumela yezinyathelo zako bese unquma ukuthi umsebenzi wagcinwa, waqedwa ngokwengxenye noma awuzange uqale. Yilapho kuphela lapho usebenzisa umthetho wokuphinda ochazwe uhlelo lokusebenza, ngoba ukuthumela futhi ngokungaboni kungaphinda kabili umthwalo noma kwehluleke phakathi nendawo okwesibili.

Gcina umnini oqhubekayo nomphumela ongahlolwa, futhi ukwehluleka kokufinyelela kwesikhashana kuba yinkinga esikhundleni sokuqagela. Yilo wonke umgomo wokuklama: umsebenzi kufanele uphile isikhathi eside kunoxhumano oluwucelile.