Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
perchi
Starting Member
3 Posts |
 Posted - 2008-08-28 : 13:41:53
|
| I just noticed today that I keep getting these three files every minute or so. I can open .txt and .log but don't understand anything in there and .mdmp looks like a binary file. I am not sure what they mean but it is taking up a bunch of disk space. Please let me know what I need to do to fix or stop this problem. Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
perchi
Starting Member
3 Posts |
Posted - 2008-08-28 : 13:50:04
|
| Here's a snippet of the last .txt. Thanks again.===================================================================== BugCheck Dump ===================================================================== This file is generated by Microsoft SQL Server version 9.00.1399.06 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 AT/AT COMPATIBLE. Bios Version is PTLTD - 6040000 PhoenixBIOS 4.0 Release 6.0 Current time is 12:44:00 08/28/08. 1 Intel x86 level 15, 3 Mhz processor (s). Windows NT 5.2 Build 3790 CSD Service Pack 1. Memory MemoryLoad = 78% Total Physical = 383 MB Available Physical = 81 MB Total Page File = 1357 MB Available Page File = 118 MB Total Virtual = 2047 MB Available Virtual = 1529 MB **Dump thread - spid = 15, PSS = 0x03A007B0, EC = 0x03A007B8 ***Stack Dump being sent to C:\PROGRA~1\COMMON~2\MSSQL.1\MSSQL\LOG\SQLDump10000.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 08/28/08 12:44:00 spid 15 * * Location: page.cpp:3364 * Expression: GetGhostRecCount () > 0 * SPID: 15 * Process ID: 1936 * * * * MODULE BASE END SIZE * sqlservr 01000000 02BA7FFF 01ba8000 * ntdll 7C800000 7C8BFFFF 000c0000 * kernel32 77E40000 77F41FFF 00102000 * MSVCR80 78130000 781CAFFF 0009b000 * msvcrt 77BA0000 77BF9FFF 0005a000 * MSVCP80 7C420000 7C4A6FFF 00087000 * ADVAPI32 77F50000 77FEBFFF 0009c000 * RPCRT4 77C50000 77CEEFFF 0009f000 * USER32 77380000 77411FFF 00092000 * GDI32 77C00000 77C48FFF 00049000 * CRYPT32 761B0000 76242FFF 00093000 * MSASN1 76190000 761A1FFF 00012000 * Secur32 76F50000 76F62FFF 00013000 * MSWSOCK 71B20000 71B60FFF 00041000 * WS2_32 71C00000 71C16FFF 00017000 * WS2HELP 71BF0000 71BF7FFF 00008000 * USERENV 76920000 769E3FFF 000c4000 * opends60 333E0000 333E6FFF 00007000 * NETAPI32 71C40000 71C97FFF 00058000 * SHELL32 7C8D0000 7D0D3FFF 00804000 * SHLWAPI 77DA0000 77DF1FFF 00052000 * comctl32 77420000 77522FFF 00103000 * psapi 76B70000 76B7AFFF 0000b000 * instapi 48060000 48069FFF 0000a000 * sqlevn70 4F610000 4F7A0FFF 00191000 * SQLOS 344D0000 344D4FFF 00005000 * rsaenh 68000000 6802EFFF 0002f000 * AUTHZ 76C40000 76C53FFF 00014000 * MSCOREE 79000000 79044FFF 00045000 * ole32 77670000 777A3FFF 00134000 * msv1_0 76C90000 76CB6FFF 00027000 * iphlpapi 76CF0000 76D09FFF 0001a000 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-28 : 13:50:57
|
| Why aren't you running service pack 2 for SQL Server 2005? You also should install the latest cumulative update package.You are currently at build 1399. There have been a ton of bug fixes since then. Get to the latest version!Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
perchi
Starting Member
3 Posts |
Posted - 2008-08-28 : 13:56:50
|
| I will try and upgrade/update. I am not even sure if this is a full blown SQL Server 2005. I think this came with the 3rd party software (CommonTime) that is installed on the server. Thanks for the help. |
|
|
|
|
|
|
SQLdump*.mdmp , .txt, .log