Sql Server 7.0 Performance Tuning. Technical Reference (It-Microsoft Technical Reference) - Softcover

Whalen, Edward; Deluca, Steve-Adrien; Reding, Jamie-A; Garcia, Marcilina

Softcover

ISBN 10: 0735609098 ISBN 13: 9780735609099

Verlag: Microsoft Press, 2000

Inhaltsangabe

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.

Über diesen Titel

Reseña del editor

Engineers from the company's performance group for the software package explain to database administrators how to configure the commercial relational database. They start with the basics, then teach the mechanics of performance tuning and how the mechanics affect the whole system. They also discuss how to optimize for the underlying operating system and hardware. Intended for professionals.

Details zur Ausgabe

• Verlag: Microsoft Press
• Erscheinungsdatum: 2000
• Sprache: Englisch
• ISBN 10: 0735609098
• ISBN 13: 9780735609099
• Einband: Tapa blanda
• Anzahl der Seiten: 430
• Kontakt zum Hersteller: Nicht verfügbar