Minidump getting created on every minute 2008 Standard Edition

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Minidump getting created on every minute 2008...

Minidump getting created on every minute 2008 Standard Edition

Rate Topic

Display Mode

Topic Options

Author

Message

chetanr.jain

Posted Tuesday, December 11, 2012 8:09 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 20, 2013 9:13 AM
Points: 465, Visits: 437

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..

Post #1395146

MyDoggieJessie

Posted Tuesday, December 11, 2012 9:54 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 2,037, Visits: 3,761

What is running under spid 51?

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" Wink

Post #1395217

Lowell

Posted Tuesday, December 11, 2012 2:21 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 11,642, Visits: 27,729

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1395325

chetanr.jain

Posted Wednesday, December 12, 2012 2:16 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 20, 2013 9:13 AM
Points: 465, Visits: 437

@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

@Lowell
This procedure is available, but as this is production, should i have to execute this to find what it is doing

Post Attachments

MP_GetMachinePolicyAssignments.txt (6 views, 23.90 KB)

Post #1395518

MyDoggieJessie

Posted Wednesday, December 12, 2012 8:55 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 2,037, Visits: 3,761

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; They'll drag you down to their level and beat you with experience" Wink

Post #1395727

« Prev Topic | Next Topic »

Permissions