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.
November 28th, 2007 at 2:09 pm
Checked out Paramore’s newest and liked “Misery Business” the video is pretty funny too…oh yeah, and thanks for the SQL Server knowledge!