Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » How It Works » Troubleshooting: The DB Engine   (RSS)
Thursday, May 22, 2008 3:42 PM

How It Works: SQL Server 2005 - Possible data recovery when checksum failure reported

I and Microsoft will always opt for restore of a backup when corruption of the database is encountered.   This is the only way to safely restore the database to a known state.   All other actions, such as dbcc repair, can remove data
Posted by psssql | 0 Comments
Monday, April 21, 2008 3:12 PM

How It Works: What is a Sleeping / Awaiting Command Session

This issue is as old as SQL Server.  In fact, it goes back to Sybase days but continues to fool and puzzle administrators. A session with that status of sleeping / awaiting command is simply a client connection with no active query to the SQL Server.
Posted by psssql | 1 Comments
Friday, March 28, 2008 8:04 PM

How It Works: Non-Yielding Resource Monitor

I have addressed similar conditions error in a white paper: www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx 2008-01-20 19:01:26.11 Server      ***Stack Dump being sent to K:\MSSQL.3\MSSQL\LOG\SQLDump0001.txt
Posted by psssql | 0 Comments
Monday, March 03, 2008 3:31 PM

How It Works: Debugging SQL Server Stalled or Stuck I/O Problems - Root Cause

Previously I have covered stuck and stalled I/O issues in other posts and articles.  However, these only tell you that there is a problem outside the SQL Server engine.   This post attempts to extend your root cause debugging capabilities
Posted by psssql | 1 Comments
 
Page view tracker