Java自学者论坛

 找回密码
 立即注册

手机号码,快捷登录

恭喜Java自学者论坛(https://www.javazxz.com)已经为数万Java学习者服务超过8年了!积累会员资料超过10000G+
成为本站VIP会员,下载本站10000G+会员资源,会员资料板块,购买链接:点击进入购买VIP会员
查看: 10|回复: 0

SQL SERVER 2014 Agent服务异常停止案例

[复制链接]
  • TA的每日心情
    奋斗
    昨天 19:16
  • 签到天数: 66 天

    [LV.6]常住居民II

    1348

    主题

    1348

    帖子

    3万

    积分

    管理员

    Rank: 9Rank: 9Rank: 9

    积分
    32858
    发表于 2021-6-10 17:13:44 | 显示全部楼层 |阅读模式

       生产环境一数据库服务器(SQL Server 2014)的Agent服务突然停掉了,检查了错误日志,发现在"SQL Server Agent"里面没有"SQLServerAgent terminated (normally)"的信息,只有如下错误信息

    clipboard

     

    根据作业运行的日志信息,以及上面错误信息,可以判断SQL SERVER Agent服务应该在2016-04-24 9:20: PM(21:20)异常停止了。在“Windows Logs”下的“System”日志下,有如下错误信息,我们可以确定SQL Agent在这个时间点异常结束了,但是从这些信息还不知道发生了什么导致SQL Agent服务异常终止。

    The SQL Server Agent (MSSQLSERVER) service terminated unexpectedly.  It has done this 1 time(s).

    clipboard[1]

     

    在“Windows Logs”下的“Application”可以看到更详细的错误信息

    clipboard[2]

    The description for Event ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
     
    If the event originated on another computer, the display information had to be saved with the event.
     
    The following information was included with the event: 
     
    SQLServerAgent Monitor failed to restart SQLServerAgent after SQLServerAgent terminated unexpectedly (reason: SQLSCMControl() returned error 5, 'Access is denied.').
     
    the message resource is present but the message is not found in the string/message table

     

    在C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log里面发现这个时间点生成了SQLDUMPER_ERRORLOG.log和SQLDmpr0001.mdmp

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Parameter 1: 9472

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Parameter 2: 0

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Parameter 3: 0:0

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Parameter 4: 0000000000A0D8D8

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ProcessID = 9472

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ThreadId = 0

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Flags = 0x0

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     MiniDumpFlags = 0x0

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     SqlInfoPtr = 0x0000000000A0D8D8

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     DumpDir = <NULL>

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExceptionRecordPtr = 0x0000000000000000

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ContextPtr = 0x0000000000000000

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExtraFile = <NULL>

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     PatternForExtraFiles = <NULL>

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     InstanceName = <NULL>

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ServiceName = <NULL>

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used

    (B40:1B9C) 04/24/16 21:20:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\SQLDmpr0001.mdmp

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Total Buffer pool data pages filtered out: 0 KB

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Total Hekaton data pages filtered out: 0 KB

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Total Free memory (from non top level allocators) filtered out: 0 KB

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Total top level free memory filtered out: 0 KB

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Total Log pool memory filtered out: 0 KB

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\120\Shared\dbghelp.dll'

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\120\Shared\dbghelp.dll' : '6.12:2.633'

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\120\Shared\dbghelp.dll' : '6.12:2.633'

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\120\Shared\SQLDUMPER.EXE'

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\120\Shared\SQLDUMPER.EXE' : '2014.120:2000.8'

    (B40:1B9C) 04/24/16 21:20:02, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\120\Shared\SQLDUMPER.EXE' : '12.0:2000.8'

    (B40:1B9C) 04/24/16 21:20:02, ACTION,              SQLAGENT.EXE, Watson Invoke: No

     

    根据这里红色部分信息判断,应该是内存收缩(memory shrunk)导致的。追查到此处,是什么具体操作导致,已经无法判断,追查。特此记录一下这个案例。

    哎...今天够累的,签到来了1...
    回复

    使用道具 举报

    您需要登录后才可以回帖 登录 | 立即注册

    本版积分规则

    QQ|手机版|小黑屋|Java自学者论坛 ( 声明:本站文章及资料整理自互联网,用于Java自学者交流学习使用,对资料版权不负任何法律责任,若有侵权请及时联系客服屏蔽删除 )

    GMT+8, 2021-6-22 22:25 , Processed in 0.055575 second(s), 29 queries .

    Powered by Discuz! X3.4

    Copyright © 2001-2020, Tencent Cloud.

    快速回复 返回顶部 返回列表