Database workload: 0 to 10 percent less CPU.
数据库工作负载:CPU减少0%到10%。
General tuning tips are the same regardless of the database workload, but differences do exist between OLTP and DSS workloads.
无论数据库负载如何,通用的调优提示都是相同的,只是OLTP和DSS工作负载之间存在差别。
This information allowed you to review Activity Trends information to better judge how database workload was distributed among the servers in your environment.
这些信息可以帮助您分析ActivityTrends信息,更好地判断环境中数据库负载在服务器之间的分配。
Activity Trends even provided recommendations for balancing database workload, based on resource goals that you specified, and included a workflow to help implement these recommendations.
ActivityTrends甚至能够根据指定的资源目标提出平衡数据库负载的建议,包括帮助实现这些建议的工作流。
A workload can then be spread across multiple partitions for large tables, while allowing smaller tables to be stored on one or more database partitions.
于是,对于大型的表,工作负载可以分布在多个分区上,而更小的表也可以存储在一个或多个数据库分区上。
The challenge of optimizing the platform for this workload is met through a series of system and database configuration decisions and tuning steps.
为这一工作负载而优化平台所面临的挑战存在于一系列系统和数据库配置决策及调优步骤之中。
We provide some ideas on sizing a new cluster and conclude with news about a forthcoming workload balancing and capacity planning tool that can help with database distribution.
我们为确定新集群的大小提供一些见解,最后介绍未来的工作负载平衡和容量计划工具,帮助您恰当地分布数据库。
By duplicating the workload of the database to a separate site, these features protect users from production downtime in the event of a local hardware failure or a catastrophic site failure.
通过将数据库的工作负载复制到单独的站点上,这些特性使服务在发生本地硬件故障或灾难性站点故障时不会中断。
Using filters, you can drill down into a workload based on a particular database to examine the service class for the workload.
通过使用筛选器,可以向下钻取到某一数据库上的工作负载,了解工作负载的服务类。
The default workload cluster groups are under the database.
默认工作负载集群组在数据库之下。
Track the number of transactions per day grouped by database name, partition number, and timestamp to help with workload planning.
跟踪每天的事务数量,并按照数据库名称、分区编号和时间戳对其进行分组,以帮助进行工作负载规划。
It combines early-warning notification and deep database analysis tools to support problem resolution as well as proactive workload management and trend analysis.
它提供了用于解决问题的预警通知和数据库深度分析工具,还提供了主动负载管理以及趋势分析功能。
Clients - Shows a list of database client hosts involved in the workload.
显示了涉及该工作负载的数据库客户端主机的列表。
DB2 automatically increases the database Shared memory (graph on the left) to satisfy the demands of the workload, resulting in a corresponding increase in query throughput (graph on the right).
DB 2自动增加数据库共享内存(左侧的图)以满足工作负载的需求,最终导致查询吞吐量增加(右侧的图)。
To measure the performance impact of arrays, a 900gb database was used and an OLTP (Online Transactional Processing) workload was exercised.
为衡量阵列的性能影响,使用900gb的数据库且执行oltp(联机事务处理)工作负荷。
If the SCM database was to fail, the machine running the ERP workload would have to service all the SCM users too.
如果SCM数据库出现故障,那么承担着ERP工作负载的机器将不得不同时为所有的 SCM用户提供服务。
This allows database tuning to be performed without concern for unknown additional workload.
这样,无需关心未知的额外工作负载就可以执行数据库调优。
Single-user database applications are very rare, so it is important to look at the performance behavior of a concurrent workload.
单用户数据库应用程序非常少见,因此考察并发工作负载的性能行为十分重要。
When a database server slows down, the added workload from people logging in to test and troubleshoot can easily make matters worse.
当一个数据库服务器的速度降低时,为进行测试和排除故障而增加的工作负载很可能使问题变得更严重。
A multiple copy design utilizes multiple copies of a database where the workload is distributed across the copies.
多重副本设计利用数据库的多个副本,工作负载分布在这些副本上。
DB2 configuration for this workload is described, including some of the key database features and tuning recommendations.
还描述了针对该工作负载的DB2配置,其中包括一些关键的数据库功能和调优建议。
To confirm placement options for DB2 objects on SSDs, we chose an IBM DB2 OLTP workload to drive a series of tests, starting with a baseline of all database files on HDDs.
为了证实DB2对象在SSD 上的性能效果,我们选择一个IBM DB2OLTP工作负载来进行一系列的测试,首先以所有数据库文件放在 HDD 上的场景作为基准。
The more active the poll, the more important the database technology becomes for managing the transaction workload, results, and reporting.
投票活动越是活跃,数据库也就变得越是重要,通过数据库技术可以管理事务工作负载、投票结果以及产生报告。
Each database is active, allowing for workload distribution.
每个数据库都是主动的,从而支持工作负载的分布。
The "good" implementation, Listing 9, minimizes the workload on the database.
清单9 显示了 “良好” 的实现,该实现尽量避免增加数据库上的工作负载。
You can use IBM DB2 server's Self Tuning memory Manager (STMM) to measure and analyze how DB2 database memory is consumed, and dynamically reallocate memory to optimize workload performance.
您可以使用IBMDB 2服务器的SelfTuningMemoryManager (STMM)来测量和分析DB 2数据库内存的消耗情况,同时动态地分配内存以优化负载性能。
If one of the servers in the high availability cluster fails, then the clustering software transfers the workload to the idle standby database server.
如果高可用性集群中某一个服务器出故障,那么集群软件就会将工作负载转移到idle备用数据库服务器。
On the primary site, an application workload can now run against the database, and the Metro mirror function automatically mirrors changes at the disk level to the target site.
在主站点上,应用程序工作负载现在可以针对此数据库运行,并且MetroMirror函数会自动将磁盘级别的更改镜像到目标站点。
In addition to high availability, Oracle rac can also be configured to provide workload balancing; workload balance to the database happens at the connection level.
除高可用性外,还可以将Oraclerac配置为提供工作负载平衡;数据库的工作负载平衡在连接级别发生。
To compare the performance of database access from PHP and Net.Data scripts, the IBM PHP Speed Team created a workload using the previously described example.
为了比较从php和net . data脚本访问数据库的性能,IBM PHPSpeedTeam使用先前描述的示例创建了工作量。
应用推荐