none
SQL Server frozen, this is happening every 8 or 6 six days, RRS feed

  • Question

  • This is the error:

    Server log:

    Date 10/8/2019 1:21:21 AM
    Log SQL Server (Archive #1 - 10/8/2019 7:09:00 AM)

    Source Server

    Message
    New queries assigned to process on Node 1 have not been picked up by a worker thread in the last 300 seconds. Blocking or long-running queries can contribute to this condition, and may degrade client response time. Use the "max worker threads" configuration option to increase number of allowable threads, or optimize current running queries. SQL Process Utilization: 24%. System Idle: 67%.

    This is the text file

                                                                                                                                                                                                                                                                                                                                                                                            

    Current time is 01:21:02 10/08/19.                                                                               
    =====================================================================                                            
           BugCheck Dump                                                                                             
    =====================================================================                                            

    This file is generated by Microsoft SQL Server                                                                   
    version 11.0.7462.6                                                                                              
    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-2643 0 @ 3.30GHz.                                                       
    Bios Version is HP     - 2                                                                                       
    8 X64 level 8664, 3 Mhz processor (s).                                                                           
    Windows NT 6.2 Build 9200 CSD .                                                                                  

    Memory                               
    MemoryLoad = 53%                     
    Total Physical = 131037 MB           
    Available Physical = 60906 MB        
    Total Page File = 150402 MB          
    Available Page File = 78606 MB       
    Total Virtual = 134217727 MB         
    Available Virtual = 134098520 MB     
    **Dump thread - spid = 0, EC = 0x0000000000000000                                                                
    ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL11.SQL\MSSQL\LOG\SQLDump0005.txt          
    * *******************************************************************************                                
    *                                                                                                                
    * BEGIN STACK DUMP:                                                                                              
    *   10/08/19 01:21:02 spid 11568                                                                                 
    *                                                                                                                
    * Deadlocked Schedulers                                                                                          
    *                                                                                                                
    * *******************************************************************************                                
    * -------------------------------------------------------------------------------                                
    * Short Stack Dump                   

    Thursday, October 10, 2019 6:13 PM

All replies

  • You appear to be already running the latest version of SQL 2012.

    You could try this hotfix, but may not fix your problem:

    https://support.microsoft.com/en-us/help/4091266/on-demand-hotfix-update-package-for-sql-server-2012-sp4

    You should contact MS Support for a fix.   They should be able to help you with your problem.



    Thursday, October 10, 2019 6:35 PM
    Moderator
  • You should contact MS Support for a fix.   They should be able to help you with your problem.

    Tom is correct so far, that this is a deficiency in the product. Alas, the
    chances for a fix may be slim, unless you have a really good support contract, since SQL 2012 is out of mainstream support.

    However, it is possible that CSS will be able to track down the conditions that leads to this situation so that you work around it.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Thursday, October 10, 2019 9:30 PM
  • Hi AzurelioFelix,

     

    Maybe you can ask professional engineer for help, and they will deal with your problem separately and confidentially.https://support.microsoft.com/en-us/assistedsupportproducts

     

    Hope this could help you .

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, October 11, 2019 8:50 AM