none
Trace Flag 2551 RRS feed

  • Question

  • Did anyone use trace flag 2551 before? It claims a full-filtred memory dump will be generated on fatal errors.

    Does anyone know how big the dump files are compare to the size of the server memory? I am hesitating to turn on the flag since it is our production server, the server memory is close to 250GB and the database size is close to 1TB.

    Thanks for any input.

    Lijun

    Monday, April 14, 2014 6:00 PM

All replies

  • Did anyone use trace flag 2551 before? It claims a full-filtred memory dump will be generated on fatal errors.

    Does anyone know how big the dump files are compare to the size of the server memory? I am hesitating to turn on the flag since it is our production server, the server memory is close to 250GB and the database size is close to 1TB.

    Thanks for any input.

    Lijun

    Why you want to create memory dump any specific requirement ?

    Its said by Microsoft that Use this trace flag under guidance of MS employee.I have personally not used it but below link has couple of more methods to generate dump.

    How to create dump of SQL server

    But please tell the reason


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Monday, April 14, 2014 6:25 PM
    Moderator
  • Go check out this link, I hope you will find it very useful. (http://blogs.msdn.com/b/askjay/archive/2010/02/05/how-can-i-create-a-dump-of-sql-server.aspx)
    Monday, April 14, 2014 6:25 PM
  • Hello,

    For a full dump you should expect the size of the “max server memory”  if you have it configured or the size of the RAM on the computer. This is the type of dump that trace flag 2551 creates.


    A filtered dump just takes 3-4 GBs of disk space.


    For more information:

    http://blogs.msdn.com/b/psssql/archive/2012/03/15/intro-to-debugging-a-memory-dump.aspx

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com




    Monday, April 14, 2014 6:28 PM
    Moderator
  • Why you want to create memory dump any specific requirement ?

    One of our stored procedures triggered fatal error and produce mini dump. The but error could not be reproduced. Microsoft support suggest we turn on 2551 to get more info.

    Monday, April 14, 2014 8:14 PM
  • Why you want to create memory dump any specific requirement ?

    One of our stored procedures triggered fatal error and produce mini dump. The but error could not be reproduced. Microsoft support suggest we turn on 2551 to get more info.

    Hello,

    My next question would be is your SQL server patched to latest Service pack.What is output of select @@Version.

    You cannot directly analyze dumps you need tool for that and also to analyze dumps you need ti have prior experience with that .IMO best person to look after that dump is Microsoft employee and that can be done by opening case with MS.But before that if by applying latest SP that can subside why shed extra bucks.What does your proc do.

    I would suggest not to enable trace flag 2551.Hold your horses.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Monday, April 14, 2014 8:23 PM
    Moderator
  • Yes. Our server is patched with the latest version. CU9 after SP1, 11.0.3412.0.

    Monday, April 14, 2014 9:16 PM
  • Yes. Our server is patched with the latest version. CU9 after SP1, 11.0.3412.0.


    Good can you post the procedure code here.

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Tuesday, April 15, 2014 8:06 AM
    Moderator
  • Filtered dump = Full Dump - Data/index Pages.

    So you can look at Total Server Memory counter and reduce (number of pages) * 8 K as shown in sys.dm_os_buffer_descriptors

    Note, this is just a rough calculation. As Alberto said.. somewhere around 3 GB.


    Balmukund Lakhani
    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter | Facebook
    Author: SQL Server 2012 AlwaysOn - Paperback, Kindle

    Tuesday, April 15, 2014 8:27 AM
    Moderator