Articoli correlati a MS SQL SERVER 7.0, PERF. TUNIN

9780735609099: MS SQL SERVER 7.0, PERF. TUNIN
Brossura
ISBN 10: 0735609098 ISBN 13: 9780735609099
Casa editrice: Microsoft Press, 2000

Sinossi

Discover how to optimize your SQL Server 7*0 system for maximum performance and scalability. Performance tuning a relational database can be challenging, exciting, and frustrating. " 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 co-authored by engineers from the Microsoft SQL Server performance group. The authors start with the basics, and then build upon this information to teach the mechanics of performance tuning and how those mechanics affect the whole system. What's more, this book is unique in that it also teaches you 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.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Product Description

Book by DeLuca Steve Adrien Garcia M S Reding Jamie Garcia

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Editore
Microsoft Press
Data di pubblicazione
2000
Lingua
Inglese
ISBN 10 
0735609098
ISBN 13 
9780735609099
Rilegatura
Copertina flessibile
Numero edizione
1
Numero di pagine
430
Contatto del produttore
non disponibile
Persona responsabile
Amazon EU Sarl
amazon.com/pbhelp

38 Avenue John F. Kennedy
Luxembourg
L-1855
Lussemburgo