Chapter 15. Troubleshooting SQL Server
by Mark Spenik
IN THIS CHAPTER
SQL Error Messages
Using the Error Message Number to Resolve the Error
Deciphering the Error Log
Using the Event Viewer
Killing a Process
Viewing Detailed Process Activity
Using DBCC and Trace Statements to Troubleshoot
Troubleshooting Applications
Other Sources of Help and Information
Troubleshooting FAQ
So far, each chapter in this book has covered common problems and resolutions. This chapter steps back and focuses on how SQL Server alerts you to possible problems with databases, objects, or the server; how to find more information about the problem; how to fix the problem; and how to get help in determining and fixing your problem. Quite frequently DBAs are confronted with helping ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.