10 common SQL Server problems and solutions

Free registration required

Executive Summary

This list outlines 10 common SQL Server problems and solutions.

This handy two-page list outlines 10 familiar SQL Server problems and an assortment of solutions. From "Out of Space" errors to a database going suspect, this list is great quick reference for every SQL administrator.

Here's a sample:

Number 1: Users complain that queries take longer than usual. - If your normal queries take longer than usual, it could be due to resource contention from locking. This will usually occur if new processes have been added to your system, or if the load on your system has recently increased.

You should begin troubleshoot this problem using Query Analyzer and the SP_WHO2 command. The results from this command will contain a BlkBy field. If SPIDs are being blocked, the command output will show the offending SPID number. You may need to follow a large chain of blocks to find the head. Once there, you can use the dbcc inputbuffer command to see the SQL statement that the SPID is running. This will point you toward the problem's cause.Join this ongoing discussion and let us know if this download provides helpful information and if there's anything we can do to improve the document's format or content.

  • Format: PDF
  • Size: 56 KB