sho shibamura

Thank you for prompt response! I seem to have made too much. I will follow the document. I will also refer to the presentation. And now I am doing such a test. warehouse 20 (NOPM) Virtual Users|-ー1ー|-ー2ー|-ー10ー-|ー20ー|ー40ー|ー80ー -----------------|--------| --------| ----------|--------- | -------- | ------ --ー2008ー--|36221|76282|177934|190083|189660|187406 --ー2017ー--|29103|58350|130401|149149|146442|144063 I will first follow the advice. Thank you. I hope you will have a nice day.

Hi I am comparing SQL Server2008 and SQLServer2017. As a result, 2017 is low. I read the help of this site and various blogs, I tried tuning. Performance Monitor,wait_stats,MAX DOP,max server memory,Cardinality Estimate... But it was ineffective. Current results(NOPM) 1user 500users 2008 16845 183501 2017 23169 131926 (number of warehouses 20) I accidentally tried user 1 this morning, 2017 was higher. I do not know the reason yet. I am sorry, I can not read http://www.hammerdb.com/hammerdb_mssql_oltp.pdf...