Database Performance Tuning Handbook, with CD-ROM (Data Warehousing/Data Management)

Dunham, Jeff

ISBN 10: 0070182442 ISBN 13: 9780070182448

Publisher: McGraw-Hill, 1997

Synopsis

Geared to database professionals who are responsible for optimizing database performance, Jeffrey Allan DunhamÕs Database Performance Tuning Handbook is a one-stop reference for tuning and tweaking the latest releases of all popular database management systems. Drawing on over 25 years experience in database tuning and performance, Dunham relates essential tips for optimizing Oracle 7.3, Sybase 11, Microsoft SQL Server 6.5, DB2 4.X, CA-IDMS release 14, and other popular database products. Other sections cover client/server systems, database planning, design and networking, mainframe blocking, buffering, coding and caching, PC files and buffers, advanced data management techniques, and more.

About this title

About the Author

Jeff Dunham has over 25 years experience as a computer professional specializing in database tuning and performance. He currently works at Allen Systems Group, which makes CA-IDMS and DB2 database tools.

From the Back Cover

Improve performance on every major database using one all-inclusive volume. Database administrators, programmers, system programmers, and technical specialists are responsible for optimizing database usage to improve system performance, but recent changes in the database marketplace and the advent of Open Data Base Connectivity have forced them to learn and manage more than one database product. Fortunately, Jeffrey Allan DunhamÕs Database Performance Tuning Handbook covers all major database products and performance issues in one comprehensive volume. Consolidating performance-improving tactics from manufacturers, user groups, published works, and training courses, this essential reference contains tips for optimizing all major database products including: Oracle v7.3 & 8.0; Sybase v11; Microsoft SQL Server v6.5; DB2 v4.X; CA-IDMS release 14. Other sections cover tuning tips for client/server systems and database networking over TCP/IP and SNA. Also featured are discussions of database planning and design, mainframe blocking, buffering, coding and caching, PC files and buffers, and advanced data management techniques. This comprehensive resource even includes tips for Windows NT 4.0, Windows 95, and minor database managers like CA-Clipper, dBASE, BTRIEVE, and the FoxPro family. With over 300 illustrations and valuable appendices, this book is a one-stop source for every database professional.

Edition details

• Publisher: McGraw-Hill
• Publication date: 1997
• Language: English
• ISBN 10: 0070182442
• ISBN 13: 9780070182448
• Binding: CD-ROM
• Number of pages: 778