SQL Server Trace Flag 2544, Trace Flag 2546 and Trace Flag 2551

Hi Friends,

This is my 25th blog on SQL Server Trace Flag 2544, Trace Flag 2546 and Trace Flag 2551 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

We know that SQLDumper.exe is generally used by sql server internally to generate the stack dump whenever some specific problem occurs in SQL Server. That stack dump plays an important role during the troubleshooting of complex issues like Scheduler deadlock, Latch Time Out etc. Whenever SQL Server calls to SQLDumper.exe, it also passes some parameters which decide the type of output dump file. This output can be mini dump file, filtered dump file or full dump file. If you don’t know about SqlDumper.exe application and you wants to know then click here.

From above explanation, it is clear that the use of parameters is completely depends on SQL Server internally. Now the question is: can we change the behavior of generating output as full, filtered or mini dump during SQLDumper.exe uses? Yes, we can change this by using trace flags as mention below:


Trace Flag 2544 – generates full memory dump
Trace Flag 2551 – generates filtered memory dump
Trace Flag 2546 – generates dump file for all threads of SQL Server (mini dump)

By using these trace flags you can change the default behaviour of sql server for passing specific parameters during SqlDumper.exe calls.

PS: Do not use trace flags in production environment without testing it on non production environments and without consulting because everything comes at a cost.


Prince Kumar Rastogi

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook

Follow Prince Rastogi on Twitter | Follow Prince Rastogi on FaceBook


About Prince Rastogi

Prince Rastogi is working as Database Administrator at Elephant Insurance, Richmond. He is having more than 8 years of experience and worked in ERP Domain, Wealth Management Domain. Currently he is working in Insurance domain. In the starting of his career he was working on SQL Server, Internet Information Server and Visual Source Safe. He is post graduate in Computer Science. Prince is ITIL certified professional. Prince likes to explore technical things for Database World and Writing Blogs. He is Technical Editor and Blogger at SQLServerGeeks.com. He is a regular speaker at DataPlatformDay events in Delhi NCR. He has also presented some in depth sessions about SQL Server in SQL Server Conferences in Bangalore.

View all posts by Prince Rastogi →

Leave a Reply

Your email address will not be published.