M?t s? ho?t ?ng b? my c s? d? li?u c m?t th?i gian r?t di ? hon thnh ho?c g?p l?i khi k nh?p giao d?ch c nhi?u t?p nh?t k? ?o

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2028436 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

TRI?U CH?NG

B?n c th? g?p v?n ? sau:
  1. M?t ho?c nhi?u b? my c s? d? li?u m?t m?t th?i gian r?t di ? k?t thc vi?c thu h?i trong khi kh?i ?ng my ch? SQL
  2. Khi b?n th?c hi?n Khi ph?c b? my c s? d? li?u, ph?i m?t m?t th?i gian r?t di ? hon thnh
  3. N? l?c ? nh km m?t b? my c s? d? li?u m?t m?t th?i gian r?t di ? k?t thc
  4. Khi b?n c? g?ng ? thi?t l?p b? my c s? d? li?u ph?n nh b?n g?p ph?i thng bo l?i 1413, 1443 v 1479 ch? ra m?t th?i gian ch?.
  5. B?n g?p b? nh? lin quan ?n l?i nh 701 khi b?n c? g?ng ? khi ph?c l?i b? my c s? d? li?u

Khi b?n ki?m tra Nh?t k? SQL Server Error, b?n nh?n th?y r?ng m?t s? l?ng ng k? th?i gian chi tr?c khi giai o?n phn tch c?a qu tr?nh ph?c h?i b? my c s? d? li?u.
2010-05-08 14:42:38.65 spid22s B?t ?u l?p b? my c s? d? li?u 'lot_of_vlfs'.
2010-05-08 14:46:04.76 spid22s phn tch c?a b? my c s? d? li?u 'lot_of_vlfs' (16) l 0% hon thnh (kho?ng 0 giy v?n). Giai o?n 1 c?a 3. y l m?t thng bo thng tin ch?. Khng c hnh ?ng ng?i dng ?c yu c?u.

NGUYN NHN

Trong giai o?n ?u c?a m?t qu tr?nh ph?c h?i b? my c s? d? li?u, SQL Server proforms m?t pht hi?n c?a t?t c? cc t?p tin Log ?o hi?n di?n trong t?t c? cc t?p tin k nh?p c?a giao d?ch. Danh sch t?t c? cc t?p tin Log ?o ?c xy d?ng. Qu tr?nh ny c th? m?t m?t th?i gian r?t di ty thu?c vo khi s? l?ng ?o k nh?p t?p tin c trong b? my c s? d? li?u c? th?. b? my c s? d? li?u c th? s? ch? v?i m?t s? l?n cc t?p tin Log ?o n?u cu?c g?p giao d?ch k nh?p th?ng xuyn t? ?ng l?n v?i s? tng tr?ng x?y ra trong gia s? kch th?c r?t nh?.

B?nh th?ng, b?n B?t ?u g?p ph?i nh?ng v?n ? ?c ? c?p trong ph?n tri?u ch?ng khi s? l?ng cc t?p tin Log ?o l trong kho?ng vi trm ngn.

GI?I PHP

B?n c th? s? d?ng cc phng php t? blog sau y ? t?m m?t s? cc t?p tin Log ?o trong b? my c s? d? li?u c? th?:
Lm th? no m?t c c?u t?p tin k nh?p c th? ?nh h?ng ?n th?i gian ph?c h?i b? my c s? d? li?u
B?n c th? c?n ph?i gi? cho t?ng s? cc t?p tin Log ?o d?i m?t s? h?p l? nh 10.000.

B?n c th? c?u h?nh l?i t?p nh?t k? giao d?ch ? ch?a ch? l m?t s? gi?i h?n cc t?p tin Log ?o b?ng cch s? d?ng cc phng php sau y:
  1. Thu h?p l?i cc t?p tin log giao d?ch, pht tri?n cc t?p tin v?i cc kch th?c yu c?u b?ng tay b?ng cch s? d?ng TSQL ALTER DATABASE <database name="">S?a ?i t?p tin (tn = 'tn t?p tin h?p l? c?a giao d?ch ng', kch th?c = <required size="">)</required> </database>
  2. Xy d?ng l?i cc t?p tin log giao d?ch v sau pht tri?n cc t?p tin log giao d?ch ? kch th?c yu c?u b?ng tay
    1. N?u b? my c s? d? li?u tr?c l t?t my s?ch [v?i khng c ng?i s? d?ng ho?c cc giao d?ch m?], b?n c th? lm cho vi?c s? d?ng FOR ATTACH_REBUILD_LOG ty ch?n t?o b? my c s? d? li?u ? t?o m?t t?p nh?t k? giao d?ch m?i.
    2. N?u b? my c s? d? li?u ?c/ghi c m?t ?a n k nh?p t?p tin l hi?n khng c s?n, v n?u b? my c s? d? li?u ? ?c t?t lm s?ch [v?i khng c ng?i s? d?ng ho?c cc giao d?ch m?] tr?c khi chi?n d?ch nh km, FOR nh km ty ch?n t?o b? my c s? d? li?u t? ?ng xy d?ng l?i cc t?p tin k nh?p v c?p nh?t cc t?p tin chnh.

