?i l? SQL Server ? v? khi b?n c? g?ng B?t ?u n hay m?t nhi?u th?i gian hn d? ki?n s? B?t ?u

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2795690 - 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

M?t ?i l? SQL Server ? v? khi b?n c? g?ng kh?i ?ng n ho?c m?t nhi?u th?i gian hn d? ki?n s? B?t ?u. Ngoi ra, b?n c th? g?p m?t ho?c nhi?u c?a cc k?ch b?n sau y:
  • K?ch b?n 1

    Thng bo l?i sau y ?c k nh?p s? k? s? h? th?ng:
    Cc b?n ghi d?ch v? ? khng p ?ng cc yu c?u B?t ?u ho?c ki?m sot m?t cch k?p th?i
  • K?ch b?n 2

    T?nh tr?ng c?a cc ?i l? s? ?c hi?n th? nh l "B?t ?u" trong Panel iu khin, v cc thng bo l?i sau y ?c k nh?p cc t?p tin SQLAgent.log:
    M?t i?u ki?n nhn r?i CPU ? khng ?c xc ?nh - OnIdle vi?c lm l?ch tr?nh s? khng c hi?u l?c

    Ngoi ra, cc m?c sau y c th? ?c ghi trong t?p tin SQLAgent.log:
    tem th?i gian> - ? B? ?m ?n h? th?ng con Populating [431]...
    tem th?i gian> - ? [432] l h? th?ng con 7 trong b? ?m ?n h? th?ng con
    tem th?i gian> - ? [124] H? th?ng 'ActiveScripting' ? ?c n?p (t?i a concurrency: 40)
    tem th?i gian> - ? [124] H? th?ng 'ANALYSISCOMMAND' ? ?c n?p (t?i a concurrency: 400)
    tem th?i gian> - ? [124] H? th?ng 'ANALYSISQUERY' ? ?c n?p (t?i a concurrency: 400)
    tem th?i gian> - ? [124] H? th?ng 'CmdExec' ? ?c n?p (t?i a concurrency: 40)
    tem th?i gian> - ? [124] H? th?ng 'PowerShell' ? ?c n?p (t?i a concurrency: 2)
    tem th?i gian> - ? [124] H? th?ng 'SSIS' ? ?c n?p (t?i a concurrency: 400)
    tem th?i gian> - ? [124] H? th?ng 'TSQL' ? ?c n?p (concurrency t?i a: 80)
    tem th?i gian> - ! [364] The Messenger b?n ghi d?ch v? khng ?c B?t ?u - NetSend thng bo s? khng ?c g?i
    tem th?i gian> - ? [129] SQLSERVERAGENT B?t ?u d?i s? ki?m sot b?n ghi d?ch v? Windows NT
    tem th?i gian>- + [396] M?t nhn r?i CPU i?u ki?n khng ?c xc ?nh - OnIdle vi?c lm l?ch tr?nh s? khng c hi?u l?c
    tem th?i gian> - ? [110] B?t ?u t? SQLServerAgent mn h?nh s? d?ng '' nh l ng?i nh?n thng bo...
    tem th?i gian> - ? [146] ?ng c chap yu c?u B?t ?u
    tem th?i gian> - ? [133] ?ng c h? tr? B?t ?u
    tem th?i gian> - ? [167] Populating cng vi?c b? nh? cache...
    tem th?i gian> - ? [131] Cc b?n ghi d?ch v? SQLSERVERAGENT d?ng do m?t yu c?u t?t my t? m?t ng?i s? d?ng, qu tr?nh, ho?c cc h iu hanh...
    tem th?i gian> - ? [134] H? tr? ?ng c ng?ng
    tem th?i gian> - ? [197] C?nh bo ?ng t?t my
    tem th?i gian> - ? [168] l 4731 job(s) [0 v hi?u ha] trong b? nh? cache cng vi?c
    tem th?i gian> - ? [170] Populating c?nh bo cache...
    tem th?i gian> - ? [171] C l 0 alert(s) trong b? nh? cache c?nh bo
    tem th?i gian> - ? [149] ?ng c chap yu c?u t?t my
    tem th?i gian> - ? [248] Ti?t ki?m NextRunDate / th?i gian cho t?t c? C?p nh?t l?ch tr?nh cng vi?c...
    tem th?i gian> - ? [249] 0 cng vi?c lu l?ch bi?u
    tem th?i gian> - ? [127] Ch? ?i cho h? th?ng ph? ? k?t thc...
    tem th?i gian> - ? [128] H? th?ng 'ActiveScripting' t?t my (l?i ra m? 1)
    tem th?i gian> - ? [128] H? th?ng 'ANALYSISCOMMAND' t?t my (l?i ra m? 1)
    tem th?i gian> - ? [128] H? th?ng 'ANALYSISQUERY' t?t my (l?i ra m? 1)
    tem th?i gian> - ? [128] H? th?ng 'CmdExec' t?t my (l?i ra m? 1)
    tem th?i gian> - ? [128] H? th?ng 'PowerShell' t?t my (l?i ra m? 1)
    tem th?i gian> - ? [128] H? th?ng 'SSIS' t?t my (l?i ra m? 1)
    tem th?i gian> - ? [175] Cng vi?c scheduler ?ng c ng?ng
  • Tr?ng h?p 3

    M?t qu tr?nh SQL Server ID (d?ch v? SPID) t? b?n ghi d?ch v? "SQLAgent - chung hu?n" ?c hi?n th? trn my ch? b? my c s? d? li?u. Ngoi ra, cc cng vi?c sau y ?c hi?n th? nh ch?y trong b? ?m ?u vo c?a b?n ghi d?ch v? SPID:
    EXECUTE msdb.dbo.sp_sqlagent_refresh_job

    Lu ?b?n ghi d?ch v? SPID trong tram u RUNNABLE v th?ng xuyn ch? ?i cho ccPREEMPTIVE_OS_LOOKUPACCOUNTSID ch? ?i cc lo?i. Ho?c b?n ghi d?ch v? SPID l trong tram u ch? ?i cho ccASYNC_NETWORKIO ch? ?i cc lo?i.

