Dedicated versus shared servers  Advance resource planning

Chapter 3: System Administration for Beginners

Decision support and OLTP applications

Adaptive Server contains many features that optimize performance for OLTP, decision-support, and mixed workload environments. However, you must determine in advance the requirements of your system’s applications to make optimal use of these features.

For mixed workload systems, list the individual tables that you anticipate will be most heavily used for each type of application; this can help you achieve maximum performance for applications.





Copyright © 2005. Sybase Inc. All rights reserved. Advance resource planning

View this book as PDF