sqldumper

SalamElias

Hi, recently, whileI am working on my server, I noticed a message indicating
that I have no availablespace on drive C.
After 3 hours of investigation, I noticed in task manager tha "SQLDUMPER"
executes every 1 second and generates a file.
Opened the SQL server log directory, I found thouasands and thousands of
mdmp files. I deleted all of them, got back 6G of hard drive.

I couldn't find quickly how to disable this feature, I cut off the
sqldumper.exe and put in a temp directory.
Then I noticed still my hard drive continues o decrease, opened again the
sql,sever log directory, discovered thousands of SQLDUMPxxxxx.txt or log each
second.

First question, why this is happening, then how can I stop sql from logging
this every second
Thanks

SalamElias

I switched all SQL server related services to start manually, put back
sqldumper in its original place, as soon start SQL server service, I get a
dump file each 1 second again with mdmp extension.

How this can be stopped I amnot able to do anything with the server

thanks in advance
"SalamElias" wrote:

> Hi, recently, whileI am working on my server, I noticed a message indicating
> that I have no availablespace on drive C.
> After 3 hours of investigation, I noticed in task manager tha "SQLDUMPER"
> executes every 1 second and generates a file.
> Opened the SQL server log directory, I found thouasands and thousands of
> mdmp files. I deleted all of them, got back 6G of hard drive.
>
> I couldn't find quickly how to disable this feature, I cut off the
> sqldumper.exe and put in a temp directory.
> Then I noticed still my hard drive continues o decrease, opened again the
> sql,sever log directory, discovered thousands of SQLDUMPxxxxx.txt or log each
> second.
>
> First question, why this is happening, then how can I stop sql from logging
> this every second
> Thanks

Linchi Shea

Normally, SQL Server shouldn't be creating memory dumps or minidumps like
that unless there is a problem. Did you check errorlog to see if any error
messages are being logged there?

Linchi

"SalamElias" wrote:

> I switched all SQL server related services to start manually, put back
> sqldumper in its original place, as soon start SQL server service, I get a
> dump file each 1 second again with mdmp extension.
>
> How this can be stopped I amnot able to do anything with the server
>
> thanks in advance
> "SalamElias" wrote:
>
> > Hi, recently, whileI am working on my server, I noticed a message indicating
> > that I have no availablespace on drive C.
> > After 3 hours of investigation, I noticed in task manager tha "SQLDUMPER"
> > executes every 1 second and generates a file.
> > Opened the SQL server log directory, I found thouasands and thousands of
> > mdmp files. I deleted all of them, got back 6G of hard drive.
> >
> > I couldn't find quickly how to disable this feature, I cut off the
> > sqldumper.exe and put in a temp directory.
> > Then I noticed still my hard drive continues o decrease, opened again the
> > sql,sever log directory, discovered thousands of SQLDUMPxxxxx.txt or log each
> > second.
> >
> > First question, why this is happening, then how can I stop sql from logging
> > this every second
> > Thanks

TheSQLGuru

maybe check windows event logs too. something is definitely 'broken'
somewhere.

also, did you try to open/view the dumper files? if they are hex you may
still possibly get something useful out of them by using a hex viewer.


--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.


"Linchi Shea" <> wrote in message
news:...
> Normally, SQL Server shouldn't be creating memory dumps or minidumps like
> that unless there is a problem. Did you check errorlog to see if any error
> messages are being logged there?
>
> Linchi
>
> "SalamElias" wrote:
>
>> I switched all SQL server related services to start manually, put back
>> sqldumper in its original place, as soon start SQL server service, I get
>> a
>> dump file each 1 second again with mdmp extension.
>>
>> How this can be stopped I amnot able to do anything with the server
>>
>> thanks in advance
>> "SalamElias" wrote:
>>
>> > Hi, recently, whileI am working on my server, I noticed a message
>> > indicating
>> > that I have no availablespace on drive C.
>> > After 3 hours of investigation, I noticed in task manager tha
>> > "SQLDUMPER"
>> > executes every 1 second and generates a file.
>> > Opened the SQL server log directory, I found thouasands and thousands
>> > of
>> > mdmp files. I deleted all of them, got back 6G of hard drive.
>> >
>> > I couldn't find quickly how to disable this feature, I cut off the
>> > sqldumper.exe and put in a temp directory.
>> > Then I noticed still my hard drive continues o decrease, opened again
>> > the
>> > sql,sever log directory, discovered thousands of SQLDUMPxxxxx.txt or
>> > log each
>> > second.
>> >
>> > First question, why this is happening, then how can I stop sql from
>> > logging
>> > this every second
>> > Thanks

Charles Wang[MSFT]

Hi eliassal,
I agree that you should check your error log and dump files to see if there
were any exceptions for your SQL Server. The SQL Server process calls the
Sqldumper.exe utility internally to generate a dump file when the process
experiences any exceptions. You can change the dump directory if your SQL
Server is 2005. You may refer to this article:
How to change the dump directory for SQL Server, Agent and FTS?


As far as I know there is no way to fully disable the dump generation,
however according to the KB article 917825,
, we can find the description "
You can use trace flags to change the flags that SQL Server passes to the
utility in the context of an exception or in the context an assertion.
These trace flags are in the range from 2540 to 2559. You can use these
trace flags to generate certain types of dump files.". You may try running
DBCC TRACEOFF(2540,-1),..., DBCC TRACEOFF(2559, -1) to disable some
mini-dump generation for the related errors. Also you can run DBCC
TRACEOFF(1260,-1) and DBCC TRACEOFF(1262, -1) to disable mini-dumps
generation for other errors. You may refer to:
How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888

x

Please note that the above information is just for your reference. We do
not recommend that you disable mini-dump generation since it is by design
to be used for diagnose your SQL Server exceptions and generally if your
SQL Server works fine, the dump files will not be generated. We recommend
that you first check your SQL Server and resolve the current issue so that
mini-dump will not be generated.

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Charles Wang[MSFT]

Hi eliassal,

I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Have a great day!


Best regards,
Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Charles Wang[MSFT]

Hi eliassal,

I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Have a great day!


Best regards,
Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Charles Wang[MSFT]

Hi eliassal,

I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Have a great day!


Best regards,
Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====