Microsoft SQL Server 2000
Database Administrator's Tuning Guide for SQL 7.5 Applications
Jenney Lynne Fields, Jenney Fields
Résumé
- The step-by-step, up-to-the-minute guide to maximizing SQL Server performance and scalability!
- Plan SQL Server 2000/7 applications for maximum performance
- Make the most of Microsoft's SQL Server Profiler, Graphic Showplan, and Index Tuning Wizard
- Automate performance monitoring and notification
- CD-ROM: Extensive library of tuning tools, scripts, and practice resources!
Foreword by Andrew Scoppa, UCI Corporation
- A detailed, structured approach to identifying SQL Server performance bottlenecks—and resolving them
- Covers every component that impacts SQL Server performance: software and hardware
- Scalable, high-availability solutions for enterprise applications
- SQL Server 2000's enhanced architecture—and how it affects existing applications
- Techniques for automating performance monitoring and notification
- Extensive real-world scenarios and practical recommendations
Maximize the performance of all your SQL Server 2000/7.0 applications!
Microsoft SQL Server 2000 Optimization Guide delivers all the hands-on techniques and guidance you need to optimize any SQL Server 2000/7.0 application—no matter how large or business-critical! You'll learn a proven step-by-step methodology for tracking down SQL Server application bottlenecks and scalability problems—and resolving them.
Jenney Lynne Fields covers every aspect of optimizing both transaction processing and decision support applications. Discover how to install and configure SQL Server for maximum performance; create optimal indexes for each type of query; and write queries that take full advantage of the Query Optimizer.
Fields helps you identify opportunities for denormalizing logical database design to enhance performance; shows how to minimize contention and deadlock; and demonstrates how to work with stored procedures far more effectively. She also also presents in-depth guides to every key Microsoft database performance management tool, including the SQL Server Profiler, Graphic Showplan, and the Index Tuning Wizard.
Whatever your applications, whatever your role, this book will help you squeeze more performance and scalability out of the SQL Server databases you depend upon.
About the CD-ROM
The accompanying CD-ROM contains an extensive library of practice optimization sessions, training materials, scenarios, scripts, and other resources for maximizing the performance of SQL Server 2000 and 7.0.
Contents
- Foreword
- Preface
- I: Overview And Architecture
- 1: Overview of SQL Server 2000
- 2: The Storage Engine
- 3: Query Processor
- II: Performance Considerations
- 4: Hardware Considerations
5: Implementing High Availability Solutions
- 6: Application Considerations
- III: Diagnosing And Resolving Problems-Tuning And
Optimization
- 7: Performance Tuning with Windows NT/2000 Tools
8: Monitoring and Configuring SQL Server
- 9: Automating SQL Server Tasks
- 10: SQL Server Profiler
- 11: SQL Server Query Analyzer
- 12: Index Tuning Wizard
- Appendix A: Resources
- Appendix B: Contents of the CD
- Index
L'auteur - Jenney Lynne Fields
Jenney Lynne Fields is President and Senior Consultant
for Sutton Technology Group, Inc., Sutton, MA. She holds
MCSE, MCT, and Novell CNE certification.
UCI Corporation has been training technical IT
professionals since 1984. UCI provides training services,
curriculum development, and consulting services to
programmers, and system support engineers. UCI expertise
includes Internet, Programming, and System
technologies.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Prentice Hall |
Auteur(s) | Jenney Lynne Fields, Jenney Fields |
Parution | 15/08/2000 |
Nb. de pages | 509 |
Format | 17,8 x 23,5 |
Couverture | Broché |
Poids | 1036g |
Intérieur | Noir et Blanc |
EAN13 | 9780130883582 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse