Mekhoa ea ho Nchafatsa ea SQL Server

Mekhoa ea ho Nchafatsa Tekano ea Disk Space khahlanong le Complete Log Files

SQL Server e fana ka mehlala e meraro ea ho hlaphoheloa e lumellang hore u hlalosetse tsela eo SQL Server e sebetsang ka eona ho boloka lifaele tsa log le ho lokisetsa ditshwantsho tsa hau bakeng sa ho hlaphoheloa ka mor'a ho lahleheloa ke data kapa koluoa ​​e 'ngoe. E 'ngoe le e' ngoe ea tsona e emela mokhoa o fapaneng oa ho lekanyetsa tradeoff pakeng tsa ho boloka sebaka sa disk le ho fana ka mekhoa ea ho khutlisetsa likoluoa ​​tse kotsi. Mefuta e meraro ea katleho ea likoluoa ​​e fanoang ke SQL Server ke:

A re hlahlobeng e mong le e mong oa mehlala eo ka ho qaqileng haholoanyane.

Mokhoa o bonolo oa ho khutlisa

Mokhoa o bonolo oa ho hlaphoheloa ke feela: o bonolo. Mokhoa ona, SQL Server e boloka boitsebiso bo fokolang feela boitsebisong. SQL Server e kenya konteraka ea transaction nako le nako ha database e fihlella ntlha ea ho hlahloba, e siea likarolo tse ling tsa log bakeng sa merero ea ho khutlisa likoluoa.

Bakeng sa marang-rang a sebelisang mokhoa o bonolo oa ho hlaphoheloa, o ka tsosolosa li-backups tse feletseng kapa tse fapaneng feela. Ha ho khonehe ho tsosolosa dintlha tse joalo sebakeng se itseng ka nako - o ka se tsosolosa nako e tobileng ha ho e-ba le ho boloka ho feletseng kapa ho fapana ho itseng. Ka lebaka leo, o tla lahleheloa ke liphetoho tse fapaneng tsa dintlha tse entsoeng pakeng tsa nako ea morao-rao ka ho feletseng / ho fapana ha nako le nako ea ho hlōleha.

Mohlala o Ncha oa ho Nchafatsa

Setšoantšo se hlaphollang se boetse se na le lebitso le hlalosang. Ka mohlala ona, SQL Server e boloka konteraka ea transaction ho fihlela u e khutlisetsa morao. Sena se o nolofalletsa ho theha moralo oa ho nchafatsa koluoa ​​o akarelletsang ho kopana ha lisebelisoa tsa lits'ebeletso tse feletseng le tse fapaneng tumellanong le lisebelisoa tsa ho ngolisa lits'ebetso.

Ha ho e-na le ho hlōleha ha database, u na le lisebelisoa tse ngata tse tsosolosoang tsa ho boloka lits'ebeletso tsa marang-rang ho sebelisa mokhoa oa ho khutlisa o feletseng. Ho phaella ho boloka ditshwantsho tsa ditshwantsho tse boloketsoeng ho ngolisa lits'ebetso, mokhoa o feletseng oa ho hlaphoheloa o u lumella hore u tsosolose lintlha tse itseng ka nako e itseng. Ka mohlala, haeba phetoho e fosahetseng e senya lintlha tsa hau ka 2:36 hoseng ka Mantaha, u ka khutlisetsa ntlha ea SQL Server nako ea ho tsosolosa ho khutlisetsa mohala oa hau ho fihlela ka 2:35 hoseng, ho hlakola liphello tsa phoso.

Mohlala oa ho Nchafatsa ka bongata

Mohlala o motlakase oa ho fumana mokhoa ona ke mohlala o ikhethileng o sebetsang ka tsela e tšoanang le mokhoa oa ho khutlisa o feletseng. Phapang e le 'ngoe feela ke tsela eo e sebetsanang le ts'ebetso ea boholo-holo ea ho fetola data.Mohlala oa boitsebiso bo bongata o tlaleha liketso tsena bukeng ea transaction ho sebelisa mokhoa o tsejoang e le o tlaase oa ho loka. Sena se pholosa haholo nakong ea ho sebetsa, empa se u thibela ho sebelisa mokhoa oa ho khutlisetsa nako ka nako.

Microsoft e khothalletsa hore mokhoa o motlakase oa ho amohela o sebelisoang nakoana feela. Mekhoa e metle e etsa hore u fetole dintlha ho latela mokhoa o motlakase oa ho fumana mokhoa hang-hang pele u etsa mesebetsi e mengata 'me u e khutlisetsa setšoantšong se phethehileng ha mesebetsi eo e phethehile.

Ho fetola mekhoa ea ho khutlisa

Sebelisa SQL Server Management Studio ho sheba kapa ho fetola mokhoa oa ho khutlisa:

  1. Khetha server e nepahetseng : Kopanya le boemo bo loketseng ba SQL Server Database Engine, joale ho Object Explorer, tobetsa lebitso la seva ho eketsa sefate sa seva.
  2. Khetha database : Eketsa Litsebiso , 'me, ho itšetlehile ka database, khetha mohloli oa basebenisi kapa ho atolosa Databases tsa Sesebelisoa mme o kgethe database ya tsamaiso.
  3. Bula Matlotlo a Li- Database : Tlanya ka ho le letona la database, ebe o tobetsa Properties , ho bula lebokose la lebokose la boitsebiso ba Matlotlo a Database .
  4. Sheba Mekhoa ea Phatlalatso ea morao-rao : Ho Khetha leqephe la holimo , tobetsa Litsela tsa ho sheba mokhoa oa morao-rao oa ho khutlisa .
  5. Khetha mofuta o mocha oa ho tsosolosa : Khetha e feletseng , e le bulk-logged , kapa e bonolo .
  6. Tlanya OK .