This is a practical guide to performance tuning of SQL database applications. The book gives practical hints to help optimize applications and database systems, as well as help to solve everyday problems concerning response time and other factors relating to performance.
Reihe
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Illustrationen
Maße
Höhe: 235 mm
Breite: 198 mm
ISBN-13
978-0-07-212376-0 (9780072123760)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Autor*in
Professor of Database Systems, Polytechnic of Rosenheim, Germany
Part I: an overview of tuning; performance factors of Windows NT and hardware; SQL server 7 storage structures. Part II: indexes; SQL server query optimizer; transactions and locking; other ways to achieve better performance. Part III: Windows NT monitoring tools; other monitoring tools; index selection tools. Part IV: performance of OLAP services; Table fragmentation and parallel queries.