SQL Server 7.0 Performance Tuning. Technical Reference (Relié)

  • Microsoft Press

  • Paru le : 13/04/2000
Note moyenne : |
Ce produit n'a pas encore été évalué. Soyez le premier !
Donnez votre avis !
Discover how to optimize your SQL Server 7*0 system for maximum performance and scalability. Performance tuning a relational database can be challenging,... > Lire la suite
45,58 €
Neuf - Actuellement indisponible
  • ou
Votre note
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.
    • Performance tuning, capacity planning and sizing overview
    • SQL server 7*0 architecture
    • Understanding the I/O subsystem and RAID
    • Tuning SQL Server
    • New features and performance enhancements
    • Monitoring performance with enterprise manager and the performance monitor
    • Using SQL server profiler
    • Modeling for sizing and capacity planning
    • Sizing the database and applications servers
    • Methods for sizing a system
    • Capacity planning
    • Online transaction processing systems
    • Data warehouse and data marts
    • Tuning replicated systems
    • High-performance backup and recovery
    • Using SQL server query analyzer
    • Tuning SQL statements and stored procedures
    • Using and tuning indexes
    • Using hints in SQL server.
  • Date de parution : 13/04/2000
  • Editeur : Microsoft Press
  • Collection : it professional
  • ISBN : 0-7356-0909-8
  • EAN : 9780735609099
  • Présentation : Relié
  • Nb. de pages : 430 pages
  • Poids : 1.055 Kg
  • Dimensions : 19,0 cm × 24,5 cm × 3,7 cm

Nos avis clients sur decitre.fr

Avis Trustpilot
Marcilina Garcia et Edward Whalen - .
SQL Server 7.0 Performance Tuning. Technical Reference
45,58 €
Decitre utilise des cookies pour vous offrir le meilleur service possible. En continuant votre navigation, vous en acceptez l'utilisation. En savoir plus OK