| 作者 |
 向人民，祖国， 和波主席汇报我对通讯业的看法。（1） |
 |
| 所跟贴 |
PC内存已经两个G了， SERVER你来个10G的内存， 还有DISK ACTIVITIES吗？ -- 绽铃子 - (0 Byte) 2006-3-28 周二, 10:34 (340 reads) |
雨林
[博客]
[个人文集]
头衔: 海归少将
声望: 院士
性别: 
加入时间: 2006/01/22
文章: 2563
海归分: 239376
|
|
|
作者：雨林 在 海归商务 发贴, 来自【海归网】 http://www.haiguinet.com
https://www.anandtech.com/IT/showdoc.html?i=1935&p=7
The Database Server Bottleneck
There is almost always a bottleneck in hardware tests — ours was the database. The majority of web applications require a database server for data retrieval and storage. We used Microsoft SQL Server 2000 as our back-end database server for these tests. Prior web server tests that we’ve performed have been on single or dual CPU servers and have reflected accurately the performance of the hardware on which the tests were run. When we started running the tests on the servers, specifically the Opteron, we found that the tests had hit a wall and were not reflecting accurately the performance of the hardware. The issue was I/O, the largest bottleneck in any database server. We were putting so much load on the servers to get the CPU working hard that the database server I/O was maxed out. This, of course, caused the web tests to hit a performance plateau as each request run against the web application server has to wait for the database to complete its data transaction.
So how do you get rid of an I/O bottleneck? Well, if you have the resources, you throw more disks at the problem. The problem with that solution is it gets expensive to have massive RAID arrays that are just used for testing purposes and have to be continually upgraded as hardware improves. To get around this expensive issue, we used the fastest and most inexpensive storage medium you can — memory. We created a RAMDISK and put the database on that new drive. RAMDISK has been around for years and has matured over the years to solutions that can be formatted as NTFS drives, which are easier to manage. Effectively, a RAMDISK partitions a portion of physical memory and allows it to be formatted as a drive letter that is available to the operating system.
Once we solved our bottleneck, the testing began and as you read on, you’ll see how the different platforms performed while under real-world web application load.
作者：雨林 在 海归商务 发贴, 来自【海归网】 http://www.haiguinet.com
|
|
|
| 返回顶端 |
|
 |
|
| |
|
|
|
您不能在本论坛发表新主题, 不能回复主题, 不能编辑自己的文章, 不能删除自己的文章, 不能发表投票, 您 不可以 发表活动帖子在本论坛, 不能添加附件不能下载文件, |
|
|
