Sybase ASE 12.5 Performance and Tuning

Sybase ASE 12.5 Performance and Tuning

Author: Jeffrey R. Garbus

Publisher: Jones & Bartlett Publishers

Published: 2002-08

Total Pages: 448

ISBN-13: 1556229089

DOWNLOAD EBOOK

Once your database system is up and running, you need to keep it functioning smoothly. Designed for the DBA working to maximize the performance of a Sybase server, Sybase ASE 12.5 Performance and Tuning provides a guide to this important process. From benchmarking your system and optimizing stored procedures to indexing and using sp_sysmon to monitor your system, the authors thoroughly explain how to tune your server for maximum performance. Topics include defining performance, understanding the I/O system, using the query optimizer, managing memory, processing queries, application design, deadlocks and locking schemes, performance metrics, auditing features, tips for solving problems that can bog down a system.


Sybase 15.0 Replication Server Administration

Sybase 15.0 Replication Server Administration

Author: Saroj Kapoor Bagai

Publisher: Jones & Bartlett Learning

Published: 2008-12-08

Total Pages: 842

ISBN-13: 1449633552

DOWNLOAD EBOOK

Sybase 15 Replication Server Administration addresses the needs of a wide range of database professionals, explaining to both beginners and experts how to administer Sybase’s newest Replication Server release. This book examines all the knowledge, background information, and conceptual frameworks needed in order to get started on installing and administering Sybase Replication Server, and explores the world of contemporary cross-platform compatible Sybase Replication Server administration. Learn how to replicate business-critical data; configure database connections and routes; manage replicated tables, stored procedures, and subscriptions; set up a warm standby system; monitor replication performance and tune the database system; provide up-to-the-minute high availability of data; recover from failures and prevent data loss; troubleshoot the replication system.


Administrator's Guide to Sybase ASE 15

Administrator's Guide to Sybase ASE 15

Author: Jeffrey Garbus

Publisher: Jones & Bartlett Publishers

Published: 2010-10-25

Total Pages: 485

ISBN-13: 1449612741

DOWNLOAD EBOOK

Administrator's Guide to Sybase ASE 15 is a practical systems administration guide for the newest release of the ASE product. Designed to provide all administrators with an authoritative guide, topics include installation, defining physical and Sybase-mirrored devices, transaction logging and modes, security, auditing, database backup and restoration, troubleshooting, maintenance, and more. After reading this book, you should be able to perform any task that encompasses the creation or maintenance of a server. With this book any administrator will understand the responsibilities of a system administrator; find out how to set limits on server resources using the Resource Governor; learn how to prioritize tasks with the Logical Process Manager; use data partitioning to enable finer control over data placement, maintenance, and management.


Configuring and Tuning Databases on the Solaris Platform

Configuring and Tuning Databases on the Solaris Platform

Author: Allan N. Packer

Publisher: Prentice Hall Professional

Published: 2002

Total Pages: 556

ISBN-13: 9780130834171

DOWNLOAD EBOOK

Covers key performance issues related to using leading databases on Sun servers for system administrators and database programmers. This book brings together best-practice guidelines for every aspect of database tuning on Sun servers.


IBM Power Systems Performance Guide: Implementing and Optimizing

IBM Power Systems Performance Guide: Implementing and Optimizing

Author: Dino Quintero

Publisher: IBM Redbooks

Published: 2013-05-01

Total Pages: 372

ISBN-13: 0738437662

DOWNLOAD EBOOK

This IBM® Redbooks® publication addresses performance tuning topics to help leverage the virtualization strengths of the POWER® platform to solve clients' system resource utilization challenges, and maximize system throughput and capacity. We examine the performance monitoring tools, utilities, documentation, and other resources available to help technical teams provide optimized business solutions and support for applications running on IBM POWER systems' virtualized environments. The book offers application performance examples deployed on IBM Power SystemsTM utilizing performance monitoring tools to leverage the comprehensive set of POWER virtualization features: Logical Partitions (LPARs), micro-partitioning, active memory sharing, workload partitions, and more. We provide a well-defined and documented performance tuning model in a POWER system virtualized environment to help you plan a foundation for scaling, capacity, and optimization . This book targets technical professionals (technical consultants, technical support staff, IT Architects, and IT Specialists) responsible for providing solutions and support on IBM POWER systems, including performance tuning.


Sybase Performance Tuning

Sybase Performance Tuning

Author: Shaibal Roy

Publisher:

Published: 1996

Total Pages: 664

ISBN-13:

DOWNLOAD EBOOK

This text offers a detailed look at Sybase SQL Server Performance Tuning and a sneak peek at Sybase System 11 performance features. It compares and contrasts all recent major releases of Sybase SQL Server


POWER7 and POWER7+ Optimization and Tuning Guide

POWER7 and POWER7+ Optimization and Tuning Guide

Author: Brian Hall

Publisher: IBM Redbooks

Published: 2013-03-04

Total Pages: 224

ISBN-13: 0738437530

DOWNLOAD EBOOK

This IBM® Redbooks® publication provides advice and technical information about optimizing and tuning application code to run on systems that are based on the IBM POWER7® and POWER7+TM processors. This advice is drawn from application optimization efforts across many different types of code that runs under the IBM AIX® and Linux operating systems, focusing on the more pervasive performance opportunities that are identified, and how to capitalize on them. The technical information was developed by a set of domain experts at IBM. The focus of this book is to gather the right technical information, and lay out simple guidance for optimizing code performance on the IBM POWER7 and POWER7+ systems that run the AIX or Linux operating systems. This book contains a large amount of straightforward performance optimization that can be performed with minimal effort and without previous experience or in-depth knowledge. This optimization work can: Improve the performance of the application that is being optimized for the POWER7 system Carry over improvements to systems that are based on related processor chips Improve performance on other platforms The audience of this book is those personnel who are responsible for performing migration and implementation activities on IBM POWER7-based servers, which includes system administrators, system architects, network administrators, information architects, and database administrators (DBAs).


Best Practices for DB2 on AIX 6.1 for POWER Systems

Best Practices for DB2 on AIX 6.1 for POWER Systems

Author: Rakesh Dash

Publisher: IBM Redbooks

Published: 2015-08-27

Total Pages: 426

ISBN-13: 0738434191

DOWNLOAD EBOOK

This IBM® Redbooks® publication presents a best practices guide for DB2® and InfoSphereTM Warehouse performance on a AIX® 6L with Power SystemsTM virtualization environment. It covers Power hardware features such as PowerVMTM, multi-page support, Reliability, Availability, and Serviceability (RAS) and how to best exploit them with DB2 LUW workloads for both transactional and data warehousing systems. The popularity and reach of DB2 and InfoSphere Warehouse has grown in recent years. Enterprises are relying more on these products for their mission-critical transactional and data warehousing workloads. It is critical that these products be supported by an adequately planned infrastructure. This publication offers a reference architecture to build a DB2 solution for transactional and data warehousing workloads using the rich features offered by Power systems. IBM Power Systems have been leading players in the server industry for decades. Power Systems provide great performance while delivering reliability and flexibility to the infrastructure. This book presents a reference architecture to build a DB2 solution for transactional and data warehousing workloads using the rich features offered by Power systems. It aims to demonstrate the benefits DB2 and InfoSphere Warehouse can derive from a Power Systems infrastructure and how Power Systems support these products. The book is intended as a guide for a Power Systems specialist to understand the DB2 and InfoSphere Warehouse environment and for a DB2 and InfoSphere Warehouse specialist to understand the facilities available for Power Systems supporting these products.