[DB] 评估系统的并发容量

博客首页 » DB 评估系统的并发容量

发布于 30 Nov 2015 16:05
标签 blog
最近回答了一个对系统容量评估的问题,记录一下。

问:如何估算一台数据库服务器能够承受的并发量?

答:你对系统介绍得太少,没法给具体建议,还是需要看你的目的,是做已有系统容量和瓶颈的评估,还是做系统选型。

主要的瓶颈有:
1 DB synchronization and concurrentcy
2 Application
3 DB IO
4 DB memory
5 DB CPU

最直接的方法是有已有的运维数据参考比较;如果没有那么就应该做整体的负荷测试。
只通过数据估算,很容易踩上预料之外的瓶颈。

下面几个估算文档也值得参考。Dell的
http://www.dell.com/downloads/global/solutions/Oracle_Advisor_Methodology.pdf?forcedownload=true

Amazon的
https://d0.awsstatic.com/whitepapers/determining-iops-needs-for-oracle-database-on-aws.pdf#search=%27oracle+capacity+performance+estimation%27

BEA的,是面向Application的
https://docs.oracle.com/cd/E13222_01/wls/docs81/capplan/capgen.html

Access Manager的,也可以作Application预估的参考
https://docs.oracle.com/cd/B28196_01/idmanage.1014/b25344/capacity.htm

比如看看能不能回答好这些问题:
Question 1: Is this database designed for Online Transaction Processing (OLTP) or Online Analytical
Processing (OLAP)? ……………………………………………………………………………………………………………………………..8
Question 2: Which of the following capabilities should be achieved?………………………………………………………..9
Question 3: How would you characterize your storage requirements?…………………………………………………….10
Question 4: Which server form factor and processor type do you prefer? ……………………………………………….12
Question 5: What is the maximum expected size of the database (include growth for the next three years) .13
? ……………………………………………………………………………………………………………………………………………………..13
OLTP workload specific questions: Q6 – Q8 ………………………………………………………………………………………….14
Question 6: What is the maximum number of concurrent application connections to the database?…………14
Question 7: Please enter your IOPs or MB/s throughput requirement (asked if question 1 OLTP was
selected)…………………………………………………………………………………………………………………………………………..16
Question 8: Please enter your I/O Bandwidth requirement (asked if question 1 OLAP was selected)………….17
Question 9: Please select any additional features that may apply……………………………………………………………17
Question 9a: Please describe the database landscape. Check all that apply. …………………………………………….19
Question 9b: Which application will be using the Oracle database? ………………………………………………………..19
Question 9c: How do you plan on backing up your Oracle database?………………………………………………………19


本页面的文字允许在知识共享 署名-相同方式共享 3.0协议和GNU自由文档许可证下修改和再使用,仅有一个特殊要求,请用链接方式注明文章引用出处及作者。请协助维护作者合法权益。


系列文章

文章列表

  • DB 评估系统的并发容量

这篇文章对你有帮助吗,投个票吧?

rating: 0+x

留下你的评论

Add a New Comment