Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » dump   (RSS)
Tuesday, October 20, 2009 3:44 PM

Troubleshooting SQL Server Management Studio with SQL Profiler and Debugging Tools – Part 2

This is the second in a series of 3 posts which discuss troubleshooting SQL Server Management Studio when it encounters errors or unexpected behaviour. In this post we collect a memory dump of SSMS based upon specific .NET exception codes, for subsequent
Posted by grahamk | 0 Comments
Filed under: ,
Tuesday, October 21, 2008 4:17 PM

Non-yielding Scheduler, IO Warnings and Cluster Failover

Here's another example of SQL Server producing a dump file which can help you diagnose critical problems. The scenario here is a a clustered SQL Server 2005 instance fails over and we need to investigate why. A good place to start in such problems (as
Posted by grahamk | 0 Comments
Thursday, September 11, 2008 6:49 PM

Non-yielding IOCP Listener - Stack Dump analysis

Here's something I was looking at yesterday which is worth a quick look. It's quite a common scenario and one that's relatively easy to address. Your SQL Server 2005 instance suddenly throws the following to the error log (apparently without warning):
Posted by grahamk | 0 Comments
Wednesday, June 25, 2008 3:54 PM

SQL Server Assertions and Dumps – a typical example and some proactive help

I recently worked with a customer who was seeing the following error in their error log: SQL Server Assertion: File: <qxcntxt.cpp>, line=1069 Failed Assertion = 'cref == 0' Could not find an entry for table or index with partition ID 491897996509184
Posted by grahamk | 0 Comments
 
Page view tracker