none
关于CPU 100%(SQL Server进程98%左右) RRS feed

  • 问题

  • 2018-04-23 16:03:21.38 Server      **Dump thread - spid = 0, EC = 0x0000000000000000
    2018-04-23 16:03:21.53 Server      ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL14.SQL17\MSSQL\LOG\SQLDump0001.txt
    2018-04-23 16:03:21.54 Server      * *******************************************************************************
    2018-04-23 16:03:21.54 Server      *
    2018-04-23 16:03:21.54 Server      * BEGIN STACK DUMP:
    2018-04-23 16:03:21.54 Server      *   04/23/18 16:03:21 spid 3776
    2018-04-23 16:03:21.54 Server      *
    2018-04-23 16:03:21.54 Server      * Stalled Resource Monitor
    2018-04-23 16:03:21.54 Server      *
    2018-04-23 16:03:21.54 Server      * *******************************************************************************
    2018-04-23 16:03:21.54 Server      * -------------------------------------------------------------------------------
    2018-04-23 16:03:21.54 Server      * Short Stack Dump
    2018-04-23 16:03:22.80 Server      Stack Signature for the dump is 0x0000000000000321
    2018-04-23 16:03:43.31 Server      Timeout waiting for external dump process 7048.

    2018-04-23 16:03:43.34 Server      Resource Monitor (0x2454) Worker 0x000001D4C268E160 appears to be non-yielding on Node 0. Memory freed: 0 KB. Last wait: MISCELLANEOUS. Last clerk: type USERSTORE_DBMETADATA, name msdb. Approx CPU Used: kernel 0 ms, user 61671 ms, Interval: 62040.
    2018-04-23 16:03:53.73 Server      ***Unable to get thread context for spid 0
    2018-04-23 16:03:53.73 Server      * *******************************************************************************
    2018-04-23 16:03:53.73 Server      *
    2018-04-23 16:03:53.73 Server      * BEGIN STACK DUMP:
    2018-04-23 16:03:53.73 Server      *   04/23/18 16:03:53 spid 3776
    2018-04-23 16:03:53.73 Server      *
    2018-04-23 16:03:53.73 Server      * Non-yielding Scheduler
    2018-04-23 16:03:53.73 Server      *
    2018-04-23 16:03:53.73 Server      * *******************************************************************************
    2018-04-23 16:03:53.74 Server      Stack Signature for the dump is 0x0000000000000321
    2018-04-23 16:03:53.95 Server      DumpCallbackHk::CreateCabFile: at 2152 g_CabDdfFile file is null, normally because nocollectors added any files, exiting
    2018-04-23 16:03:53.95 Server      DumpCallbackHk::CollectFiles: at 571 failed at CreateCabFile with error: 0x80004005
    2018-04-23 16:04:14.11 Server      Timeout waiting for external dump process 16108.

    2018-04-23 16:04:14.11 Server      Process 0:0:0 (0x1408) Worker 0x0000025B3F518160 appears to be non-yielding on Scheduler 2. Thread creation time: 13168860685798. Approx Thread CPU Used: kernel 0 ms, user 59171 ms. Process Utilization 68%. System Idle 29%. Interval: 94670 ms.
    2018-04-23 16:04:14.18 Server      Process 0:0:0 (0x6468) Worker 0x000001EC399DA160 appears to be non-yielding on Scheduler 4. Thread creation time: 13168928591716. Approx Thread CPU Used: kernel 0 ms, user 60140 ms. Process Utilization 57%. System Idle 39%. Interval: 115227 ms.
    2018-04-23 16:04:14.22 Server      Process 0:0:0 (0x4588) Worker 0x0000025F454C0160 appears to be non-yielding on Scheduler 6. Thread creation time: 13168867581249. Approx Thread CPU Used: kernel 15 ms, user 59171 ms. Process Utilization 57%. System Idle 39%. Interval: 115277 ms.
    2018-04-23 16:04:19.48 Server      Process 0:0:0 (0x5d90) Worker 0x0000025F1AB04160 appears to be non-yielding on Scheduler 1. Thread creation time: 13168874375810. Approx Thread CPU Used: kernel 0 ms, user 50703 ms. Process Utilization 53%. System Idle 43%. Interval: 115459 ms.
    2018-04-23 16:04:19.67 Server      Process 0:0:0 (0x3728) Worker 0x0000025A6CA82160 appears to be non-yielding on Scheduler 5. Thread creation time: 13168812008458. Approx Thread CPU Used: kernel 0 ms, user 51875 ms. Process Utilization 53%. System Idle 43%. Interval: 115424 ms.
    2018-04-23 16:04:19.77 Server      Process 0:0:0 (0x2d60) Worker 0x00000260BCB4E160 appears to be non-yielding on Scheduler 7. Thread creation time: 13168874494481. Approx Thread CPU Used: kernel 0 ms, user 50671 ms. Process Utilization 53%. System Idle 43%. Interval: 115483 ms.
    2018-04-23 16:04:25.02 Server      Process 0:0:0 (0x1dac) Worker 0x0000025A7805A160 appears to be non-yielding on Scheduler 0. Thread creation time: 13168868714053. Approx Thread CPU Used: kernel 0 ms, user 50359 ms. Process Utilization 53%. System Idle 43%. Interval: 115691 ms.
    2018-04-23 16:04:25.18 Server      Process 0:0:0 (0x3d98) Worker 0x0000025AD611E160 appears to be non-yielding on Scheduler 3. Thread creation time: 13168865917011. Approx Thread CPU Used: kernel 15 ms, user 51171 ms. Process Utilization 53%. System Idle 43%. Interval: 115711 ms.
    2018-04-23 16:05:07.97 Server      Resource Monitor (0x2454) Worker 0x000001D4C268E160 appears to be non-yielding on Node 0. Memory freed: 0 KB. Last wait: MISCELLANEOUS. Last clerk: type USERSTORE_DBMETADATA, name msdb. Approx CPU Used: kernel 0 ms, user 128093 ms, Interval: 169033.
    2018-04-23 16:05:19.47 Server      Process 0:0:0 (0x1408) Worker 0x0000025B3F518160 appears to be non-yielding on Scheduler 2. Thread creation time: 13168860685798. Approx Thread CPU Used: kernel 0 ms, user 103562 ms. Process Utilization 65%. System Idle 32%. Interval: 180519 ms.
    2018-04-23 16:05:19.72 Server      Process 0:0:0 (0x6468) Worker 0x000001EC399DA160 appears to be non-yielding on Scheduler 4. Thread creation time: 13168928591716. Approx Thread CPU Used: kernel 0 ms, user 103968 ms. Process Utilization 65%. System Idle 32%. Interval: 180594 ms.
    2018-04-23 16:05:19.80 Server      Process 0:0:0 (0x4588) Worker 0x0000025F454C0160 appears to be non-yielding on Scheduler 6. Thread creation time: 13168867581249. Approx Thread CPU Used: kernel 15 ms, user 102750 ms. Process Utilization 65%. System Idle 32%. Interval: 180843 ms.
    2018-04-23 16:05:25.34 Server      Process 0:0:0 (0x5d90) Worker 0x0000025F1AB04160 appears to be non-yielding on Scheduler 1. Thread creation time: 13168874375810. Approx Thread CPU Used: kernel 0 ms, user 99687 ms. Process Utilization 65%. System Idle 32%. Interval: 181126 ms.
    2018-04-23 16:05:25.67 Server      Process 0:0:0 (0x3728) Worker 0x0000025A6CA82160 appears to be non-yielding on Scheduler 5. Thread creation time: 13168812008458. Approx Thread CPU Used: kernel 0 ms, user 101171 ms. Process Utilization 65%. System Idle 32%. Interval: 181556 ms.
    2018-04-23 16:05:26.29 Server      Process 0:0:0 (0x2d60) Worker 0x00000260BCB4E160 appears to be non-yielding on Scheduler 7. Thread creation time: 13168874494481. Approx Thread CPU Used: kernel 0 ms, user 100000 ms. Process Utilization 65%. System Idle 32%. Interval: 181777 ms.
    2018-04-23 16:05:31.33 Server      Process 0:0:0 (0x1dac) Worker 0x0000025A7805A160 appears to be non-yielding on Scheduler 0. Thread creation time: 13168868714053. Approx Thread CPU Used: kernel 0 ms, user 97046 ms. Process Utilization 64%. System Idle 33%. Interval: 182022 ms.
    2018-04-23 16:05:31.36 Server      Process 0:0:0 (0x3d98) Worker 0x0000025AD611E160 appears to be non-yielding on Scheduler 3. Thread creation time: 13168865917011. Approx Thread CPU Used: kernel 15 ms, user 98781 ms. Process Utilization 64%. System Idle 33%. Interval: 181965 ms.
    2018-04-23 16:06:16.05 Server      Resource Monitor (0x2454) Worker 0x000001D4C268E160 appears to be non-yielding on Node 0. Memory freed: 0 KB. Last wait: MISCELLANEOUS. Last clerk: type USERSTORE_DBMETADATA, name msdb. Approx CPU Used: kernel 0 ms, user 195203 ms, Interval: 237057.
    2018-04-23 16:06:26.22 Server      Process 0:0:0 (0x1408) Worker 0x0000025B3F518160 appears to be non-yielding on Scheduler 2. Thread creation time: 13168860685798. Approx Thread CPU Used: kernel 0 ms, user 148250 ms. Process Utilization 69%. System Idle 28%. Interval: 247252 ms.
    2018-04-23 16:06:26.29 Server      Process 0:0:0 (0x6468) Worker 0x000001EC399DA160 appears to be non-yielding on Scheduler 4. Thread creation time: 13168928591716. Approx Thread CPU Used: kernel 0 ms, user 149203 ms. Process Utilization 69%. System Idle 28%. Interval: 247337 ms.
    2018-04-23 16:06:26.35 Server      Process 0:0:0 (0x4588) Worker 0x0000025F454C0160 appears to be non-yielding on Scheduler 6. Thread creation time: 13168867581249. Approx Thread CPU Used: kernel 15 ms, user 147890 ms. Process Utilization 69%. System Idle 28%. Interval: 247388 ms.
    2018-04-23 16:06:31.61 Server      Process 0:0:0 (0x5d90) Worker 0x0000025F1AB04160 appears to be non-yielding on Scheduler 1. Thread creation time: 13168874375810. Approx Thread CPU Used: kernel 0 ms, user 143859 ms. Process Utilization 69%. System Idle 28%. Interval: 247603 ms.
    2018-04-23 16:06:31.96 Server      Process 0:0:0 (0x3728) Worker 0x0000025A6CA82160 appears to be non-yielding on Scheduler 5. Thread creation time: 13168812008458. Approx Thread CPU Used: kernel 0 ms, user 145125 ms. Process Utilization 69%. System Idle 28%. Interval: 247777 ms.
    2018-04-23 16:06:32.32 Server      Process 0:0:0 (0x2d60) Worker 0x00000260BCB4E160 appears to be non-yielding on Scheduler 7. Thread creation time: 13168874494481. Approx Thread CPU Used: kernel 0 ms, user 143921 ms. Process Utilization 69%. System Idle 28%. Interval: 248032 ms.
    2018-04-23 16:06:37.49 Server      Process 0:0:0 (0x1dac) Worker 0x0000025A7805A160 appears to be non-yielding on Scheduler 0. Thread creation time: 13168868714053. Approx Thread CPU Used: kernel 0 ms, user 142328 ms. Process Utilization 69%. System Idle 28%. Interval: 248163 ms.
    2018-04-23 16:06:37.87 Server      Process 0:0:0 (0x3d98) Worker 0x0000025AD611E160 appears to be non-yielding on Scheduler 3. Thread creation time: 13168865917011. Approx Thread CPU Used: kernel 15 ms, user 144437 ms. Process Utilization 69%. System Idle 28%. Interval: 248293 ms.
    2018-04-23 16:07:21.11 Server      Resource Monitor (0x2454) Worker 0x000001D4C268E160 appears to be non-yielding on Node 0. Memory freed: 0 KB. Last wait: MISCELLANEOUS. Last clerk: type USERSTORE_DBMETADATA, name msdb. Approx CPU Used: kernel 0 ms, user 259343 ms, Interval: 302149.
    2018-04-23 16:07:32.18 Server      Process 0:0:0 (0x1408) Worker 0x0000025B3F518160 appears to be non-yielding on Scheduler 2. Thread creation time: 13168860685798. Approx Thread CPU Used: kernel 15 ms, user 196593 ms. Process Utilization 72%. System Idle 25%. Interval: 313153 ms.
    2018-04-23 16:07:32.28 Server      Process 0:0:0 (0x6468) Worker 0x000001EC399DA160 appears to be non-yielding on Scheduler 4. Thread creation time: 13168928591716. Approx Thread CPU Used: kernel 0 ms, user 197734 ms. Process Utilization 72%. System Idle 25%. Interval: 313314 ms.
    2018-04-23 16:07:32.61 Server      Process 0:0:0 (0x4588) Worker 0x0000025F454C0160 appears to be non-yielding on Scheduler 6. Thread creation time: 13168867581249. Approx Thread CPU Used: kernel 15 ms, user 196750 ms. Process Utilization 72%. System Idle 25%. Interval: 313634 ms.
    2018-04-23 16:07:37.66 Server      Process 0:0:0 (0x5d90) Worker 0x0000025F1AB04160 appears to be non-yielding on Scheduler 1. Thread creation time: 13168874375810. Approx Thread CPU Used: kernel 15 ms, user 189109 ms. Process Utilization 71%. System Idle 26%. Interval: 313658 ms.
    2018-04-23 16:07:37.70 Server      Process 0:0:0 (0x3728) Worker 0x0000025A6CA82160 appears to be non-yielding on Scheduler 5. Thread creation time: 13168812008458. Approx Thread CPU Used: kernel 31 ms, user 191093 ms. Process Utilization 71%. System Idle 26%. Interval: 313601 ms.
    2018-04-23 16:07:37.73 Server      Process 0:0:0 (0x2d60) Worker 0x00000260BCB4E160 appears to be non-yielding on Scheduler 7. Thread creation time: 13168874494481. Approx Thread CPU Used: kernel 15 ms, user 188015 ms. Process Utilization 71%. System Idle 26%. Interval: 313467 ms.
    2018-04-23 16:07:42.86 Server      Process 0:0:0 (0x1dac) Worker 0x0000025A7805A160 appears to be non-yielding on Scheduler 0. Thread creation time: 13168868714053. Approx Thread CPU Used: kernel 15 ms, user 185093 ms. Process Utilization 71%. System Idle 26%. Interval: 313519 ms.
    2018-04-23 16:07:43.21 Server      Process 0:0:0 (0x3d98) Worker 0x0000025AD611E160 appears to be non-yielding on Scheduler 3. Thread creation time: 13168865917011. Approx Thread CPU Used: kernel 15 ms, user 186828 ms. Process Utilization 71%. System Idle 26%. Interval: 313650 ms.
    2018-04-23 16:08:26.61 Server      Resource Monitor (0x2454) Worker 0x000001D4C268E160 appears to be non-yielding on Node 0. Memory freed: 0 KB. Last wait: MISCELLANEOUS. Last clerk: type USERSTORE_DBMETADATA, name msdb. Approx CPU Used: kernel 0 ms, user 323765 ms, Interval: 367663.
    2018-04-23 16:08:37.43 Server      Process 0:0:0 (0x1408) Worker 0x0000025B3F518160 appears to be non-yielding on Scheduler 2. Thread creation time: 13168860685798. Approx Thread CPU Used: kernel 15 ms, user 240187 ms. Process Utilization 73%. System Idle 24%. Interval: 378470 ms.
    2018-04-23 16:08:37.55 Server      Process 0:0:0 (0x6468) Worker 0x000001EC399DA160 appears to be non-yielding on Scheduler 4. Thread creation time: 13168928591716. Approx Thread CPU Used: kernel 15 ms, user 241000 ms. Process Utilization 73%. System Idle 24%. Interval: 378527 ms.
    2018-04-23 16:08:37.70 Server      Process 0:0:0 (0x4588) Worker 0x0000025F454C0160 appears to be non-yielding on Scheduler 6. Thread creation time: 13168867581249. Approx Thread CPU Used: kernel 15 ms, user 241156 ms. Process Utilization 73%. System Idle 24%. Interval: 378739 ms.
    2018-04-23 16:08:43.40 Server      Process 0:0:0 (0x5d90) Worker 0x0000025F1AB04160 appears to be non-yielding on Scheduler 1. Thread creation time: 13168874375810. Approx Thread CPU Used: kernel 31 ms, user 235828 ms. Process Utilization 73%. System Idle 24%. Interval: 379382 ms.
    2018-04-23 16:08:43.67 Server      Process 0:0:0 (0x3728) Worker 0x0000025A6CA82160 appears to be non-yielding on Scheduler 5. Thread creation time: 13168812008458. Approx Thread CPU Used: kernel 31 ms, user 237406 ms. Process Utilization 73%. System Idle 24%. Interval: 379503 ms.
    2018-04-23 16:08:44.17 Server      Process 0:0:0 (0x2d60) Worker 0x00000260BCB4E160 appears to be non-yielding on Scheduler 7. Thread creation time: 13168874494481. Approx Thread CPU Used: kernel 15 ms, user 234781 ms. Process Utilization 73%. System Idle 24%. Interval: 379722 ms.
    2018-04-23 16:08:49.35 Server      Process 0:0:0 (0x1dac) Worker 0x0000025A7805A160 appears to be non-yielding on Scheduler 0. Thread creation time: 13168868714053. Approx Thread CPU Used: kernel 15 ms, user 234093 ms. Process Utilization 73%. System Idle 24%. Interval: 380013 ms.
    2018-04-23 16:08:49.45 Server      Process 0:0:0 (0x3d98) Worker 0x0000025AD611E160 appears to be non-yielding on Scheduler 3. Thread creation time: 13168865917011. Approx Thread CPU Used: kernel 31 ms, user 234656 ms. Process Utilization 73%. System Idle 24%. Interval: 380035 ms.
    2018-04-23 16:09:05.27 Server      SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.

    Microsoft SQL Server 2017 (RTM-CU4) (KB4056498) - 14.0.3022.28 (X64) 
    Feb  9 2018 19:39:09 
    Copyright (C) 2017 Microsoft Corporation
    Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)

    在任务管理器里CPU就是100%,SQL Server进程占用98% 99%。。也没什么特别任务在跑,客户端连接报错:

    在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: TCP Provider, error: 0 - 等待的操作过时。)

    在服务器本机也不能建立连接,也就是没法看状况。有部署无群集异步ALWAYSON。重启后一切正常

    阿里云ECS

    SQLDump0001.txt

    Current time is 16:03:21 04/23/18.                                                                               
    =====================================================================                                            
           BugCheck Dump                                                                                             
    =====================================================================                                            
                                                                                                                     
    This file is generated by Microsoft SQL Server                                                                   
    version 14.0.3022.28                                                                                             
    upon detection of fatal unexpected error. Please return this file,                                               
    the query or program that produced the bugcheck, the database and                                                
    the error log, and any other pertinent information with a Service Request.                                       
                                                                                                                     
                                                                                                                     
    Computer type is Intel(R) Xeon(R) CPU E5-2680 v3 @ 2.50GHz.                                                      
    Bios Version is BOCHS  - 1                                                                                       
    8 X64 level 8664, 10 Mhz processor (s).                                                                          
    Windows NT 6.2 Build 9200 CSD .                                                                                  
                                         
    Memory                               
    MemoryLoad = 94%                     
    Total Physical = 16383 MB            
    Available Physical = 889 MB          
    Total Page File = 20748 MB           
    Available Page File = 3597 MB        
    Total Virtual = 134217727 MB         
    Available Virtual = 133603715 MB     
    **Dump thread - spid = 0, EC = 0x0000000000000000                                                                
    ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL14.SQL17\MSSQL\LOG\SQLDump0001.txt        
    * *******************************************************************************                                
    *                                                                                                                
    * BEGIN STACK DUMP:                                                                                              
    *   04/23/18 16:03:21 spid 3776                                                                                  
    *                                                                                                                
    * Stalled Resource Monitor                                                                                       
    *                                                                                                                
    * *******************************************************************************                                
    * -------------------------------------------------------------------------------                                
    * Short Stack Dump                   


    SQL Server 2016 ~ 2000 性能优化、方案设计 QQ:315054403 田园嘉兴

    2018年4月23日 8:25

全部回复