 
Our Pages Are Best Viewed At 800 x 600 Resolution
Return
to Main Menu
Back One Page
Place Order by Mail
Contact Us
|
|
Edward
Whalen Marcilina S. Garcia Steve DeLuca Jamie Reding
ISBN: 0-7356-0909-8
Pages: 448
Disk:
Suggested Retail Price: $49.99 US
Stolin-Softwares Price: $39.99
Your Savings is: $10.00
Release: 2/23/2000
Level: Int/Adv |
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
|
|