Cc khuy?n ngh? ? gi?m phn b? ganh ua trong SQL Server b? my c s? d? li?u tempdb

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2154845 - 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 quan st nghim tr?ng ngn ch?n khi SQL Server ang tr?i qua t?i n?ng. Khi b?n xem xt cc quan i?m qu?n l? nng ?ng [sys.dm_exec_request ho?c sys.dm_os_waiting_tasks], b?n quan st cc yu c?u ho?c nhi?m v? ang ch? ?i cho cc ngu?n l?c tempdb. B?n s? th?y r?ng lo?i ch? ?i v ch? ?i ti nguyn tr? t?i CH?T ch? ?i trn cc trang trong tempdb. Cc trang c th? ?nh d?ng 2: 1: 1, 2: 1: 3, vv.

Nguyn nhn

Khi b? my c s? d? li?u tempdb ?c s? d?ng r?t nhi?u, SQL Server c th? g?p ganh ua khi n c? g?ng c?p pht trang. Ty thu?c vo m?c ? ganh ua, i?u ny c th? gy ra truy v?n v cc yu c?u lin quan ?n tempdb ?c khng ph?n h?i trong th?i gian ng?n.

Gi?i php

C m?t s? b?c b?n c th? lm ? c?i thi?n concurrency tempdb:

Nh m?t quy lu?t chung , n?u s? l?ng cc b? vi x? l? h?p l? nh? hn ho?c b?ng 8, s? d?ng cng m?t s? t?p tin d? li?u nh b? vi x? l? h?p l?. N?u s? l?ng cc b? vi x? l? h?p l? l?n hn 8, s? d?ng 8 d? li?u t?p tin v sau n?u ganh ua v?n ti?p t?c tng s? l?ng cc t?p tin d? li?u b?i s? c?a 4 (ln ?n s? l?ng cc b? vi x? l? h?p l?) cho ?n khi cc ganh ua gi?m ?n m?c ch?p nh?n ?c ho?c th?c hi?n thay ?i cho kh?i l?ng cng vi?c/m?.

Xem xt vi?c th?c hi?n cc khuy?n ngh? th?c hnh t?t nh?t trong Technet bi vi?t c tiu ? Lm vi?c v?i tempdb trong SQL Server 2005.

N?u cc b?c tr?c khng ng k? lm gi?m phn b? ganh ua v ganh ua trn SGAM trang, th?c hi?n theo d?i c? - T1118. D?i l c? theo d?i ny, SQL Server phn b? extents ?y ? v?i t?ng ?i t?ng b? my c s? d? li?u, do lo?i b? cc ganh ua trn trang SGAM. Lu ? r?ng l c? theo d?i ny ?nh h?ng ?n t?t c? b? my c s? d? li?u v? tr?ng h?p c?a SQL Server. ? bi?t thng tin v? lm th? no ? xc ?nh xem li?u cc ganh ua phn b? trn SGAM trang, xem ch? ? ph? ganh ua theo d?i do DML ho?t ?ng d?i Lm vi?c v?i tempdb trong SQL Server 2005 Trang trn Technet.

Thng tin thm

? 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 cc phin b?n c?a s?n ph?m SQL Server, h?y xem b?ng sau:

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 ch?ng l?i cc quy t?c ?c nh gi
H? th?ng Trung tm c? v?nC?u h?nh b? my c s? d? li?u SQL my ch?: s? l?ng cc t?p tin d? li?u tempdb c th? d?n ?n ch?nH? th?ng Trung tm t v?n ki?m tra s? l?ng cc t?p tin d? li?u c?u h?nh cho b? my c s? d? li?u tempdb. N?u n l m?t v SQL Server s? d?ng b? vi x? l? nhi?u hn m?t, sau c?nh bo ny n?u ?c t?o ra. Xem l?i thng tin trong bi vi?t ny v thm nhi?u d? li?u t?p tin b? my c s? d? li?u tempdb.SQL Server 2008
SQL Server 2008 R2
SQL rver 2012



Thu?c tnh

ID c?a bi: 2154845 - L?n xem xt sau cng: 09 Thang Ging 2013 - Xem xt l?i: 4.0
p d?ng
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
T? kha:
kbmt KB2154845 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: 2154845

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