Citeste capitolele si discutam.

Se bazeaza pe urmatoarele resurse:

Troubleshooting Performance Problems in SQL Server 2005p

SQL Server Best Practices

SQL Server 2005 Performance Tuning using Waits and Queues

OLTP Top 6 Performance Issues for OLTP Applications

Storage Top 10 Best Practices

SQL Server Best Practices Toolbox

Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005

• Buffer Cache
  
• CPU and Optimization
  
• Indexes and Indexing
  
• Input/Output
  
• Performance
  
• Query Plan Re-Use
  
• Retrieving SQL Text and XML Plans
  
• SQLOS: Schedulers, Runnable Queue, Waiter List
  
• Tempdb
  
• Transactions and Locking
  
• Wait Statistics

SQL Server 2005 Best Practices Analyzer

DMV Stats

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro