SQLUSA

Microsoft SQL Server 2000 Best Practices

How to diagnose in crisis situation?

 

You are under tremendous pressure. It was working yesterday, does not work today, and nothing was changed (or at least nobody admits to it).

Database Operations Crisis Checklist:

1. Trigger was dropped or added

2. An index was dropped or added

3. An index went bad (too many inserts/deletes)

4. Pinned tables overran memory

5. A constraint was added to a large table

6. A stored procedure was changed

7. Someone started a monster killer job which is blocking

8. Failed RAID disk initiated a hot-standby kick-in and rebuild

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page