February 10, 2010 at 4:30 am
My laptop started complaining when the Sql Server log folder reached 34Gbs!
It turns out that my SQL Server 2008 sp1 throws a dump every few seconds and I have no clue why (otherwise I'd fix it!).
The beginning of SQLDump0001.txt looks like this
Current time is 10:58:26 02/10/10.
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 10.0.2531.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) Core(TM)2 Duo CPU T7250 @ 2.00GHz.
Bios Version is DELL - 27d80514
Phoenix ROM BIOS PLUS Version 1.10 A12
2 Intel x86 level 6, 3 Mhz processor (s).
Windows NT 5.1 Build 2600 CSD Service Pack 3.
Memory
MemoryLoad = 59%
Total Physical = 3581 MB
Available Physical = 1465 MB
Total Page File = 5463 MB
Available Page File = 2921 MB
Total Virtual = 2047 MB
Available Virtual = 291 MB
**Dump thread - spid = 0, EC = 0x051F27B0
*
* User initiated stack dump. This is not a server exception dump.
*
***Stack Dump being sent to C:\sqldata\MSSQL10.SQL2008\MSSQL\LOG\SQLDump0001.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 02/10/10 10:58:26 spid 21
*
* ex_raise2: Exception raised, major=52, minor=42, state=3, severity=22
*
*
*
* MODULE BASE END SIZE
* sqlservr 01000000 0396FFFF 02970000
* ntdll 7C900000 7C9B1FFF 000b2000
* kernel32 7C800000 7C8F5FFF 000f6000
* MSVCR80 78130000 781CAFFF 0009b000
* msvcrt 77C10000 77C67FFF 00058000
* MSVCP80 7C420000 7C4A6FFF 00087000
* ADVAPI32 77DD0000 77E6AFFF 0009b000
* RPCRT4 77E70000 77F01FFF 00092000
* Secur32 77FE0000 77FF0FFF 00011000
* sqlos 344D0000 344D5FFF 00006000
* pdh 74000000 74055FFF 00056000
Nothing exciting, really!
Any idea what to do? Where to look?
Many Thanks
Eric :crying:
February 10, 2010 at 5:04 am
A user-generated dump can be manually generated. DBCC STACKDUMP. It might be worth running profiler to see what's running. Also, what's in the SQL error log? (If you're not sure what to look for, zip the lastest 2 error logs and attach them to your post.)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2010 at 6:11 am
This is my workstation and I am not aware of any application accessing the database.
I have stopped Sql Server Agent and Sql Server, then only restarted SQL Server.
Dumps are still being produced continuously
In profiler, I can only see myself reading the errorlog (I use the default trace)
I am quite tempted to uninstall completely SQL 2008 and re-install from scratch...
I have everything as tsql scripts and a very good deployment application.
What do you think??? :crazy:
February 10, 2010 at 6:30 am
From what I can see, you have system processes throwing high severity errors (severity 22).
I think reinstall would be a good idea, because I can't tell why or even what error
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2010 at 6:33 am
Did you have a look at http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2e047054-d816-4798-98aa-82eb9678dde4/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 10, 2010 at 6:50 am
Alzdba
Thanks for the interesting link but mine is a named instance and I can't figure out the command to start it as it keeps complaining about bits and bobs.
I suppose if I had to, I would manage but I'll take the lazy option and uninstall/reinstall...
Many thanks
Eric
February 10, 2010 at 9:08 am
Could you attach ones of the stack dumps?
February 10, 2010 at 9:33 am
Sorry, I already zapped everything, I only kept db backups :blush:
February 10, 2010 at 9:36 am
No worries 🙂
If it happens again....... (here's hoping not)
February 11, 2010 at 2:36 am
Good news!
I removed all of sql 2008, reinstalled my Developer version, upgraded with sp1 and it's doing it again!
Am I not lucky!?
Attached is my nice latest dump.
I can't see anything particularly significant in event log viewer... which I would have expected if I had a hardware problem.
February 11, 2010 at 3:02 am
Interesting...
It started dumping when I restored one database... and it seemed to stop when I dropped it again.
There is nothing I can't regenerate in that database so I'll see how it goes without it.
😀
February 11, 2010 at 3:21 am
Thank you for the feedback.
- Any particular techniques used in the "Attach-but-dump" database ?
- What's the db-level of that db ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 11, 2010 at 3:31 am
Good question
I develop using sql 2008 but I work on various projects, most are 2005 while some are 2008.
Because I like intellisense, I try to work with 2008 databases regardless.
Once in a blue moon, I take a 2005 backup of our prod (for instance) database and restore it in my 2008 server.
We have sophisticated upgrade scripts so keeping various dbs in synch is no problem.
I do not touch this so the Compatibility Level was left to sql 2005.
Having said that, I do this on quite a regular basis and never had a problem with this.
Since I discovered my DB seemed corrupted this morrning, I have just restored a 2005 backup onto my 2008 server (same database project) and everything seems fine so far.
January 26, 2015 at 9:33 am
I am having the same problem. Started a couple of weeks ago. I go in and delete all the files and it just keeps filling back up. We have software that connects to this database but nothing that would start a dump. This is Express with the defaults used during install. I can include a zip if needed. I get a SQLDump0001 47KB
SQLDump001.txt 623 KB
SQLDump0002.log 64 KB
SQLDump0002.mdm 5,424 KB
SQLDump0002.txt 626KB
SQLDump.0003.log 64KB
SQLDump0003.mdmp 5,367 KB
etc etc
No one started these dumps, and stopping and starting SQL sure does not help.
ANY ideas?
January 26, 2015 at 10:15 am
Hi there!
This was a long time ago (for my weak memory anyway) but reading through my own posts, I only cured this by not reloading the database that was provoking it.
I'm afraid, I never got to the bottom of it.
Good luck...
Eric
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply