Part 2 also covers OLTP, DSS, and mixed workloads.
第2部分还将介绍OLTP、DSS以及混合的工作负载。
OLTP applications should not be performing large sorts.
OLTP应用程序不应该执行大型排序。
This includes both OLTP and Data Warehouse applications.
这包括OLTP和数据仓库应用程序。
This means it should not be an overloaded OLTP application.
这意味着它将不是一个超载的OLTP应用程序。
Quantifying the benefits of using EFDs in OLTP environments.
确定在OLTP环境中使用EFD的好处。
OLTP systems support only predefined operations.
OLTP系统仅仅支持预先定义好的操作。
OLTP databases contain transacations at the most granular level.
OLTP数据库包含最细粒度级别的事务。
Your OLTP system is in-use 24-hours a day, and performance is critical.
您的OLTP系统一天24小时运行，性能要求很严格。
The database queries in TPC-H are more complex than typical OLTP queries.
TPC- H中的数据库查询要比典型的OLTP查询更加复杂。
For this reason, bitmap indexes are not appropriate for many OLTP applications.
因为这个原因，位图索引不适合于OLTP应用。
Note: This article chiefly addresses online transaction processing [OLTP] access.
请注意：本文主要介绍在线事务处理 [OLTP]访问。
As a rule of thumb for OLTP applications, use DMS tablespaces with multiple devices.
作为OLTP应用程序的经验法则，可在多个设备上使用dms表空间。
Typically, an OLTP workload consists of many concurrently running short transactions.
通常，OLTP工作负载包括许多并发运行的短事务。
In an online transaction processing (OLTP) environment, start with a value of 30 seconds.
在联机事务处理(OLTP)环境中，这个值从30秒开始。
With these tips, you can get your OLTP application up and running with reasonably good performance.
有了这些技巧，就可以启动自己的OLTP应用程序并使其拥有非常好的运行性能。
What if you know your OLTP searches should use the same execution plan for different binding values?
要是你知道你的OLTP搜索对不同绑定值应该使用相同执行计划又该怎么办呢？
The OLTP database is always up to date, and reflects the current state of each business transaction.
OLTP数据库总是在更新中，并且反映了每个商业事务的当前状态。
Games are not like decision support system (DSS) or Online Transaction Processing (OLTP) systems at all.
游戏与决策支持系统(DSS)和在线事务处理(OLTP)系统完全不一样。
New features enhance OLTP data security, OLTP performance, data warehouse performance, and administration.
新特性增强了OLTP数据安全性、OLTP性能、数据仓库性能和管理。
Online transaction Processing (OLTP), consisting of many transactions of varying complexity, mostly small.
联机事务处理(Online Transaction Processing, OLTP)，包含许多不同复杂性的小型事务。
Philip Howard of Bloor Research provides competitive analysis of these two OLTP systems for it specialists.
Bloor Research的Philip howard为it专家提供了这两个OLTP系统的竞争力分析。
Suppose a table in an OLTP database already has 6 or 7 indexes. Would I give a thumbs-up to adding another?
假设 OLTP数据库中的一个表已经拥有6 个或7 个索引，我还会赞成再添加一个吗？
The term transaction in OLTP refers to transactions in the context of databases, not financial transactions.
这里讲的OLTP事务是指数据库上下文中的事务 ，而不是金融交易中的事务。
Some fine tuning to the logger to make it more efficient and to improve the performance of OLTP applications.
对logger的微调，以使得它更高效，并提高OLTP应用程序的性能。
Sequential scans are typical in decision support system (DSS) applications but rare with OLTP access patterns.
顺序扫描一般在决策支持系统(DSS)应用程序中很常见，但很少出现在OLTP访问模式中。
On OLTP systems, where user sessions are performing quick queries, tuning this parameter can be very important.
在OLTP系统上，用户会话执行快速查询，调节此参数可能非常重要。
The PERFORMER program is an OLTP application, so it doesn't have complex SELECT queries, and has minimal sorting.
PERFORMER程序是一个OLTP应用程序，因此，它没有复杂的SELECT查询，排序也很少。
Whether the workload is more like a data warehouse (primarily queries) or an OLTP system (mix of queries and DML).
还有工作环境是更像数据仓库（主要进行查询）还是OLTP系统（查询和DML混合）。
Because the only table may be the hotspot unless it is partitioned, OLTP Systems typically don't work well with it.
除非进行分区，否则唯一的数据表会成为热点，OLTP系统通常在这方面都不太好。
The results are very relevant to any DBA that must maintain and tune an online transaction processing (OLTP) system.
结果与必须维护和调优在线事务处理(OLTP)系统的任何DBA密切相关。
应用推荐