none
sql2008服务自动停止的问题 RRS feed

  • 问题

  • sql2008是业务的数据库,特殊的操作就是通过链式服务器对oracle进行操作,操作都是通过sql的作业进行的。

    最近经常出现自动停止的服务。我看了sql的日志,错误显示是17311(sql2008已经打补丁了)。

    我看了一下日志中的trc文件,发现在服务停止之前出现了一个sort warning的警告,而且有时会出现10多个,不知道是不是这个原因引起的。大家能帮忙分析一下吗?

    我也有mdmp文件,有达人需要的我也可以发给各位。

    trc显示如下

    Sort Warnings SQLAgent - TSQL JobStep (Job 0x2FA0306F29D88B4CB380721693062219 : Step 1)
    Audit Server Starts And Stops  

    谢谢各位大侠,我把全部的错误信息都贴上了(放在网盘里了),麻烦各位帮看看。http://dl.vmall.com/c05t45ucbz 

    2012年10月11日 3:31

全部回复

  • 你是用Linked server吗?如果是的话可能跟Provider有关系。 你可以用Windebug分析一下MINI DUMP文件。或者找一个DUMP分析网站上传DUMP文件作分析。

    2012年10月11日 5:03
  • 你是用Linked server吗?如果是的话可能跟Provider有关系。 你可以用Windebug分析一下MINI DUMP文件。或者找一个DUMP分析网站上传DUMP文件作分析。


    DUMP分析是分析mdmp文件吗?
    2012年10月11日 6:52
  • 是的。mdmp是SQL Server的MINI DUMP,一般像你这种问题分析DUMP可以找到根源(以前曾经碰到过第三方的OLE DB Driver导致SQL Server Crash的)。

    关于MINI DUMP你可以参考这篇文章:

    Looking deeper into SQL Server using Minidumps

    http://blogs.msdn.com/b/sqlcat/archive/2009/09/11/looking-deeper-into-sql-server-using-minidumps.aspx

    2012年10月11日 8:02
  • Does sql service stop or sql agent service stop? Does it restart itself? Can you post last several lines in sql server log before service stopping?
    2012年10月11日 13:08
  • 分析dump一般是微软的支持工程师比较专业的人士对SQLSERVER和Windows非常了解的人士分析的,一般人不容易理解dump里面的内容。

    最好LZ提供一下SQLSERVER ERROR LOG一般error log里都有记录错误信息的,LZ可以导出一个log文件,然后把log文件里面的内容贴出来让大家分析


    给我写信: QQ我:点击这里给我发消息

    2012年10月11日 15:15
  • Sql server log itself is text file.
    2012年10月11日 15:29
  • 是啊rmiao大侠,但是LZ有可能不知道路径,所以我才叫LZ导出error log 文件


    给我写信: QQ我:点击这里给我发消息

    2012年10月11日 15:51
  • 另外有DUMP的话可以把DUMP的TXT文件也贴出来看看。

    2012年10月12日 1:11
  • 这里有个网站可以免费分析DUMP,不过是使用最简单的使用!Analyze -v 命令,你可以试试看。

    http://www.osronline.com/page.cfm?name=analyze

    2012年10月12日 2:25
  • dump的txt文本1:

    Current time is 13:52:00 10/10/12.                                                                              
    =====================================================================                                           
           BugCheck Dump                                                                                            
    =====================================================================                                            
                                                                                                                   
    This file is generated by Microsoft SQL Server                                                                  
    version 10.0.5500.0                                                                                             
    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           E5620  @ 2.40GHz.                                               
    Bios Version is HP     - 2                                                                                      
    8 Intel x86 level 6, 2399 Mhz processor (s).                                                                    
    Windows NT 5.2 Build 3790 CSD Service Pack 2.                                                                   
                                        
    Memory                              
    MemoryLoad = 12%                    
    Total Physical = 8181 MB            
    Available Physical = 7134 MB        
    Total Page File = 10034 MB          
    Available Page File = 9131 MB       
    Total Virtual = 2047 MB             
    Available Virtual = 223 MB          
    **Dump thread - spid = 0, EC = 0x00000000                                                                       
    ***Stack Dump being sent to E:\SQL\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0016.txt                                
    * *******************************************************************************                               
    *                                                                                                               
    * BEGIN STACK DUMP:                                                                                             
    *   10/10/12 13:52:00 spid 1180                                                                                 
    *                                                                                                               
    * ex_handle_except encountered exception C0000005 - Server terminating                                          
    *                                                                                                               
    *                                                                                                               
    *  MODULE                          BASE      END       SIZE                                                     
    * sqlservr                       01000000  039B7FFF  029b8000                                                   
    * ntdll                          7C930000  7C9FFFFF  000d0000                                                   
    * kernel32                       7C800000  7C92AFFF  0012b000                                                   
    * MSVCR80                        78130000  781CAFFF  0009b000                                                   
    * msvcrt                         77B70000  77BC9FFF  0005a000                                                   
    * MSVCP80                        7C420000  7C4A6FFF  00087000                                                   
    * ADVAPI32                       77F30000  77FDAFFF  000ab000                                                   
    * RPCRT4                         77C20000  77CBEFFF  0009f000                                                   
    * Secur32                        76EB0000  76EC2FFF  00013000                                                   
    * sqlos                          344D0000  344D5FFF  00006000                                                   
    * pdh                            724A0000  724EDFFF  0004e000                                                   
    * SHLWAPI                        77EB0000  77F01FFF  00052000                                                   

    2012年10月12日 8:15
  • * GDI32                          77BD0000  77C17FFF  00048000                                                   
    * USER32                         77E10000  77E9FFFF  00090000                                                   
    * comdlg32                       761A0000  761E6FFF  00047000                                                   
    * COMCTL32                       77370000  77406FFF  00097000                                                   
    * SHELL32                        7CA10000  7D1EAFFF  007db000                                                   
    * ole32                          774B0000  775E8FFF  00139000                                                   
    * OLEAUT32                       775F0000  7767AFFF  0008b000                                                   
    * ODBC32                         4B750000  4B78CFFF  0003d000                                                   
    * odbcbcp                        4D3A0000  4D3A5FFF  00006000                                                   
    * VERSION                        77B60000  77B67FFF  00008000                                                   
    * CRYPT32                        760A0000  76130FFF  00091000                                                   
    * MSASN1                         76080000  76091FFF  00012000                                                   
    * USERENV                        75870000  7592CFFF  000bd000                                                   
    * WINMM                          769E0000  76A09FFF  0002a000                                                   
    * opends60                       333E0000  333E6FFF  00007000                                                   
    * NETAPI32                       71BA0000  71BF6FFF  00057000                                                   
    * BatchParser                    520C0000  520DEFFF  0001f000                                                   
    * IMM32                          76180000  7619CFFF  0001d000                                                   
    * LPK                            7F000000  7F008FFF  00009000                                                   
    * USP10                          74AE0000  74B44FFF  00065000                                                   
    * comctl32                       77CD0000  77DD2FFF  00103000                                                   
    * odbcint                        00A70000  00A81FFF  00012000                                                   
    * psapi                          76AB0000  76ABAFFF  0000b000                                                   
    * instapi10                      00BF0000  00BF9FFF  0000a000                                                   
    * sqlevn70                       4F610000  4F810FFF  00201000                                                   
    * sqlevn70                       039C0000  03BC0FFF  00201000                                                   
    * rsaenh                         68000000  68034FFF  00035000                                                   
    * AUTHZ                          76BA0000  76BB3FFF  00014000                                                   
    * MSCOREE                        34370000  343B5FFF  00046000                                                   
    * msv1_0                         76BF0000  76C16FFF  00027000                                                   
    * WS2_32                         71B60000  71B76FFF  00017000                                                   
    * WS2HELP                        71B50000  71B57FFF  00008000                                                   
    * iphlpapi                       76C50000  76C68FFF  00019000                                                   
    * kerberos                       71C00000  71C56FFF  00057000                                                   
    * cryptdll                       76620000  7662BFFF  0000c000                                                   
    * schannel                       76690000  766B6FFF  00027000                                                   
    * security                       71E90000  71E93FFF  00004000                                                   
    * ftimport                       63460000  6347CFFF  0001d000                                                   
    * MSFTE                          63480000  636D9FFF  0025a000                                                   
    * dbghelp                        636F0000  63804FFF  00115000                                                   
    * WINTRUST                       76B10000  76B3AFFF  0002b000                                                   
    * imagehlp                       76B70000  76B97FFF  00028000                                                   
    * NTMARTA                        777E0000  777FFFFF  00020000                                                   
    * WLDAP32                        76E70000  76E9DFFF  0002e000                                                   
    * SAMLIB                         63AF0000  63AFEFFF  0000f000                                                   
    * dssenh                         68100000  68126FFF  00027000                                                   
    * mswsock                        71A80000  71ABFFFF  00040000                                                   
    * hnetcfg                        69660000  696B6FFF  00057000                                                   
    * wshtcpip                       71A40000  71A47FFF  00008000                                                   
    * wshqos                         63FC0000  63FC9FFF  0000a000                                                   
    * ntdsapi                        76630000  76643FFF  00014000                                                   
    * DNSAPI                         76E30000  76E5AFFF  0002b000                                                   
    * xpsp2res                       65740000  65C88FFF  00549000                                                   
    * CLBCatQ                        77680000  77702FFF  00083000                                                   
    * COMRes                         76F70000  770C9FFF  0015a000                                                   
    * sqlncli10                      65C90000  65F06FFF  00277000                                                   
    * SQLNCLIR10                     648E0000  64917FFF  00038000                                                   
    * xpstar                         65F10000  65F5BFFF  0004c000                                                   
    * SQLSCM                         65F70000  65F78FFF  00009000                                                   
    * ATL80                          7C630000  7C64AFFF  0001b000                                                   
    * xpstar                         65F90000  65FB5FFF  00026000                                                   
    * mlang                          66050000  660E2FFF  00093000                                                   
    * xplog70                        661D0000  661DBFFF  0000c000                                                   
    * xplog70                        661F0000  661F2FFF  00003000                                                   
    * xprepl                         64BA0000  64BB1FFF  00012000                                                   
    * xpsqlbot                       00D00000  00D05FFF  00006000                                                   
    * oledb32                        64620000  64698FFF  00079000                                                   
    * MSDART                         646A0000  646B9FFF  0001a000                                                   
    * OLEDB32R                       64880000  6488AFFF  0000b000                                                   
    *
    2012年10月12日 8:17
  •  comsvcs                        64FF0000  65134FFF  00145000                                                   
    * msdaora                        72260000  722A0FFF  00041000                                                   
    * MSDATL3                        64BE0000  64BF4FFF  00015000                                                   
    * MSDAORAR                       64C00000  64C03FFF  00004000                                                   
    * oci                            65140000  6515AFFF  0001b000                                                   
    * OCIW32                         65160000  65168FFF  00009000                                                   
    * ORACLIENT9                     65170000  652C3FFF  00154000                                                   
    * oracore9                       652D0000  65366FFF  00097000                                                   
    * oranls9                        65370000  653D7FFF  00068000                                                   
    * oraunls9                       653E0000  653EEFFF  0000f000                                                   
    * oravsn9                        653F0000  653F5FFF  00006000                                                   
    * oracommon9                     65400000  6547DFFF  0007e000                                                   
    * orageneric9                    65480000  65612FFF  00193000                                                   
    * oran9                          65620000  656D8FFF  000b9000                                                   
    * oranl9                         656E0000  6570BFFF  0002c000                                                   
    * oranldap9                      65710000  6571EFFF  0000f000                                                   
    * orannzsbb9                     66240000  662C7FFF  00088000                                                   
    * oraldapclnt9                   662D0000  662F0FFF  00021000                                                   
    * orancrypt9                     65720000  65730FFF  00011000                                                   
    * WSOCK32                        71B10000  71B1AFFF  0000b000                                                   
    * ORATRACE9                      66300000  6633FFFF  00040000                                                   
    * oranro9                        66340000  66376FFF  00037000                                                   
    * oranhost9                      66380000  66385FFF  00006000                                                   
    * oranoname9                     66390000  66395FFF  00006000                                                   
    * orancds9                       663A0000  663A5FFF  00006000                                                   
    * orantns9                       663B0000  663B5FFF  00006000                                                   
    * oranms                         663C0000  663C6FFF  00007000                                                   
    * oranmsp                        663D0000  663DFFFF  00010000                                                   
    * orapls9                        663E0000  665E3FFF  00204000                                                   
    * oraslax9                       665F0000  665F6FFF  00007000                                                   
    * orasnls9                       66600000  6660FFFF  00010000                                                   
    * orawtc9                        66610000  66615FFF  00006000                                                   
    * orasql9                        66620000  66693FFF  00074000                                                   
    * orantcp9                       66F00000  66F0BFFF  0000c000                                                   
    * msadce                         66DD0000  66E27FFF  00058000                                                   
    * msadcer                        66E30000  66E32FFF  00003000                                                   
    * mswstr10                       672C0000  67354FFF  00095000                                                   
    * winrnr                         76ED0000  76ED6FFF  00007000                                                   
    * rasadhlp                       76EE0000  76EE4FFF  00005000                                                   
    * dbghelp                        67C00000  67D14FFF  00115000                                                   
    *                                                                                                               
    *        Edi: 00000000:                                                                                         
    *        Esi: 00000000:                                                                                         
    *        Eax: 62447328:  000042AC  00000000  00000000  7C80BEE7  00000000  00000002                             
    *        Ebx: 0000003F:                                                                                         
    *        Ecx: 62447994:  00000000  00010007  006A0068  001916CC  62447354  62447328                             
    *        Edx: 62448198:  00780065  0068005F  006E0061  006C0064  005F0065  00780065                             
    *        Eip: 7C80BEE7:  10C2C95E  01093D00  840FC000  00000095  F29DE950  9090FFFF                             
    *        Ebp: 62447378:  624473BC  0271B384  000042AC  00000000  00000000  00000000                             
    *      SegCs: 0000001B:                                                                                         
    *     EFlags: 00000246:                                                                                         
    *        Esp: 62447324:  00000000  000042AC  00000000  00000000  7C80BEE7  00000000                             
    *      SegSs: 00000023:                                                                                         
    * *******************************************************************************                               
    * -------------------------------------------------------------------------------                               
    * Short Stack Dump                                                                                              
    7C80BEE7 Module(kernel32+0000BEE7)                                                                              
    0271B384 Module(sqlservr+0171B384)                                                                              
    0271EEB1 Module(sqlservr+0171EEB1)                                                                              
    0271EA4D Module(sqlservr+0171EA4D)                                                                              
    02A383B1 Module(sqlservr+01A383B1)                                                                              
    7C8361B7 Module(kernel32+000361B7)                                                                              
    77B93E74 Module(msvcrt+00023E74)                                                                                
    77B9B547 Module(msvcrt+0002B547)                                                                                
    7C824829 Module(kernel32+00024829)  
    2012年10月12日 8:19
  • It's 32-bit machine with 8gb memory? Which edition of sql? How did you configure memory for sql?
    2012年10月12日 13:20
  • 你的数据库版本是什么?个人猜测应该是某个DLL文件导致的这个问题,你可以将DUMP文件上传到在线分析网站然后把结果贴出来。

    另外如果你使用了第三方的Provider创建Linked server,可以尝试将OLE DB的属性更改为In-process。

    2012年10月12日 14:24
  • 将OLE DB的属性更改为In-process? in-process是什么属性呢请问,怎么改属性

    给我写信: QQ我:点击这里给我发消息

    2012年10月15日 3:20