What’s a mini-dump in SQL Server 2005?

I was recently trying to diagnose some problems in one of my SQL Servers when I ran across a problem that I hadn’t encountered before involving ‘nonyielding worker threads’.  SQL Server also produced a dump for me to review.  Unfortunately, the dump didn’t make a lot of sense to me. 

 

If you encounter one of SQL Server’s mini-dump files and want more information, you’ll be happy to know that there’s a lot of information on-line:

 

http://www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx

 

This URL is also a wealth of diagnostic and internals information that I recommend for any serious SQL Server professional.

 

Enjoy!

 

-Kev

 

P.S. And check out the new CD by Paramore – best alt rock CD of the year IMO.

One Response to “What’s a mini-dump in SQL Server 2005?”

  1. andy Says:

    Checked out Paramore’s newest and liked “Misery Business” the video is pretty funny too…oh yeah, and thanks for the SQL Server knowledge!

Leave a Reply