locked
Log files taking up a lot of disk space RRS feed

  • Question

  • Hello,

    I ran into an issue with all these logs made by default.

    Disk space crunch leading to performance degradation.

    OK, I moved the log dir outside the default app volume (Script/restart) onto a 100GB drive I use for the SQL transactions logs, but.

    Analysis Services accumulated 20GB of logs in 2-3 days, did not clean-up the old stuff and led to disk space alerts and applications performance issues. All this with out of the box settings.

    The server has in the 30 to 60 connections alive around the clock with each of these connections performing queries every 2-3 seconds or so.

    I also use the query log function for optimisation purposes but for that one I log to table on a specific drive.

    I run Analysis services 64 bits build  9.00.2047

    Log files eating the drive have name like msmdsrv.log, FlightRecorderCurrent.trc, FlightRecorderBack.trc, SQLDmpr4495.mdmp, SQLDmpr4495.log and SQLDUMPER_ERRORLOG.log

    Is the high frequency of log files creation (4MB every 5 minutes) the indication of a bigger issue?

    Is there any way to set up these logs to be less intrusive, less verbose and more self-cleaning while still reaping the benefits of unattended problems loging?

    Thanks,

    Philippe

    Thursday, February 1, 2007 11:12 PM

Answers

  • Yes.

    You might be having different and potentially more seriouse issues. Creation of SQLDmpr***.mdmp SQLDmpr***.log  files is indication of something going wrong in your server.

    You should try and contact customer support and report your problems.

    Edward.
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Monday, February 5, 2007 8:46 PM

All replies

  • Yes.

    You might be having different and potentially more seriouse issues. Creation of SQLDmpr***.mdmp SQLDmpr***.log  files is indication of something going wrong in your server.

    You should try and contact customer support and report your problems.

    Edward.
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Monday, February 5, 2007 8:46 PM
  • Thank you,

    The problem was very simple, the login in the QueryLog connection string did not have write access to the logDB.

    This was generating all these Dmpr log files. Not a single log was generated since I fixed it last week.

    Philippe

    Monday, February 5, 2007 9:50 PM
  • I split and edited this thread from an unrelated thread on the Flight Recorder to make it easier for people searching the forum to find this information.
    Monday, February 5, 2007 11:07 PM
  •  Philippe Cand wrote:

    Thank you,

    The problem was very simple, the login in the QueryLog connection string did not have write access to the logDB.

    This was generating all these Dmpr log files. Not a single log was generated since I fixed it last week.

    Philippe

     

    Hi Philippe,

     

    This is an old entry but if you remember, could you please write your solution in detail?

     

    What do you mean by logDB? etc...

     

    I have a development box, and production box. On production box, no mdmp files are being produced, but on development box i have many (more than 16000 and increasing).

     

    When i compare Analysis Services settings on the two boxes there is no difference. I think i may apply your solution.

     

    Thanks.

    Tuesday, July 8, 2008 3:03 AM