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 analysis. As a reminder, here are the symptoms of the problem we are…

0

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 it is with many problems) is to look into the…

0

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): 2008-09-09 08:30:44.810 Server       Using ‘dbghelp.dll’ version ‘4.0.5’2008-09-09 08:30:44.960 Server       **Dump thread – spid…

2

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 in database 2 As you would expect a mini dump was produced at the same…

0