December 11, 2012 at 8:09 am
Hello Friends,
I am getting below issue.
Minidump is getting cretaed in every minute on my SQL 2008 instance (Standard Edition with RTM verison - 10.0.2734)
It has 8 GB RAM out of which around 6 - 6.5 GB is used constantly.
Below is snap of the dump file
extract of SQLDUMPER_error Log ::
3EE8:62A4) 12/11/12 09:39:57, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Dump is associated with file J:\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump10000.txt
(3EE8:62A4) 12/11/12 09:39:57, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(3EE8:62A4) 12/11/12 09:39:57, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(3EE8:62A4) 12/11/12 09:39:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(3EE8:62A4) 12/11/12 09:39:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: J:\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDmpr1393.mdmp
(3EE8:62A4) 12/11/12 09:39:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(3EE8:62A4) 12/11/12 09:39:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(3EE8:62A4) 12/11/12 09:39:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(3EE8:62A4) 12/11/12 09:39:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(3EE8:62A4) 12/11/12 09:39:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2007.100:1600.22'
(3EE8:62A4) 12/11/12 09:39:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.0:1600.22'
(3EE8:62A4) 12/11/12 09:39:58, ACTION, sqlservr.exe, Watson Invoke: No
(6610:3AB8) 12/11/12 09:40:02, ACTION, sqlservr.exe, Watson Invoke: No
(6238:72C) 12/11/12 09:40:06, ERROR , sqlservr.exe, FileCopy: Unable to read/write file, error 112
(6238:72C) 12/11/12 09:40:06, ACTION, sqlservr.exe, Watson Invoke: No
(4274:686C) 12/11/12 09:40:10, ERROR , sqlservr.exe, FileCopy: Unable to read/write file, error 112
(4274:686C) 12/11/12 09:40:10, ACTION, sqlservr.exe, Watson Invoke: No
(4318:7A70) 12/11/12 09:40:14, ERROR , sqlservr.exe, FileCopy: Unable to read/write file, error 112
(4318:7A70) 12/11/12 09:40:14, ACTION, sqlservr.exe, Watson Invoke: No
(5AF0:31C4) 12/11/12 09:40:23, ERROR , sqlservr.exe, FileCopy: Unable to read/write file, error 112
(5AF0:31C4) 12/11/12 09:40:23, ACTION, sqlservr.exe, Watson Invoke: No
(2F5C:5EF4) 12/11/12 09:40:27, ERROR , sqlservr.exe, FileCopy: Unable to read/write file, error 112
(2F5C:5EF4) 12/11/12 09:40:27, ACTION, sqlservr.exe, Watson Invoke: No
(5210:5784) 12/11/12 09:40:31, ERROR , sqlservr.exe, FileCopy: Unable to read/write file, error 112
(5210:5784) 12/11/12 09:40:31, ACTION, sqlservr.exe, Watson Invoke: No
(49D0:4838) 12/11/12 09:40:35, ERROR , sqlservr.exe, FileCopy: Unable to read/write file, error 112
(49D0:4838) 12/11/12 09:40:35, ACTION, sqlservr.exe, Watson Invoke: No
(4CD8:75C4) 12/11/12 09:40:39, ERROR , sqlservr.exe, FileCopy: Unable to read/write file, error 112
(4CD8:75C4) 12/11/12 09:40:39, ACTION, sqlservr.exe, Watson Invoke: No
=================================================================
Extract from SQLDUMP----.txt
Current time is 14:37:04 12/11/12.
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 10.0.2734.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 Quad-Core AMD Opteron(tm) Processor 2347 HE.
Bios Version is HP - 2
8 X64 level 8664, 1 Mhz processor (s).
Windows NT 6.1 Build 7600 CSD .
Memory
MemoryLoad = 81%
Total Physical = 8189 MB
Available Physical = 1539 MB
Total Page File = 23982 MB
Available Page File = 14362 MB
Total Virtual = 8388607 MB
Available Virtual = 8373495 MB
***Stack Dump being sent to J:\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump10000.txt
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 12/11/12 14:37:04 spid 51
*
*
* Exception Address = 0000000000101926 Module(sqlservr+00000000000B1926)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address FFFFFFFFFFFFFFFF
* Input Buffer 116 bytes -
* s p _ G e t P u 17 00 73 00 70 00 5f 00 47 00 65 00 74 00 50 00 75 00
* b l i c K e y F o 62 00 6c 00 69 00 63 00 4b 00 65 00 79 00 46 00 6f 00
* r S M S I D §) 72 00 53 00 4d 00 53 00 49 00 44 00 00 00 00 00 a7 29
* 2) GUID:261D3 00 09 04 00 01 32 29 00 47 55 49 44 3a 32 36 31 44 33
* 461-7DC5-4DB7-82BA 34 36 31 2d 37 44 43 35 2d 34 44 42 37 2d 38 32 42 41
* -158C6DF5C944 § 2d 31 35 38 43 36 44 46 35 43 39 34 34 00 00 a7 01 00
* 2 0 09 04 00 01 32 01 00 30
==============================
Kindly help..
December 11, 2012 at 9:54 am
What is running under spid 51?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 11, 2012 at 2:21 pm
MyDoggieJessie (12/11/2012)
What is running under spid 51?
and what does the procedure sp_GetPublicKeyForSMSID do?
that's what's causing the exception i think...or at let the process that does the work.
...every minute sounds like an application that auto connects over and over? maybe some monitoring software you installed?
Lowell
December 12, 2012 at 2:16 am
@Jessie :
THis server hosts Primary Site SCCM applicaiton and the Database is replica of production Site DB
SPid 51 is executing one procedure (dbo.MP_GetMachinePolicyAssignments) -- see the attached code
This procedure is available, but as this is production, should i have to execute this to find what it is doing
December 12, 2012 at 8:55 am
I think the spid 51 might be the culprit - Can you temporarily comment out the code in the attached script? I mean, if this is the issue and something is doing this check every minute around the clock then your mini-dumps should go away right? Otherwise the issue lays elsewhere
Can you try that?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply