[B! benchmark] hikomaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hikoma id:hikoma

benchmarkã«é–¢ã™ã‚‹hikomaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

SQLIO ã‚’ä½¿ç”¨ã—ãŸãƒ‡ã‚£ã‚¹ã‚¯ I/O ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯
ä»¥å‰ã€SQLIOSIM ã‚’ä½¿ç”¨ã—ãŸã‚¹ãƒˆãƒ¬ã‚¹ãƒ†ã‚¹ãƒˆã®å®Ÿæ–½ ã¨ã„ã†æŠ•ç¨¿ã‚’æ›¸ãã¾ã—ãŸã€‚ SQL Server ã® IO ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ SQLIO Disk Subsystem Benchmark Tool (SQLIO) ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã—ã¦ãƒ‡ã‚£ã‚¹ã‚¯ I/O ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å®Ÿæ–½ã™ã‚‹ãŸã‚ã®æ–¹æ³•ã‚’è»½ãã¾ã¨ã‚ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ SQLIO, PowerShell and storage performance: measuring IOPs, throughput and latency for both local disks and SMB file shares ã‚‚ã¨ã¦ã‚‚å‚è€ƒã«ãªã‚Šã¾ã™ã®ã§ã“ã¡ã‚‰ã‚‚ä¸€èªã—ã¦ã¿ã‚‹ã¨ã‚ˆã„ã‹ã¨ã€‚ â– ãƒ„ãƒ¼ãƒ«ã®å®Ÿè¡Œæ–¹æ³• SQLIOSIM ã¯ GUI ã‹ã‚‰å®Ÿè¡Œã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸãŒ SQLIO ã¯ CUI ã®ã¿ã®ãƒ„ãƒ¼ãƒ«ã¨ãªã£ã¦
hikoma 2013/06/17
SQL Server

tuning

benchmark
ãƒªãƒ³ã‚¯
Provisioned IOPSã®æ¤œè¨Ž - JPOUG Advent Calendar 2012 - SH2ã®æ—¥è¨˜
2012å¹´9æœˆã«Amazon RDSã§Provisioned IOPSã¨ã„ã†ã‚µãƒ¼ãƒ“ã‚¹ãŒåˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚æœ¬æ—¥ã¯ã“ã‚Œã‚’é¡Œæã«ã—ã¦ã€IOPSã‚’ä¿è¨¼ã™ã‚‹ã¨ã„ã†ã“ã¨ã«ã¤ã„ã¦å‹‰å¼·ã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯ã€JPOUG Advent Calendar 2012ã®17æ—¥ç›®ã¨ãªã‚Šã¾ã™ã€‚16æ—¥ç›®ã¯@maroon1stã•ã‚“ã§ã—ãŸã€‚ Amazon RDSã«ã¤ã„ã¦ã¯ã€@horiuchiã•ã‚“ãŒ15æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¾ã¨ã‚è¨˜äº‹ã‚’æ›¸ã„ã¦ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ã€‚Provisioned IOPSã«ã¤ã„ã¦ã¯è¨˜äº‹ã®åéŸ¿ã§ç¬¬3ä½ã¨ã„ã†ã“ã¨ã§ã€ãªã‹ãªã‹æ³¨ç›®åº¦ãŒé«˜ã‹ã£ãŸã“ã¨ãŒåˆ†ã‹ã‚Šã¾ã™ãã€‚ Amazon RDS 2012å¹´ ã‚µãƒ¼ãƒ“ã‚¹ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã¾ã¨ã‚ - Amazon Web Services ãƒ–ãƒã‚° ã€AWSç™ºè¡¨ã€‘Amazon RDS ã§ãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãªãƒ—ãƒãƒ“ã‚¸ãƒ§ãƒ³ãƒ‰IOPSã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’åˆ©ç”¨å¯èƒ½ã«(æ±äº¬ãƒªãƒ¼ã‚¸ãƒ§ãƒ³
hikoma 2012/12/17
benchmark

iops
ãƒªãƒ³ã‚¯
Iozone Filesystem Benchmark
IOzone is a filesystem benchmark tool. The benchmark generates and measures a variety of file operations. Iozone has been ported to many machines and runs under many operating systems. Iozone is useful for performing a broad filesystem analysis of a vendorï¿½s computer platform. The benchmark tests file I/O performance for the following operations: Read, write, re-read, re-write, read backwards, rea
hikoma 2012/07/23
performance

tool

benchmark
ãƒªãƒ³ã‚¯
Oracle ORION Downloads
hikoma 2012/07/23
performance

tool

benchmark
ãƒªãƒ³ã‚¯
Bonnie++ now at 1.03e (last version before 2.0)!
Want to sponsor development of Bonnie++? If so see this link for details. The benchmark category of my blog has posts related to Bonnie++ and other benchamrk development work. It also includes information on Postal my mail host server benchmark. Version 1.04 will hopefully be the last release of Bonnie++ 1.x. I hope that now I can concentrate on version 2.0 which will have many new features. I kne
hikoma 2012/07/23
performance

tool

benchmark
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5) - SH2ã®æ—¥è¨˜
ã¨ã„ã†ã‚ã‘ã§ã€JPOUG> SET EVENTS 20120721 | Japan Oracle User Groupã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é€šå¸¸ã®å‹‰å¼·ä¼šã¨æ¯”ã¹ã¦ç™ºè¡¨è€…ã¨è´è¬›è€…ã®ä¸€ä½“æ„Ÿã‚’å¢—ã™ãŸã‚ã®å·¥å¤«ãŒãªã•ã‚Œã¦ã„ã¦ã€ã¨ã¦ã‚‚è‰¯ã‹ã£ãŸã¨æ€ã„ã¾ã™ã€‚æœ‰é™ã‚³ãƒ¼ãƒ’ãƒ¼ã‹ã¨æ€ã£ãŸã‚‰ç„¡é™ãƒ“ãƒ¼ãƒ«ã ã£ãŸã®ã‚‚é©šãã§ã™ã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5)ã¨é¡Œã—ã¦éŽåŽ»4å›žåˆ†ã®ã¾ã¨ã‚ã¨è‡ªä½œãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚JdbcRunnerã¯Oracle Databaseã€MySQLã¨PostgreSQLã®é–“ã§TPC-Bã¨TPC-Cã®æ€§èƒ½æ¯”è¼ƒãŒã§ãã‚‹å”¯ä¸€ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã®ã§ã€ã„ã‚ã„ã‚è©¦ã—ã¦ã¿ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚è©¦ã—ãŸçµæžœ
hikoma 2012/07/23
database

performance

benchmark
ãƒªãƒ³ã‚¯
1