SQL Server 7.0 Performance Tuning

Microsoft® SQL Server™ 7.0 Performance Tuning
Technical Reference provides the practical information that
database administrators need to configure a SQL Server 7.0
database for better, faster, more scalable solutions. This is the
only book about SQL Server 7.0 performance tuning
coauthored by Microsoft SQL Server performance group
engineers. The authors start with the basics and build upon it
to teach how the mechanics of performance tuning affect the
whole system. What's more, this book also shows how to
optimize for the underlying operating system and hardware.
Expert instruction helps you understand these topics:

• Server tuning: How to use the Enterprise Manager, SQL
  Server Performance Monitor, and Profiler to shorten
  transaction response times and how to optimize your
  database layout to get the best use of hardware resources
  
• Sizing and capacity planning: How to model software and
  hardware usage to predict resource consumption, plus how to
  perform what-if scenarios about workload growth to avoid
  slow response times
  
• Configuring and tuning the system: How to tune OLTP
  systems, data warehouses and data marts, and replicated
  systems, and how to set up your system for high-performance
  backup and recovery
  
• Tuning SQL statements: How to get optimal performance by
  using the Query Analyzer and Profiler to tune SQL statements
  and stored procedures, plus how to take advantage of
  indexes and hints