Sau khi b?n c?u h?nh l?i b? tr c?a cc t?p tin log giao d?ch, xem l?i v thay ?i c?n thi?t cho s? pht tri?n auto-ci ?t cho cc t?p tin log giao d?ch ? trnh g?p ph?i cng m?t v?n ? trong tng lai.

Lu ? Tr?c khi b?n th?c hi?n b?t k? c?a cc ho?t ?ng ny, h?y ch?c ch?n r?ng b?n c m?t sao lu h?p l? restorable trong tr?ng h?p b?n g?p ph?i m?t s? v?n ? sau ny.

2524743 Kh?c ph?c: Ph?c h?i m?t nhi?u th?i gian hn d? ki?n cho b? my c s? d? li?u trong m?t SQL Server 2008 hay trong m?t mi tr?ng SQL Server 2008 R2

2455009 Kh?c ph?c: Ch?m hi?u su?t khi b?n Khi ph?c b? my c s? d? li?u n?u c r?t nhi?u VLFs bn trong cc b?n ghi c?a giao d?ch trong SQL Server 2005, SQL Server 2008 hay trong SQL Server 2008 R2

2653893 Kh?c ph?c: Ph?i m?t m?t th?i gian di ? khi ph?c l?i b? my c s? d? li?u trong SQL Server 2008 R2

979042 Kh?c ph?c: b? my c s? d? li?u ch? y?u khng t?m l?i ?c n?u b? my c s? d? li?u c m?t s? l?n cc t?p tin log ?o trong SQL Server 2005 ho?c trong SQL Server 2008

THNG TIN THM

? hon t?t thng tin v? t?p nh?t k? ?o, l cu?n sch tr?c tuy?n ch? ?: Giao d?ch k nh?p v?t l? ki?n trc
Th?o lu?n v? v?n ? ny:
Lm th? no m?t c c?u t?p tin k nh?p c th? ?nh h?ng ?n th?i gian ph?c h?i b? my c s? d? li?u
Giao d?ch k nh?p VLFs - qu nhi?u ho?c qu t?
1413 l?i khi kh?i ?ng b? my c s? d? li?u ph?n nh-t?p tin ?o ghi bao nhiu l qu nhi?u?

C?ng lu ? c?a m?t v?n ? ?c bi?t ?n v?i pht tri?n cc b?n ghi c?a giao d?ch:

2633151 T?p nh?t k? giao d?ch b? my c s? d? li?u SQL Server khng pht tri?n b?i gi tr? tng tr?ng ?c c?u h?nh t?p tin


? bi?t thm chi ti?t v? s?n ph?m ho?c cng c? t? ?ng ki?m tra t?nh tr?ng ny c?a b?n th? hi?n c?a SQL Server v v? cc phin b?n c?a s?n ph?m SQL Server, xem b?ng d?i y:

Thu g?n b?ng nyBung r?ng b?ng ny
Ph?n m?m quy t?cTiu ? quy t?cM t? quy t?cPhin b?n s?n ph?m m cc quy t?c ?c nh gi
SQL Server 2008 R2 t?t nh?t th?c hnh Analyzer (SQL Server 2008 R2 BPA)




b? my c s? d? li?u v?i s? l?ng BO hi?n nay





Cc SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) cung c?p m?t quy t?c ? pht hi?n t?nh hu?ng khi cc b? my c s? d? li?u ch?a m?t s? l?n cc t?p tin Log ?o. SQL Server 2008 R2 BPA h? tr? c? SQL Server 2008 v SQL Server 2008 R2.

N?u b?n ch?y cng c? BPA v g?p ph?i m?t l?i v?i tiu ? c?a b? my c s? d? li?u - b? my c s? d? li?u v?i s? l?ng BO hi?n nay, sau b?n c?n ph?i xc minh s? ?o t?p tin k nh?p cho b? my c s? d? li?u b? ?nh h?ng v c?u h?nh l?i cc t?p tin log giao d?ch.
SQL Server 2008
SQL Server 2008 R2






SQL Server 2012 Analyzer th?c hnh t?t nh?t (BPA SQL Server 2012)



b? my c s? d? li?u v?i s? l?ng BO hi?n nay




Cc SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) cung c?p m?t quy t?c ? pht hi?n t?nh hu?ng khi cc b? my c s? d? li?u ch?a m?t s? l?n cc t?p tin Log ?o.

N?u b?n ch?y cng c? BPA v g?p ph?i m?t l?i v?i tiu ? c?a b? my c s? d? li?u - b? my c s? d? li?u v?i s? l?ng BO hi?n nay, sau b?n c?n ph?i xc minh s? ?o t?p tin k nh?p cho b? my c s? d? li?u b? ?nh h?ng v c?u h?nh l?i cc t?p tin log giao d?ch.
SQL Server 2012








Thu?c tnh

ID c?a bi: 2028436 - L?n xem xt sau cng: 24 Thang Nm 2012 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 Standard
T? kha:
kbmt KB2028436 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny: 2028436

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com