Help with Performance

The online SQL Server Performance Troubleshooter is designed to help you resolve problems that may cause slow queries when you use Microsoft® SQL Server™ 2000.

Note  For international users of SQL Server Books Online, the text of the problems as well as the references to Knowledge Base articles appear in English and can be found on nonlocalized Web sites.

Common starting points for troubleshooting performance include:

• My SQL Server 2000 application is slow.
  
  
• I'm experiencing problems with blocking.
  
  
• A stored procedure is being recompiled excessively.
  
  
• Large batches of small queries are slower than expected.
  
  
• An individual query is using a poor query plan.

To access troubleshooters online, see Viewing Online Troubleshooters and other PSS Web-Based Information.