Nguyn nhn

V?n ? ny x?y ra b?i v? c r?t nhi?u cng vi?c m?c trong SQL Server.

Lu ? i?u ny c th? x?y ra n?u b?n v t?nh thi?t l?p nhi?u thu bao cho cc bo co trong bo co qu?n l? c?u h?nh b?n ghi d?ch v?.

Cch gi?i quy?t khc

? lm vi?c xung quanh v?n ? ny, h?y xa cc cng vi?c m b?n khng c?n ph?i c.

Lu ?N?u c r?t nhi?u cng vi?c m?c b?i v? b?n khng c? ? thi?t l?p nhi?u ki?m nh?p, h?y xa m?c ki?m nh?p khng c?n thi?t b?ng cch s? d?ng bo co qu?n l? c?u h?nh b?n ghi d?ch v?.

Thng tin thm

? bi?t thm chi ti?t v? lm th? no ? xa cc cng vi?c, h?y vo web site Microsoft TechNet sau y:

Thng tin chung v? lm th? no ? xa b? cng n vi?c lm

? bi?t thm chi ti?t v? lm th? no ? xa cc m?c ki?m nh?p, h?y vo web site Microsoft TechNet sau y:

Thng tin chung v? lm th? no ? t?o, ch?nh s?a v xa cc tiu chu?n ki?m nh?p

? bi?t thm chi ti?t v? s?n ph?m ho?c cc cng c? t? ?ng ki?m tra v?n ? ny trong 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?nSQL Server ?i l? kh?i ?ng v?n ? v?i nhi?u ?i l? cng vi?cH? th?ng Trung tm t v?n ki?m tra s? l?ng vi?c lm trn tr?ng h?p c?a SQL Server ?c kch ho?t. C? v?n t?o ra c?nh bo ny d?a trn t?nh tr?ng ny. Xem xt v xa cc cng vi?c m ?c kch ho?t v b?n khng c?n ph?i c. SQL Server 2008
SQL Server 2008 R2
SQL Server 2012

T?nh tr?ng

Microsoft ? xc nh?n r?ng y l m?t v?n ? trong s?n ph?m c?a Microsoft ?c li?t k trong ph?n "p d?ng cho".

Thu?c tnh

ID c?a bi: 2795690 - L?n xem xt sau cng: 11 Thang Ging 2013 - Xem xt l?i: 1.0
p d?ng
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Enterprise Edition
T? kha:
kbsurveynew kbtshoot kbexpertiseadvanced kbmt KB2795690 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: 2795690

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