| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
System Administration Guide (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 4 Diagnosing System Problems |
Chapter 4
This chapter discusses diagnosing and fixing system problems.
|
| How Adaptive Server uses error messages to respond to system problems |
| Error messages and message numbers |
| Variables in error message text |
|
| Adaptive Server error logging |
| Error log format |
| Severity levels |
![[+]](/dwicons/i_expand.gif)
| Levels 10- 18 |
|
| Severity levels 19- 26 |
| Reporting errors |
| Backup Server error logging |
|
| Killing processes |
| Using sp_lock to examine blocking processes |
|
| Configuring Adaptive Server to save SQL batch text |
|
| Allocating memory for batch text |
| SQL commands not represented by text |
|
| Viewing the query plan of a SQL statement |
| Viewing a nested procedure |
|
| Shutting down servers |
| Shutting down Adaptive Server |
|
| Shutting down a Backup Server |
| Learning about known problems |
|
|