SYBASE大型数据库性能优化方法

大型数据库性能调优是系统管理员面临的一个主要问题，它直接影响到整个数据库系统的有效运行。以实际应用的商业系统为背景，从调优工具、数据库服务器、数据库结构设计、数据库应用及数据库运行环境等几个方面讨论SYBASE数据库性能调优的基础、原理和方法；从实际应用的角度分析了可以采用的有效调优方法，并做了优化前后的性能对比。从中得出结论：数据库性能调优是高效率使用数据库的前提和基础。

Performance Optimization Technique of SYBASE

Performance optimizing of business database is a main problem encountered by system administrator, and it will impact the running of whole database system. This paper discusses foundation, principle and technique of SYBASE performance optimizing from the aspect of optimizing tool, database server, database structure design, database application and database running environment based on a truly application system. From the practice application point of view, it presents adoptive efficient optimizing technique and gives contrast before and after optimizing. Finally it explains that database performance optimizing is the precondition and basic to use the database efficiently.