In any real OLTP database, implementing this change can be a problem.
在任何真实的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 个索引,我还会赞成再添加一个吗?
We discovered that the default value for this parameter, 8 (4kb pages), usually is not big enough for an OLTP database.
我们发现该参数的缺省值为8 (4kb页),这对于OLTP数据库而言通常不够大。
For for a large OLTP database, set aside as much as memory as possible for the buffer pool while keeping the system stable.
对于大型OLTP数据库,在保持系统稳定的同时为缓冲池留出尽可能多的内存。
The testing that is described demonstrated that EFDs provide a substantial improvement (approximately 9X) in I/O performance when used in an OLTP database environment.
所讨论的这个测试说明了EFD用在一个OLTP数据库环境时能大大提高I/O性能(约为9倍)。
The OLTP database is always up to date, and reflects the current state of each business transaction.
OLTP数据库总是在更新中,并且反映了每个商业事务的当前状态。
The OLTP database is always up to date, and reflects the current state of each business transaction.
OLTP数据库总是在更新中,并且反映了每个商业事务的当前状态。
应用推荐